Multiple single dropdown showing same database in popup create and edit

douzaines.polder-0v · 2024-08-21T09:36:02.064Z

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 · 2024-08-22T19:59:13.519Z

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 · 2024-08-23T12:02:09.550Z

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 · 2024-08-27T14:57:34.010Z

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

SCR-20240827-obgg2326×2132 283 KB

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

SCR-20240827-nzyf2664×1586 279 KB

system · 2024-10-30T09:36:06.848Z

This topic was automatically closed after 70 days. New replies are no longer allowed.