Jamievanzone Posted January 8, 2020 Report Share Posted January 8, 2020 Can one search box search multiple columns from a table? I have 4 different telephone number tabs in my table and want one search field to search all four tabs at once, is this possible? Quote Link to comment Share on other sites More sharing options...
0 Vitalikssssss Posted January 8, 2020 Report Share Posted January 8, 2020 Hi @Jamievanzone, This should help: Regards, Vitalikssssss Quote Link to comment Share on other sites More sharing options...
0 NailDyanC Posted October 31, 2020 Report Share Posted October 31, 2020 Hello, just to add in the previous comment above. As I understand, you want to create a search field which can search to the different fields, right? If that is the case, on your table, add another field and set it to Formula. Then, concatenate the fields you want to use in your report. If all your field are in Text datatype , you can use [@field:FieldName1] + ' ' + [@field:FieldName2] + ' ' + [@field:FieldName2] .......... on your Formula Field. Then, use this formula field as your search criteria, it should look like the attached screenshot. I hope that helps. Quote Link to comment Share on other sites More sharing options...
Question
Jamievanzone
Can one search box search multiple columns from a table?
I have 4 different telephone number tabs in my table and want one search field to search all four tabs at once, is this possible?
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.