LinkedIn
Twitter
Hello, There are four tables with four layers.
[ORDER]
[ORDER PRODUCTS]
[ORDER PRODUCTS COLOUR].
[ORDER PRODUCTS SIZE].
When a user fills in a form,
1) ORDER DATE
2) PRODUCT
3) COLOUR
4) SIZE
and the user has to SAVE at least 4 times, which is inconvenient.
Is there a way to enter them all at once, side by side like this?
[Product][Colour][Size][Quantity]
Solved
1 ACCEPTED SOLUTION
Just FYI. You could do something like this..
Products table
SKU table that lists possible Base Product, Color, Size combinations
Here is ORDERS table, initially no records.
Create an order with basic info such as date, customer, etc..
Then move to add details view. Here you can fill out, order quantity and filtering conditions for products, colors, sizes which select matching SKUs.
Just another set of filtering conditions.
After you have set filtering conditions, you invoke an action that triggers a bot that creates, via AppSheet API, order detail records that contain the selected SKUs with the specified quantity. You can repeat the same for a different set of quantity and filtering conditions.
I am sure people have created different UIs for entering orders and this is just one example, by no means the best one, that you could create as you learn more about the platform.
