Multiple single dropdown showing same database in popup create and edit

[douzaines.polder-0v]

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?

I have a product table containing;

• image
• product name,
• description,
• price, etc.

I have an order/commande table that contains;

• order name,
• order number,
• due date,
• status,
• etc

Thank you!
Mel

[Zeroic]

Hi! Have an approach for this:

Product Selection in Popup:

• 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.

Let me know if this helps

[douzaines.polder-0v]

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

[douzaines.polder-0v]

Hello!!

Could you help me please…

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?

Thanks for your help

> This is what i need, so, how to do that?