Click on this link for the poll.
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)
Select value of "Vendor Trucks" if the Truck ID matches. Else, leave blank.
The Truck ID is free-form text that I cannot seem to reference from a Workflow (screenshot)
I might be missing something obvious.
Does this require a Script? Could I capture this using SQL in a Formula Field? WWGD - what would a guru do?