How to create an invoice from a order form

[Daniel_Boschung]

Hallo

I would like to generate a simple invoice or delivery note from an order form in airtable

I have a small plant shop. www.pflanzerei-zuerich.ch

Customers should be able to pic some plants from a database and send me a order. I would like to print this order and prepare the plants for pick-up.

I tryed already with some items but was not able to integrate the wished quantity of items, the price and the final calculaltion.

Is there a template for this problem. I think it is the basic need every little store has.

My goal would be, that the customer can click in the inventory gallery (form) on some items, add quantity and send me this order form with his name and adress…

Below you will see some screenhots and links.

Thanks
Daniel

Items in inventory you can choose:

Airtable

Pflanzerei-Zürich - Airtable

Explore the "Pflanzerei-Zürich" view on Airtable.

pflanzerei_order_form_01|690x317

The order form:

Airtable

Pic-Up Form Bestellung - Airtable

Fill out the "Pic-Up Form Bestellung" form quickly and securely on Airtable.

[Mohamed_Swella1]

Hi @Daniel_Boschung,

In the Page Designer Block, click on the Table you have created from the Items list, you will find on the left (Add Column), this will allow you to add the qty and price.

Check out this help article for more info.

BR,
Mo

[Daniel_Boschung]

Thanks Mo for this hint.
That works on the Page Designer Block :slightly_smiling_face:

But is there a possibility to integrate quantity in the form as well? Means the customer fills out a form and selects an item which is connected to a record in a table and can add an iteger number as quantity.

From the information in this form I would like to generate an delivery note.

Thanks
Daniel

[Mohamed_Swella1]

Hi Daniel,

The problem will be that they cannot enter several quantities for several items. Meaning, they can only choose one item and enter one qty.

[Moe]

Daniel_Boschung:

is there a possibility to integrate quantity in the form as well? Means the customer fills out a form and selects an item which is connected to a record in a table and can add an iteger number as quantity.

We built a form for Airtable that supports creating line items inside the form.

miniExtensions

Create Line Items in miniExtensions Form

Add new linked records -with all their details- without leaving the form page. Making one-to-many, parent/child, master/detail relationships. e.g. invoices.