Choice based on field content

This is a typical MAC address for a Dante device:  


What defines it as such is the 1D (second pair).

I have 4 input fields MAC1, MAC2, MAC3, MAC4.  The above address could be entered into any of the 4 MAC fields.  Currently I enter the MAC address and then choose which entry relates via a choice field "DANTE SELECT" with 4 choices MAC1 through to MAC4.

What I am trying to do is use trigger after update in each MAC input field and check if the 'D' (5th character) is present in either of the 4 MAC fields and choose the corresponding 'Choice'.  So if MAC1 is the 'D' entry then DANTE SELECT shows MAC1

Here you can see a screenshot

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Fred
    • Fred
    • 4 mths ago
    • Reported - view

    Take a look at the substring function to find out what is in the 5th position of the text field.

    Do you need help with setting the choice field?

      • Alan Cooke
      • Alan_Cooke
      • 4 mths ago
      • Reported - view

      Fred Thanks Fred - worked a treat.

Like Follow
  • 4 mths agoLast active
  • 2Replies
  • 28Views
  • 2 Following