Structuring Line Item Detail

A common business use for Airtable is to track invoices or purchase orders. More often than not, that will also include some level of line item detail. The set-up of this is fairly straightforward, but getting the level of data that you need in each table can be somewhat tricky. Often, you’ll want to bring the line item detail into the parent table for the purpose of sending that data to a client or vendor. There are multiple ways to tackle this using Airtable and Zapier, but in this video I outline the easiest of these solutions using a Rollup Field with a couple of formulas to display the exact output that I want. Then, I can take that output and use it in some automated process - in this case I send an email with (easy to read) line item detail as soon as a new PO is created in the system. The big trick to this solution is using a Unique Array Rollup Field and then getting Airtable to treat that array as simple text. We accomplish this by using a CONCATENATE formula. From there, we take the text output and use a SUBSTITUTE formula with “\n” to tell Airtable that we want each line item detail on a new line of text. Once we have the output displaying as we want it, it’s an easy 2-step automation to send this line item detail out with the creation of a new PO or invoice. How does this help you streamline your business processes? _________________________________________ Learn more at these links: 🔗 👇 Join us for our next live training! https://www.garethpronovost.com/webin... Take our free Airtable Crash Course! https://garethpronovost.com/airtable-... Getting Stuck? See how we can help! https://garethpronovost.com Get our Airtable Field Type download! https://www.gapconsulting.io/airtable... _________________________________________ Table of Contents: 📖 👇 00:00 - What this video covers 01:04 - Framing the Example Database 04:23 - Getting the Detail we need for the Automation 05:56 - Building the Rollup Field 07:20 - Turning the Array into Text 07:37 - Getting our Output to include multiple lines 08:30 - Building the Automation _________________________________________ Software Resources (may contain affiliate links): 💻 👇 Airtable - https://airtable.com/invite/r/v0eI3ASY Zapier - https://zapier.com _________________________________________ #GAPConsulting #GarethPronovost #Airtable