Skip to main content

Using Client Object in Custom Function

Is there any way to use the Client Object of Idea in a custom Function?
I want to use Client.RunIDEAScriptRV within my Custom Function.

Brian Element Fri, 02/19/2021 - 06:28

Hi Nils,

You might be able to do it through the CreateObject or GetObject functions but I wouldn't recommend it.  One problem is you would be calling IDEA from within IDEA and I am not sure how that would be handled and also using the RunIDEAScriptRV would be calling your script for each row as the custom function works row by row.  So if you have a 100,000 record file  you would be calling the ideascript 100,000 times, this would be extremely slow.  It would be better to incorporate your script directly in the Custom Function so that it will work as efficiently as possible.

Brian