Using Client Object in Custom Function

2 posts / 0 new
Log in or register to post comments
Last post
Fri, 02/19/2021 - 03:47
#1
NilsAchim
Offline
Joined: 06/24/2016 - 12:57
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.

Top
Fri, 02/19/2021 - 06:28
Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

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

 

Top