Wondering if it’s possible to filter table from a field that acts as a sort of “quick find” field. I could swear I’d seen an example in some training video but I can’t find it.
I did find an example showing how to use a button. Useful, but not what I’m trying to do.
What I’d like is to have a field floating above a table (or table view). Let’s say that the table is a list of people. I’d like to put a field labeled something like “Filter by Name” above the table. If the field is blank, then all records are displayed. But if user clicks into the field and types “William”, they’d find me, and William Shakespeare, and William Henry Harrison, and Prince William. I can write the filter formula. I just can’t figure out how to put that field above the table and how to trigger it.
Use case for which I want this: If table is a list of people, users will 90% of the time want to filter on the person’s name or part of it. Asking them to click on the Coda filter widget, and configure the filter, is more trouble than they’ll want to go to over and over and over again.