First make sure your entry components are writing to user specific columns in your products table. Then set up your button with a custom action that will first ‘Add Row’ to whichever other table you want by taking those user specific columns and passing them through to the other table. Then follow it with a ‘Set Column’ action that will clear the entry component columns so they are empty for next time.
Thank you for the reply,
The problem with your solution is that my “user specific column” data is saved on a different sheet than the one that i have the items saved on.
Sheet-1 and Sheet-2
Sheet-1 contains the cakes and their specs
Sheet-2 contains user specific columns.
How do i add Input Entry’s that will allow me to select columns from a different sheet?
Hopefully this makes sense.
After further inspection,
Are you telling me that I need to have the same columns from Sheet-2 on Sheet-1 to just fill information but when the user presses the button, it will transfer all the data from the Sheet-1 columns to Sheet-2 and then it will reset the columns. Am i correct?
Yes, you are correct. The user specific columns would be placed on your first cakes sheet. Then the button takes those user specific values and writes them to permanent basic columns in your second sheet.
I think what you can do here is add a relation from your current Cakes sheet to the Sizes sheet. The Sizes sheet should look like this:
ItemID | Size | Price
Cake001 | Small | $1.00
Cake001 | Medium | $2.00
Cake001 | Large | $3.00
Then you can let users write to a user-specific column the size they want to choose. This choice will be populated by the relation I mentioned above.
Then, you create a template joining the chosen item’s ID and the chosen size. In the Sizes sheet, you create the same template column with ItemID and Size.
Let’s say “Cake001 - Small”.
Then create a relation between those two templates and return the price for each cake. I assume you already write the quantity to a user-specific column, so you can have a math column to get the price and display it to the user.