Hi! I am creating a database for my books and have included categories like genre, pace, mood, etc. In future, I would like to offer a subscription service for people to get a new book within their preferences. I know I can create a form in Airtable to get their information but is it possible to then have the form automatically generate a list of all the books that match their preferences? Or if not automatically, is there a way to do it quickly/easily without having to manually cross reference their preferences to the categories? I imagine an IF/THEN formula with IF referring to the users’ selection and THEN linking to the database column for that category. But I’m not sure if this will work or if there’s a better way or if I’ll have to hire someone to create something like this for me. Any info would be appreciated!
Hey New_Page, I’ve created something for you here that does what you’re looking for I believe. You can duplicate the base by clicking the title of the base at the top of the screen, then the three horizontal dots on the right, and then the “Duplicate Base” button. You’ll then be able to see all the formulas, how the fields are setup, etc
In the form, your users would select the categories via a linked record field
Each category record is linked to all the books that are categorized as such, and as a result we can just get a rollup of all the books of the user’s selected categories
It depends on how you want to share the list of books with them. An Automation could have a Find Records step that looks for up to 100 records in the Books table that match a user’s categories selections. From there you can email the Customer a list of those matching books.
Much like @Adam_TheTimeSavingCo ‘s set up, you would have a table of form submissions where users select one or more categories. Each category is linked to Books. And each Book would have a lookup field to find the Form Submissions that match it by referencing the Categories’ form submissions field:
The Automation trigger would be “when new form response”. The Find Records step would have these conditions:
The email from the Automation could look like:
Its not a perfect solution. If you need to only select books that match all categories selected, verses any category selected, then this solution won’t work for you. It also necessitates that the primary field for the Form Responses table have unique values (so an email address or perhaps a full name, not just a first name)