Is there any way to add the home page's search widget on a regular table's form?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
I like the search widget that we've added on the home page. Even though we have over 60 tables in our app, I find that everyone in our company searches for specific clients almost all of the time. We have a specific alpha code for each client, which is usually the way we search, but it's nice the way you can tie that home page search widget to a particular report and search across any of the fields in the report. I'd really like the same exact functionality while sitting on a client's form.

The typical scenario is that I've just reviewed a client's detailed information on the client form, and now I want to do the same thing for another client I just thought of. It would save several steps if I could just type in a keyword into a field at the top of Client A's form and have it immediately find and load/display Client B on the same screen/form, without having to force the user to click back to the home page and jump through multiple pages. What's the best way to approach this functionality?
Photo of Michael Barrow

Michael Barrow

  • 2,216 Points 2k badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,758 Points 20k badge 2x thumb
Are you looking for something beyond the built in search function at the top?

If you are on a table, it will automatically search that table, and you could easily search by the other clients name, and pull up any matches.

I would recommend reducing the number of searchable fields on your field list for the table before using this search method.
My suggestion would be to make a concatenated field of the fields that you typically want to search across. Then make a report with an question to search that concatenated field.

Then put a link to that report on your form.

The alternative is to make an report to search in some field contains, but. That will be a slower search and will give more false hits.
You could probably use the IOL technique to embed a javascript search on the form, and perhaps even the results within the form. Just an interesting thought I felt compelled to pass along. Check with Dan D. for his thoughts.