Skip to main content

Creating an "add order" form that pre-lists all available products

  • January 22, 2024
  • 0 replies
  • 11 views

sgrass
Forum|alt.badge.img+6

Hi, is it possible to do the following in the Interface Designer or in Forms (old/new)?

I want to create an "add new order" page/form, which will show the user all possible products taken from the Products table, and next to each item the user would be able to enter the desired quantity.

Would look something like this:

ProductQt.
product1<user input>
product2<user input>
......

after submitted the form a new order needs to be created with each row in the above table becoming a new record in "Order Line Items" table. I'm ok using scripts if that will allow it.

Is this possible?

Thanks.