0

choice based on text entered in other field

Hi, I am trying to automate that if some certain words are inserted into a field, then the choice field would show the selected value.

i.e. in description field if we enter 'taxi', 'plane' or 'ship' then the category choice it will show 'transport'. 

But when we enter 'cookies', 'breakfast' or 'lunch' then in category choice it will show FnB. other than that it will be default value (null).

thank you

2 replies

null
    • Nick
    • 4 yrs ago
    • Reported - view

    Hi,

    you can use something like this in the box 'Trigger After Update':

     

    if Description like "taxi" or Description like "plane" or Description like "ship" then
    YourChoiceField := text("Transport")
    else
    if Description like "cookies" or Description like "breakfast" or Description like "lunch" then
    YourChoiceField := text("FnB")
    end
    end

    • dwiandi_gmailcom
    • 4 yrs ago
    • Reported - view

    thank you it works!

Login to reply

Content aside

  • 4 yrs agoLast active
  • 2Replies
  • 1171Views