If you're loading a saved search and want to acces...
# suitescriptc
Craig
05/26/2021, 3:34 PMIf you're loading a saved search and want to access multiple formula columns, do you always have to refer to the columns by their index number? They all have the same internal id/name so I assume yes. It seems like quite a brittle way to do it as someone could change the column index by introducing a new column.
c
creece
05/26/2021, 3:35 PMyes
c
Craig
05/26/2021, 3:35 PMDamn...
c
creece
05/26/2021, 3:35 PMYeah its not the best but thats how you do it
s
stalbert
05/26/2021, 3:38 PMcan't you give a custom label to each formula column?
c
Craig
05/26/2021, 3:40 PM@stalbert I literally just thought of that and I'm testing it now - I think the answer is yes though
c
creece
05/26/2021, 3:53 PMI believe i tried that in the past and it made me access via index no matter what after the 1st one
creece
05/26/2021, 3:53 PMif it works, i'd be curious to see for sure
c
Craig
05/26/2021, 3:55 PM Copy code
formulanumeric: "2000",
formulanumeric_1: "500"Craig
05/26/2021, 3:55 PMThat's what I see when I log the result
Craig
05/26/2021, 3:55 PMSo it looks like the custom label doesn't work @stalbert @creece
Craig
05/26/2021, 3:56 PMmessage has been deleted
c
creece
05/26/2021, 3:56 PMit may work with just 1 formula column just like you can access the formula fields if there's just 1 of the formula types
c
Craig
05/26/2021, 3:58 PMThere's a few formula columns in this search though
c
creece
05/26/2021, 3:59 PMYeah i'm just saying it may work with 1 vs X. Column index is the way to go with X. It just sucks if someone messes with your search and re-orders something.
b
battk
05/26/2021, 4:01 PMuse search.createColumn to create the matching column
battk
05/26/2021, 4:01 PMand use that column with getValue
s
stalbert
05/26/2021, 4:06 PMor consider SuiteQL?
3 Views