Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
How to make a text field specify the data for a list field?
Lets say we had a list field that used this list....
COLOR: INTERNAL ID
red 1
green 20
blue 30
Then we wanted to do a mass update to populate that list selection for a number of records and our formula looked at a different text field and if text was like 'red%' then 1, and like 'green%' then 20, like 'blue%' then 30.
I tried a formula like that (but properly formatted) and I got a mismatched data/wrong data type error. IS this not possible? Can we not populate a list field by providing the matching text values from a text field?