I am using airtable to manage information related to a landscape design and installation business. For most products, we purchase them as we need them and don't hold inventory. However, for plants, we sometimes order in bulk (lots of 32 or 50), ho...
When the lookup value is a field with multiple records, is there a way to filter the returned linked records and extract one field from it?For simplicity's sake, suppose that I have the following 4 tables1. Products - generic information about produc...
In a table called invoice categories, I have a field "project line items" that links to another table called "invoice line items".I have tried to create a template for invoice categories that creates several new invoice line items. Within the templa...
To clarify, the plants table is mainly general information about a plant...scientific name, common name, sun/shade, moisture, soil, cold hardiness, etc. This is information that doesn't change with the plant pot size. As currently configured, it h...
Thanks. I suspected that would be the case. The main reason I didn't do that is that some products have stable prices and availability from vendors and can be automatically pulled, others are bespoke and I'd like to manually choose the product, v...
