Creating a set of items

[Krismar]

Getting more comfortable with appsheet every day and learning more about how to move the data around a bit.

I have checked some sample apps to get the idea how to add/remove items from my inventory.
It gets a bit overwhelming if I would want to make "a set of items". 
A quick simple example: I have 5 different fruits in my inventory: Orange, apple, mango, banana, pineapple.
Now i want to create a "basket" that consists of 1 orange, 1 apple, 2 mango, 3 banana and 5 pineapple.

In my actual inventory i have products that consist of 20-50 different parts with different quantities.
Adding or removing them one by one would be very time consuming and even stupid to do.

[Marc_Dillon · Accepted solution]

You probably need to create a "recipe" table that holds a row for each ingredient per recipe, along with its quantity or other pertinent information. Reference this recipe table to auto-create instances of the records in another table when they need to be used for something.

[Marc_Dillon · Accepted solution]

You probably need to create a "recipe" table that holds a row for each ingredient per recipe, along with its quantity or other pertinent information. Reference this recipe table to auto-create instances of the records in another table when they need to be used for something.

[Swoopy · Accepted solution]

After read your post, I'd encourage you (and everyone) to spend time in learning relational database, telling how to construct tables which are related inside a database. Database is the foundation of every app (built on AppSheet). So, if you make the databases well, your apps will be going well too.

After finish the learning (not too hard), you'll also understand why @Marc_Dillon advised you to have the new table.

[Krismar]

It sounds a really good idea, i should take a step back and focus on basics. 

Thanks!