I have what I have to assume is a silly problem but I’m still stuck. Here’s what I’m trying to do
I have a table with Users (Table: “Users_Table”) and various characteristics
One of the characteristics is “Favorite Foods” (A multiple select).
So Jane, a user, can have the entities “Pot Pie”, “Chocolate Cake” in her Favorite Foods column
Meanwhile, another table is “Table_of_Foods” with their ingredients (Food_Name is the Primary field on that table) and the Ingredients_List column is a multiple select
The Food_Name “Chocolate Cake” has these entities in the Ingredients_List: Chocolate, Butter, Sugar; and the item “Pot Pie” has: Chicken, Butter, Carrots
Now, what I’m trying to do here is have a column over in Users_Table that has Ingredients_Allowed where I am rolling up all the ingredients that I know my users can eat, since they are components of their favorite items: “Pot Pie”, “Chocolate Cake” in the “Favorite Foods” column.
I can rollup Ingredients_List as an ARRAYUNIQUES in my Users_Table, but this pulls in the Ingredients of “Chocolate Cake” + “Pot Pie” as a bunch of strings.
I would like to see entities in there!
What I am trying to do is really factorization … But I have no idea how to do this with Airtable.
Thank you so much!