Search for a large number of items

Question

Given a table 'foo' how can I search for a number of items at once?

Table Foo with several thousand records;
fields Name, Email.

Search for 'Alice, Bob, Charlie, and Egbert' and return rows with those values.

A table report looks like it would be the right tool [1], but I don't see how to include an array of names that might run to hundreds.

My workaround is to export the table to .csv file and do this using shell but that seems like something QB should be able to handle natively.

Like so (pseudo shell follows)

$ cat list.csv | grep [Alice, Bob, Charlie, Egbert] > extract.csv

[1] https://help.quickbase.com/user-assistance/multi_select_filter.html

Thanks in advance,

------------------------------
Brian Dunbar
------------------------------

MarkShnierYou · Answer

No problem.Make a new table called Search. Create one big multi line field called  [Search Terms].Create one record in that table. It will be [Record ID #] =1Lock down Search terms Permissions so no one can add or delete that record. Make a relationship to detail table based based on a reference formula Field  formula of 1.Look up Search terms to detail table. Make a formula field to calculate to true of the record matches the search terms. Now, back to the single Search term Record.   Put the Report Link field fro the relationship onto the  form and set the embedded  Report filter where the detail records qualify for  the Search term.All done!Edit the search record and enter your search terms. Save.The qualifying detail records will be on the report link file embedded child report!------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community