Hi Avi, I just tried in 10.4 and it doesn't seem to work, neight does the iMatch but I am just wondering how you wanted to use it. The problem might be it takes a field and see if that value is in the field, so might not translate properly over to VBA.
Hi Brian, it just seems more elegant to ask if ilist (parent, "father", "mother", "grandpa") instead of asking if parent = "father" or parent = "mother" or parent = "grandpa" and so on
I agree, many languages allow you to do this with an array but unfortunately you can't do that with IDEA directly. Is this something you do often? I could create a function which would do this, basically you would create an array to hold the list and then the function searches the array for a hit.
I have located an IDEA v8 Tutorial & saved the appendix listing functions to a separate file, then converted to PNG. Not all functions are supported in later versions of IDEA, but this at least gives interested parties a starting point to document "i-functions". As I have time I will create a script to determine what is functioning in IDEA v11.1
NOTE: Some are valid VBA Functions, but it will be nice to find iFunctions for VBA Functions IDEA Script does not recognise
Might be I lack the permissions? I attached a screen shot.
Thanks :)
It was my bad, it should be fixed now, sorry about that.
I see the difference; thanks!
I just noted that ilist does not work in version 10.3, I don't know if it worked in previous versions.
Hi Avi, I just tried in 10.4 and it doesn't seem to work, neight does the iMatch but I am just wondering how you wanted to use it. The problem might be it takes a field and see if that value is in the field, so might not translate properly over to VBA.
Hi Brian, it just seems more elegant to ask if ilist (parent, "father", "mother", "grandpa") instead of asking if parent = "father" or parent = "mother" or parent = "grandpa" and so on
I agree, many languages allow you to do this with an array but unfortunately you can't do that with IDEA directly. Is this something you do often? I could create a function which would do this, basically you would create an array to hold the list and then the function searches the array for a hit.
I have located an IDEA v8 Tutorial & saved the appendix listing functions to a separate file, then converted to PNG. Not all functions are supported in later versions of IDEA, but this at least gives interested parties a starting point to document "i-functions". As I have time I will create a script to determine what is functioning in IDEA v11.1
NOTE: Some are valid VBA Functions, but it will be nice to find iFunctions for VBA Functions IDEA Script does not recognise
Thanks for posting.
Pages