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?
If I select "John" in the input box the following should be selected: