Hello, is it possible to get each of the results and the column values returned by a saved search with a scheduled script? Then create a transaction record where the lines would be line for each record returned by the saved search.
w
Watz
06/02/2021, 8:43 PM
Yes.
create a transaction, run the search and loop over search result and add lines, save transaction.
p
Phillip
06/02/2021, 8:44 PM
Watz. Whats the correct code to get the field values from the saved search?
Phillip
06/02/2021, 8:44 PM
and thank you
Phillip
06/02/2021, 8:47 PM
its a grouped search and I need to get the proper column names
w
Watz
06/02/2021, 9:38 PM
Read up on performing searches in the help. searchResult.getValue()
p
Phillip
06/02/2021, 9:49 PM
I have one more question. whats the best function to use to add a line each time it loops through each results of the search?