

- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
As weโve been testing AirTable for our businessโs project management needs, one thing weโve had trouble setting up is something like an expense report, purchase order, or mileage report.
Our typical reports would be a single printable document with several standard pieces of data (job name/number, purchase date, vendor info, billing method, etc), and a table containing purchase info (item, qty, price) with totals at the bottom.
In Airtable, you can currently accomplish something like this with two tables (letโs call them โExpense Reportsโ and โExpense Itemsโ) with the latter connected to the former with a โLinkโ field. But itโs a bit clumsy, because youโd have one table with each โreportโ and another table that contains lots and lots and lots of expense items that likely have nothing to do with each other. More importantly, itโs not really possible to export the data from each Report while including the Expense Item data.
A more elegant solution would be a field type called โNested Table.โ This would create (within a record) a small table/spreadsheet with customizable columns, simple math functions, and the ability to add rows on-the-fly.
Thoughts?