How to use IDEA equations in scripts and custom functions

31 posts / 0 new
Last post
robgentile
Offline
Joined: 08/05/2014 - 10:29

Might be I lack the permissions? I attached a screen shot.
 

Images: 
robgentile
Offline
Joined: 08/05/2014 - 10:29

Thanks :)

Brian Element's picture
Brian Element
Online
Joined: 07/11/2012 - 19:57

It was my bad, it should be fixed now, sorry about that.

robgentile
Offline
Joined: 08/05/2014 - 10:29

I see the difference; thanks!

avikerem's picture
avikerem
Offline
Joined: 04/07/2015 - 00:28

I just noted that ilist does not work in version 10.3, I don't know if it worked in previous versions.

Brian Element's picture
Brian Element
Online
Joined: 07/11/2012 - 19:57

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.

avikerem's picture
avikerem
Offline
Joined: 04/07/2015 - 00:28

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

Brian Element's picture
Brian Element
Online
Joined: 07/11/2012 - 19:57

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.

KrisW
Offline
Joined: 02/16/2015 - 13:38

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

Images: 
Brian Element's picture
Brian Element
Online
Joined: 07/11/2012 - 19:57

Thanks for posting.

Pages