Search for a large number of items
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
------------------------------
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
------------------------------
