We've used Airtable for replacing various parts of our internal backend dashboards for non-technical people. Syncing over the API + Zapier is doable, but I wish

We've used Airtable for replacing various parts of our internal backend dashboards for non-technical people. Syncing over the API + Zapier is doable, but I wish they made two-way sync easier. And the fact that they don't have cross-base lookups is a major pain point. For anything that requires quick fiddling and no API access, I still prefer traditional spreadsheets. Airtable's strict relational limitations means you cannot quickly enter some static data in an arbitrary field (e.g. a currency exchange rate). This makes quick back-of-the napkin calculations really awkward, even impossible.