Hello,
I have a popup that allows me to create and edit my data. In this “order” popup, I’d like the user to be able to order 1 or more products and to be able to select a product (dropdown) and enter the quantity linked (input) to its respective product → see example
→ see example bellow
product#1 → 2 units
product#2 → 1 unit
etc
I’d also like my products and quantities to be displayed in my order data table (App data). How do I do this? data source on the dropdown input? workflow, create things + make change?
Dropdown: Source from Product table, displaying product_name.
Quantity Input: Add an input field for the user to enter the quantity.
RepeatingGroup Display selected products and quantities in a RepeatingGroup.
Workflow to Save Order:
Create Order: On form submission, create a new entry in the Order table.
Order Line Items: For each selected product, create an Order_Line_Item entry linking to the Order, Product, and quantity.
Display in Order Data Table:
Use a repeating group to display orders and associated products/quantities by sourcing from the Order_Line_Item table.
Hello,
Thank you for your help.
The maximum choice was 5 products., so I created in my order table (product 1, product2, product3, product4, product5) to my product database and it works.
I will also test your recommendations on another project.
Many thanks and have a nice day.
Namaste
Now that I have created my order/commande table with each order and its own product quantity. How can I synchronize my order/commande table with my product table?
I’m assuming that I need to create different “list” data types List_Qty1, List_Qty2, List_Qty3, List_Qty4 in the “Product” database, linked to my order/commande database?
And then in my workflow “Product” → popup create edit; do I need to make a make change; List_Qty1? if so, how do I make this make change and what do I indicate? Or do i need to make this make change in de order/commande workflow popup create?
