[karenn]

Hello all,

We are trying to write a suitelet that runs a saved search and pulls values from that saved search. Normally that is no problem using getValue() but this particular saved search has 12 Formula(currency) columns and it seems they all have the same name ‘formulacurrency’. How can we get each of the 12 values if they all have the same name?

Thanks,

Karen
This is a cached copy. Click here to see the original post.

[cblackburn]

This can be accomplished by passing into getValue(columns[n]) a reference to the search column whose value you would like to retreive.

https://system.netsuite.com/app/help…988464355.html

[karenn]

Thanks!!! I have been using the option version for everything I forgot that version existed! Worked like a charm

[leacelosacolumna]

Originally posted by cblackburn

View Post

This can be accomplished by passing into getValue(columns[n]) a reference to the search column whose value you would like to retreive.

https://system.netsuite.com/app/help…988464355.html

This is also my favorite way of retrieving search result values when there are tons of multiple columns in my search. One gentle reminder though is you must remember that you had this approach in one of your scripts. Once you or any user makes some changes to the search columns it will cause discrepancies in your script. Happened to me once. Better restrict access to the search or label the search like “SCRIPT USE – DO NOT CHANGE!”

[Author]

Posts