Forum Stats

  • 3,686,900 Users
  • 61,168 Discussions
  • 206,738 Comments

Discussions

Check out Oracle NetSuite upcoming events and conferences here
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now!
RUN, DON’T WALK...Registration for #SuiteWorld 2022 is officially OPEN! This special early bird price won’t last long, so make sure you don’t miss out: https://lnkd.in/gGRN78A3
YOUR VOICE MATTERS! VOTE FOR OUR NEXT WEBINAR TOPIC NOW.
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?

edited Sep 23, 2020 1:55PM in Ask A Guru 9 comments

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?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!

Leaderboard

This Week's Leaders

This Month's Leaders

All Time Leaders