2 Replies Latest reply: Aug 9, 2013 1:53 AM by Gustav Gnosspelius RSS

    Select all fields where value occur

      I've got 3 fields; ID, Name1, Name2. I've created an input box with a list of all the names that may occur in either field. Now I want to create a Select field-action that finds any occurence of the name. I guess I need to create a fourth field in the script that merges all names, and then do a wildcard search in that field and select the ID-field when a match is found. If that is the correct solution, what is then the correct search string syntax?

       

      Example:

       

      IDName1Name2
      1JohnJohn
      2LisaAnna
      3JohnRuth
      4AnnaPeter
      5PeterJohn

       

      If I select "John" in the input box the following should be selected:

       

      IDName1Name2
      1JohnJohn
      3JohnRuth
      5PeterJohn

       

      How do I accomplish this?

       

      Thanks in advance