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 wit...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendNo 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 #] =1
Lock 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 Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
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 #] =1
Lock 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 Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Mark,
I appreciate your help. I'll hit this in the morning and hopefully it will make sense.
Is this documented somewhere? It seems to be a pretty useful trick. Perhaps I simply don't know the right term to search for.
------------------------------
Brian Dunbar
------------------------------- MarkShnier__YouQuickBase, is kinda like a workshop with a set of tools. There are instructions on how to use a drill or a hammer, but not how to build a birdhouse.
But then we have have a club of woodworkers here on the Community Forum who can help with how to build the birdhouse once you know how to work the drill.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- MarkShnier__YouOther good sources of "how to" videos are the YouTube Chanel by Kirk Trachy. He is a long time QuickBase evangelist and sales engineer. If you Search this forum for his name his signature lines also state his multiple weekly Office Hours where anyone can ask live questions.
Also Sharon Faust, a.k.a. Ms QuickBase Junkie has a bunch of free videos posted which illustrate techniques.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
