Forum Discussion

JENNIFERPASCHAL's avatar
JENNIFERPASCHAL
Qrew Trainee
5 years ago

Search widget change default columns

Hello,

I have a search bar widget on my home page in the format of select what you want to search on and then search:


I have it set to fields I choose. Is there anyway to change what report the user searches on without using the "report" options. I want allow them to search on the three fields selected in the first image, but when I test this I am taken to a report that does not have one or more of those fields present. Example: if I search for my name in Submitter, a report will come up with "Submitter contains 'Jennifer'" but the Submitter field is not in that report. Edit: There is also a field I want to allow users to search on that is not in the "fields I choose" list. How could I add fields to this list?

Please let me know if this does not make sense! Thanks!



------------------------------
Thanks in advance,
Jennifer Paschal
------------------------------
App home pages
reports and charts
Search
  • DonLarson's avatar
    DonLarson
    Qrew Elite
    5 years ago
    Jennifer,

    If there is only one record that matches the Search then it will take you to that specific record.  If there is more than one answer, then it opens the Default report for that table.


    Here is a screen shot from the Table Settings where you can change that report.  



    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------