I am creating a catalog of sheet music for some musical groups I play in. It has a main table with all the usual information to be expected (title, composer, arranger, etc.) plus some additional info, such as alias names and associated works or titles. All the information is either directly stored in the table, or is in a linked table (composers and arrangers, for example).
The alias and associated works are useful. Some examples of these associations are:
- The title, “It’s the Hard Knock Life”, also has an entry in the associated works field indicating that it is associated with “Annie”.
- The title “Ukrainian Bell Carol” has an alias entry as “Carol of the Bells”.
- The “Hallelujah Chorus” has an associated entry indicating it is part of the oratorio “Messiah”.
The point of all that is to indicate how useful this information could be in searching. For example, when searching for a specific title, I would also like the associated/alias fields to be searched for the same title.
Now, I can easily do this by clicking the filter button, and manually entering the filter criteria, and then adding an “OR” with the same criteria on the associated/alias column.
But, it would be easier, especially for other members of the musical groups to be able to simply enter the search criteria into a form, and (somehow) be able to specify the form text boxes as parameters for the filter. That is, a user simply types in the search criteria and, presto, those entered parameters are used to filter the table.
In other words, I’d like to be able to have a query created on the fly, according to search criteria supplied in a form. (That is, essentially, build a WHERE clause dynamically.)
Is there a way to do this with Airtable?