Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 01, 2020 03:22 PM
Hello AT community!
I have a question regarding creating formulas.
In my base I have 2 tables: a recipe table with each ingredient in its own field, linked to my ingredient table. In the ingredients table I have several single select fields for each allergen that a particular ingredient contains.
So let’s say I want to summarize the allergens in my recipe for lemon meringue pie.
I’m using a frozen pie crust that contains dairy and wheat, allergens which are indicated as “yes” in their respective fields in my ingredient table, plus eggs (another allergen). Back in the recipe table, I would like to summarize all the allergens present in my recipe for lemon meringue pie, so I could easily look at the recipe and see that it contains eggs, dairy and wheat without having to go back to the ingredient table and look at each ingredient individually.
Is it possible to create a formula to summarize all the allergens present in my recipe, within the recipe table? I’m an AT newbie so not entirely sure how to go about doing this.
Thanks!
Solved! Go to Solution.
Jun 04, 2020 12:30 PM
Hi @Leslie_Engel, Yes, Integromat can have a steep learning curve because it is loaded with tons of functionality — I’m still learning new things about it every day! if you’d like to hire me to help you setup your Ingreomat automations, that’s what I do for businesses! I am a professional Airtable consultant! :slightly_smiling_face: Feel free to send me a private message to discuss more.
Jun 04, 2020 03:57 PM
Sounds good, thank you!