Do you have idea on how to make this column editable in terms of number of quantity. Please let me know if you have kitchen app template through appsheet. Thanks

[Audit_CKGoC]

[Darmund]

The data structure behind meals, recipes, and ingredients can get pretty complicated.

You’ll want to figure out which data entities should have a one to many or many to many relationship.

I would recommend having a one to many relationship between ingredients and meals, so that one ingredient can be used for many meals. This would mean you would have a meal_id column in your ingredient table that is a ref data type to the meal table. You can also use AppSheet’s “Is a part of” feature to add multiple ingredients at once when you’re adding a new meal record:

One drawback with my suggestion is that an ingredient wouldn’t be able to change other attributes like amount or quantity between different meals. Instead, you would have to create multiple ingredients with the same name but different attributes.