We have recently launched an internal dashboard which allows employees to search specific parts of our database, however users have mentioned that the search function on the single record pages are too broad.
For example, we we have a location called “XYZ Gardens” and when you search for that term it is currently showing every instance of that term in every field, even unrelated records. Is there a way we can limit which fields this search is looking at? Similar to how it works with Linked Records within the base?
Unfortunately, there is no current way of limiting which fields this search is looking at. However, here is a workaround you might use for your case:
copy the URL of your Single record page without the record id (it will then end with &record_id=)
in the table you want to look at, create a formula-type column (let’s call it “Single Record URL”. In the formula field, paste the part of the URL you just copied between single or double quotes and add & rowID().
in the same table, create a button column with action “Open URL” and in the URL field enter the name of your URL column between curly braces ({Single Record URL} in my case).
in your app, you can now add a query page. This page allows you some finer tuning of the fields your looking at. You can hide unnecessary columns in the results by unchecking them in “Preset column hidden” under “Data settings”. Please note that you have to keep both the columns you just created visible
you can now use the query page to search for records. Once you find the record, you can click the button to be automatically directed to the single record page of this particular record (please not however that the record page will open in a new tab).
I hope this might fit your needs, feel free to ask if the process is unclear.
