I want to use an inbox to allow filtering of multiple text values (part numbers).
The records in my main table are sales records with date, part numbers, qty and price.
In the inputbox I want to enter e.g. 5 part numbers (comma seperated) and use these parts numbers (e.g. AB0001, AB 2012, CD0003, DF0999, RT50001) as a filter for the main table so the result will be that I onnly have sales date for the 5 parts numbers enterted in the input box.
Firstly, is this really necessary? If the part numbers are exposed in a list, then it is easy for the users to make the selections and there is no need for variables, buttons, actions etc.
But assuming you have a good reason, then you can add a variable and an input box for the user to enter a comma-separated list. Then link a Select in Field action to a button or text object and use an expression like $(='(' & Replace(vInputList, ',', '|') & ')') as the search expression.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
... it worked thanks a lot!