data normalization

[Jabar]

Hello community,

I have table for order record (called invoice). But for every item selected I made columns (Item ID, description, Qnty, price & amount). The issue now if I want to record more than 1 item for same record, I duplicated these columns 13 times so I can record 13 items at one invoice. the table is very big and making calculation cells is time consuming and repetitive work. is there a way to separate data or normalize them for easy app. 

thanks allthis is only part of page

[Aurelien]

Hi @Jabar 

Did you consider using parent/child tables ? 

Here is documentation, that will answer your question:

Data: The Essentials - AppSheet Help

[Swoopy]

At least you need 3 separated tables for data-normalization.

Item Catalogue(Item ID*, Description, Unit, ..other item details..)

Order(Order ID*, Ordered date, Requested by, ..other order details..)

Order Items(Order ID*, Item ID*, Qnty, Price)

The * indicates key columns of tables.

The Amount column should be virtual column created in AppSheet side (not on GSheet side). At first, you should avoid all calculations on GSheet, make it simple as possible (just for data storage).

Hope this give you an idea.