On a saved search, how can you, in a formula, specify that you want the text and not the id?
s
Sandii
09/20/2022, 4:57 PM
I don't believe saved search formula offers you that option unless you can join to the record. Suite Analytics definitely does
b
Boris Yasen
09/20/2022, 5:01 PM
@Sandii Are you referring to Workbook or Dataset?
s
Sandii
09/20/2022, 5:44 PM
Those are the same thing to me, you can pick if you want id or display in formulas in suite analytics
e
ec
09/20/2022, 6:16 PM
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}
ec
09/20/2022, 6:17 PM
even without joining, actually, this will work as well
s
screnshaw
09/21/2022, 3:45 PM
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!