How to enter data in the parent-child table at once

[K5]

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]

I hope to enter it like this

[TeeSee1]

Why do you even have four tables where two tables - order and orderproducts - are usually sufficient.

You can capture product, color, size and quantity in orderproducts table.

This is a typical parent - child structure.

https://support.google.com/appsheet/answer/10106510?hl=en&sjid=18308640123428671120-AP

[K5]

(Corrected)

Thanks for the advice!

The reason the table is split is because I thought it would reduce the number of entries.

For example, if you have two PRODUCTs, each with two COLORs and eight SIZEs, the total number of SKU is 32.
If the tables are grouped, the number of input items required will be 96 (= 32*3) because PRODUCT, COLOR and SIZE are input for each SKU, but if a branching loop is used for COLOR and SIZE, only 22 are required (2 + (2*2) + (4*4)).

I thought this would be less of a burden on the user, but it is still difficult to use, so I would like to create an interface that allows each item to be entered repeatedly all together.

Is this possible?

[TeeSee1]

How do you enter different quantities for different SKUs if the number of entries are reduced? You would need full 96 entries if you want to set different quantities for each of the combinations.

Unfortunately you cannot create a table like UX for data entry within AppSheet (correct me if I am wrong, anyone please!).

[TeeSee1 · 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.

[K5]

I see! Then I can enter the same quantity of SKUs in one action! I hadn't thought of it that way.

The method of creating a reference table, filtering and then posting in an action seems to have other applications.

I would like to thank you from the bottom of my heart for your kind instructions.