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 would you set value of a list/record field when it matches a free-form text field?
Two custom fields on an Item Fulfillment record:
1. Truck ID (Free-Form Text sourced from an outside application when a driver completes a delivery.)
2. Vendor Trucks (List/Record Field containing only the IDs of Trucks owned by Vendors. Source of this field is a custom Record Type)
The goal:
Select value of "Vendor Trucks" if the Truck ID matches. Else, leave blank.
The problem:
The Truck ID is free-form text that I cannot seem to reference from a Workflow (screenshot)
I might be missing something obvious.
My questions:
Does this require a Script? Could I capture this using SQL in a Formula Field? WWGD - what would a guru do?