I’m not used subtables much yet although I get tables and linked references. And I’ve run into @References before but I’m not as familiar enough with them to know if they’re a solution for me.
I want to
- Search for ingredients and display all matching recipes using that ingredient.
- Easily add ingredients to a shopping list when looking at the recipe (That’s flipping a toggle on the ingredient table.)
I know how to do both of these but not with the same solution. And when something is in a canvas the regular table search doesn’t seem to search within it…
If i use subtables on in my recipe card - I can easily use a button to modify the ingredient table to mark it needed. (yay) - but then I haven’t found a way to search for an ingredient and get back a recipe.
When I used a direct Recipe to Ingredient reference then I need to duplicate the ingredient list to show the amounts needed for THIS recipe - and I’m not sure how to modify the row to get it to add to the list. But the searching works perfectly.
I thought maybe this would do both, but actually it means I don’t know how to search OR add buttons to add to my list. But I feel this is a powerful tool I don’t yet get.
Apologies not sure how to embed Coda docs yet. But here’s the bare minimum I’ve architected
- Table 1 Recipes - RecipeName, Amount, IngredientsName, Button: Toggles “Needed?” to true
- Table 2 Ingredients - IngredientName, Needed?, Location, Last Purchased
My shopping list is just a view of the ingredients table that only shows items where “Needed?” is True.
I’ll admit i have many many more plans for this for meal planning and all kinds of things, but I figured I should start with the basics.