Hi there, I am wondering is there a way to search multiple records and open multiple records windows with one button/click? Thank you. I am asking this because a colleague needs to update some fields of multiple records, could be dozens or hundreds. Those records could be randomly picked, hard to cover all of them by creating a report by single or multiple field properties. 1. He wants a search box can paste all the record names one time and get a list of these records. 2. Even there was a report for him and he knew how to use Grid Edit, he still wants to open all records windows at one click. Is it something possible? without advanced API and developer function. Ning------------------------------Ning W------------------------------

Are you trying to search against a single field in a single table?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Yes. Trying to find, i.e. 20 projects by searching in "project name" field in Project Table.------------------------------Ning W------------------------------

How 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 1Look 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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Hi Mark, Thank you so much! I feel awkward to say I was stuck in the first step. What is the type of search box in Search table? I am using lookup text, but always get "The Relationship of which this field is a part no longer exists. You may want to delete this field".How can I have a bog text box for input search terms?Thank you. ------------------------------Ning W------------------------------

No problem. Just create a field which is type multi line text.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Is there a way to search multiple records and open multiple records with one button/click?

MarkShnier__You
Qrew Legend
4 years ago
Are you trying to search against a single field in a single table?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- NingLi
  Qrew Trainee
  4 years ago
  Yes. Trying to find, i.e. 20 projects by searching in "project name" field in Project Table.
  
  ------------------------------
  Ning W
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    4 years ago
    How 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
    ------------------------------

Forum Discussion

Is there a way to search multiple records and open multiple records with one button/click?

Related Content

Edit Multiple Records at Once with Grid Edit

How to consolidate multiple rows into one

Building a report from multiple tables

Check one field for multiple conditions

Multiple reference proxy fields help

Recent Discussions

Expanded URL from Reports

Pipeline Error --> "Quickbase reported an error: No error"

View query record if single record otherwise view query list

How do I unhide an app that I have no idea what it is named?

Gnatt plugin