invioce with multiple items

[Sakhy]

Greetings, i have been struggling with this for months. i need the app to add items that add up. 

the template above show how the app shoul operate. 

PLease asssit. 

Reagrds 

[jyothis_m]

I think the structure of your table is not suitable for appsheet. The structure of the table should be simple, like all column with column names. Then each item for the table should be entered in each row. All headings should be column names. 

[Aurelien]

Hi @Sakhy 

what you are wiling to achieve is a simple invoicing app, I presume.

You will need two tables: 

 - Invoice, with columns such as Date, ClientName, and so on

- Invoice_LINEITEM, with columns such as Products, Quantity, and so on.

The mechanism is pretty similar to this one:

Quote Generator

The output will be a Docs-based document, not Excel/Sheets.

For reference, in addition to @jyothis_m 's remark:

Data: The Essentials - AppSheet Help

[Sakhy]

@Aurelien thanks you right Quote Generator is the exact, i have worked on it but the only problem is adding multiple items and products to give the totals, and display it has invioce template. 

[Aurelien · Accepted solution]

Hi @Sakhy 

" adding multiple items and products to give the totals"

In the child table, tick the "is a part of" option on the Ref column that refers to the parent table.

"display it has invoice template"

If you mean producing an invoice document, I suggest reading this documentation:

Use Google Docs templates - AppSheet Help

Use templates in an automation - AppSheet Help

Topics with Label: Templates - Google Cloud Community