On a saved search, how can you, in a formula, spec...
# suitescript
s
On a saved search, how can you, in a formula, specify that you want the text and not the id?
s
I don't believe saved search formula offers you that option unless you can join to the record. Suite Analytics definitely does
b
@Sandii Are you referring to Workbook or Dataset?
s
Those are the same thing to me, you can pick if you want id or display in formulas in suite analytics
e
you can - if you add .id so, for example, if you were searching transactions and added a formula for
{item}
simply add .id to make
{item.id}
even without joining, actually, this will work as well
s
Yeah, I had 2 fields with the same label. For all of my searches, I have a library that converts it to json. So if there are 2 item labels, 1 overrides the other. Thanks everyone!