Search bar -

Question

Hi,
My question is similar to a question in another post:
https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&amp;MID=33881&amp;CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&amp;tab=digestviewerI'm essentially wanting to do the same thing. I want to create a handful of reports that are able to search one specific field only (i.e. the 'Notes' field) for specific keywords using the search tool. I know I can make fields unsearchable. However, that doesn't fit my need. This would need to be accomplished at the report level for it to work.More details:I'm looking for the best way to exclude a handful of fields from being searchable (or include/search only one specific field) when using the search bar in all of our Kanban reports.When using the search tool here...It will search every field that is searchable.I know that I can go into the field and deselect the searchable field here:However, I don't want to make the field unsearchable in every report, only a handful of them.One thought I had is to control the searchability from the report level here, but not sure if there's a place to do that...Any recommendations?
------------------------------Mathew Crist------------------------------

justintorrence · Answer

@Mathew Crist
If leveraging the new #Dashboards feature is an acceptable solution, this will give you the ability to filter on one column only (without changing global field settings).
Here's a link to the documentation: https://help.quickbase.com/user-assistance/using_dashboards.html
Also, @James Travaglini covers this in an Empower Quick Hit here:
https://www.youtube.com/watch?v=QsL1sMSabbE​
You could even throw many Kanban reports on one dashboard and filter them all at the same time.
​​------------------------------Justin TorrenceQuickbase Expert, Jaybird Technologiesjtorrence@jaybirdtechnologies.comhttps://www.jaybirdtechnologies.com/#community-post------------------------------

markshnier__you · Answer

Crazy idea, but you can make a Connected Sync Table of the Table with the Kanban, and mark most fields unsearchable. The data would be up to 59 minutes out of date as the sync runs every hour.

But then you would not be able to edit records, just search. But you could have a hyperlink on the Kanban card to edit, which would link to edit the real record. ... just trying to think outside the box.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

mathewcrist · Answer

Very cool! I will explore this further. The date range and the text filters are very useful.------------------------------Mathew Crist------------------------------

mathewcrist · Answer

Thanks Mark, this is an interesting option and I can see it being very useful for other use case scenarios. Unfortunately for this particular scenario, the ability to edit is also needed.

------------------------------
Mathew Crist
------------------------------

markshnier__you · Answer

Well another simple stupid idea is to make an <ask the user> filter on the [Notes] Contains field on a Kanban report. So run the report, answer the question, and land on the Kanban results.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

Forum Discussion

Search bar -