Forum Discussion
NingLi
5 years agoQrew Trainee
Yes. Trying to find, i.e. 20 projects by searching in "project name" field in Project Table.
------------------------------
Ning W
------------------------------
------------------------------
Ning W
------------------------------
MarkShnier__You
Qrew Legend
5 years agoHow to do this is to create a single record in a single table called search. In that single record which will be record ID number one you will have a big text box where the user can enter or paste in a bunch of search terms.
Then make a relationship between that search record and all of your details record and the reference field for the relationship on the detail side will be a field called
[Link to Serach (=1)]
Be a formula field with a formula of
1
Look up the search values down into your detail records. Make a formula field down there called [valid for Search?] which will calculate to true if the search values contain the value in the field [Project name]
IF(Contains([Search Terms lookup], [Project Name]), true)
A report link on that search terms record to display all of the detail records but for the embedded report that is used on the record filter it where
[Valid for Search?] is checked.
The effect of the set up is the user will edit the search record paste in the values and save and the results will display right on that record.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Then make a relationship between that search record and all of your details record and the reference field for the relationship on the detail side will be a field called
[Link to Serach (=1)]
Be a formula field with a formula of
1
Look up the search values down into your detail records. Make a formula field down there called [valid for Search?] which will calculate to true if the search values contain the value in the field [Project name]
IF(Contains([Search Terms lookup], [Project Name]), true)
A report link on that search terms record to display all of the detail records but for the embedded report that is used on the record filter it where
[Valid for Search?] is checked.
The effect of the set up is the user will edit the search record paste in the values and save and the results will display right on that record.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------