• 🌎 Overview
• 🛠 The Build - 4 Steps
• Core Functionality
• 1. Create an Airtable Base
• 2. Create a Form
• 3. Add Fields to Calculate Totals
• 4. Create a Zap
• 💪 Additional Functionality
• 📚 More Resources

🌎 Overview

🛠 The Build - 4 Steps

Core Functionality

• Allows you to quickly design a form to issue invoices
• Generates an invoice in your accounting system
• Sends the invoice to the customer within a few minutes

1. Create an Airtable Base

In Airtable, create a new base from scratch with the following fields:

• Customer Name
• Customer Email
• A field for each purchase option

2. Create a Form

• Customize the look of your form
• Add helpful narratives
• Mark fields as required

3. Add Fields to Calculate Totals

• Add three formula fields to calculate the total price of each item, based on the quantity provided by the customer
• The third field uses a SWITCH formula. This is an alternative to an IF statement, when there are several different options. The SWITCH formula used here is as follows:
Copy

SWITCH(
	{Package},
		'Basic', 10,
		'Medium', 100,
		'Advanced', 10000,
		'Legendary', 1000000,
			'Error'
)

4. Create a Zap

In Zapier, create a Zap with the following steps:

• Trigger when there's a new record in Airtable:

• Add a "Find or Create Customer" action - If it's not found, a new customer is created:

• Add a "Create Invoice" action with the first invoice line item
• Use the customer from the previous step, and be sure to set "Send Later?" to True

• Add the details of the first line item. Note: QuickBooks requires a total "Amount" for line, so it will disregard the item price in the QBO file. If you are following this same process with Xero, you can simply provide the item and the quantity.

• Add subsequent line items using the "Update Invoice" action

• Add a "Send Invoice" action to send the final invoice

💪 Additional Functionality

📚 More Resources

• A 12 minute video walkthrough of this build is available in the rlz.io community
• If you haven't used Airtable before, signing up via this link gets me a $10 Airtable credit 🙏