Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
ID | Name1 | Name2 |
---|---|---|
1 | John | John |
2 | Lisa | Anna |
3 | John | Ruth |
4 | Anna | Peter |
5 | Peter | John |
If I select "John" in the input box the following should be selected:
ID | Name1 | Name2 |
---|---|---|
1 | John | John |
3 | John | Ruth |
5 | Peter | John |
How do I accomplish this?
Thanks in advance
Excellent, thank you a lot! There was an ampersand missing and by removing the $-sign (don't know what it does). I got it working with this formula:
='=Name1=' &chr(39)& vInputBox &chr(39) & ' or Name2=' &chr(39)& vInputBox &chr(39)
IMHO, selecting in ID field is the right approach.
You can create a Select - Select in field action for a button action and then create a search string like
='=Name1=' &chr(39)& $(vInputBox) &chr(39) ' or Name2=' &chr(39)& $(vInputBox) &chr(39)
Excellent, thank you a lot! There was an ampersand missing and by removing the $-sign (don't know what it does). I got it working with this formula:
='=Name1=' &chr(39)& vInputBox &chr(39) & ' or Name2=' &chr(39)& vInputBox &chr(39)