Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Add product to a new or existing order using gallery interface of my products

Topic Labels: Interface Designer
270 1
cancel
Showing results for 
Search instead for 
Did you mean: 
FPX
7 - App Architect
7 - App Architect

Hi all

I have an orders table, an order line items table and a products table.

In interface, i want my staff to make orders using the products table where they 'add product to new or existing order'.

So when they click on the product this should bring up order line items form to add quantity, sell price etc of selected product and then either create new order (parent table of order line items) or link to existing order (order ID, vendor, consignee etc)

Any ideas? 

Thank you!

1 Reply 1

Are they paid seat members?  If so, I'd suggest creating a Record Review layout where they can add/edit Orders, and add Order Line Items that are linked directly to said Order

If not, I reckon your best bet's using Fillout instead as that'll let you create new linked records on the fly via a form, something that the Airtable forms doesn't let you do at this point