Hello! I am building an inventory app for a restaurant, it has a โGroceries listโ table, and an โinventoryโ table. When someone is buying an item from the โGroceries listโ, I would want to make a button to directly add this new item to the โinventoryโ table. When the user would press it, a box should appear, and the user would input the โQuantityโ and โEat-by dateโ.
I have seen that it is possible with multiple actions, and creating a slice for each input but I donโt see how it can be setup for my problem. Can you guys help me with that?
Hello, welcome to AppSheet!
I hope I understand your question correctly. I think you want someone to be able to go to an item in the groceries table, and add it to the inventory table, along with a quantity and eat-by date?
Thatโs something you can achieve by creating references between the two tables. You can check out the guide here: References Between Tables
Hereโs an example. First, Iโll click the edit button on my โitemโ column in the inventory table:
Next, set that column to be a Ref to the groceries table:
And now the app looks like this:
Hi Madeline! And thank you for your help!
I donโt think a ref column is the best for my โinventoryโ table (named Feuille 1 here):
I would like to create an action in the โGroceriesโ view that would add an item to the โInventoryโ table, keeping the same Name, and Category columnโs value of the โGroceriesโ table, but asking the user to input the โQuantityโ and โDLCโ values.
I have seen that this is possible with grouped action type, just like on this thread:
But I have some troubles understanding how it would fit my tablesโฆ And if it is the best solution
User | Count |
---|---|
35 | |
35 | |
27 | |
23 | |
18 |