Is there any way to do a search to get the (displa...
# suitescripta
Azi
05/30/2022, 2:00 PMIs there any way to do a search to get the (display) name of a sublist field?
For example if I pass it it
pricePrice Levelcustcol_my_column_for_dataAzi
05/30/2022, 2:07 PMSo it seems for custom columns, if I had the internal id, I could load the record and do rec.getValue('label')
Azi
05/30/2022, 2:09 PMHowever this isn't going to help for 3 reasons.
1. I don't have the internalid
2. I need to get many at a time so a a record load wont work
3. It won't help for native fields
Azi
05/30/2022, 2:09 PMAny ideas of how I could accomplish this?
e
ehcanadian
05/30/2022, 2:16 PMcreate a record in memory and then use
myRec.getSublistFieldsmyRec.getSublistFielda
Azi
05/30/2022, 2:27 PM@ehcanadian Thanks for your response. I don't understand the suggestion.
You mean I should create a custom record to store all the fields and labels?
e
ehcanadian
05/30/2022, 2:28 PMNo, it's already stored. Use record.create
a
Azi
05/30/2022, 2:31 PMI see. You mean if I do getField and then I call getColumn on that, I can the label from there
e
ehcanadian
05/30/2022, 2:36 PMYou have the column names, so for each column name you would use getSubListField to get the label
ehcanadian
05/30/2022, 2:36 PMassuming it's not joined, that's more work of course
a
Azi
05/30/2022, 2:38 PMI see. Perfect. Worked Beautifully.
Thanks @ehcanadian!
47 Views