I wrote a blog post about the idea of iterating on apps with Airtable. Airtable is, to me, a way to allow anyone to create apps—not just programmers. But even for programmers, it’s a gem to iterate and prototype faster, and to build the apps that don...
Hi! For some Uncide codepoints that are encoded as 4-byte UTF-8, such as , and ā, Airtable’s LEN formula function appears to return 2 instead of the expected 1. This is not the case for 2-byte or 3-byte UTF-8 encoded characters as far as I can tel...
When sending PUTs to the API with a complete record you’ll get an error if you include computed fields. Since you get computed fields back like any other, the only way to find out which fields are computed is by either a) from the error messages when...
I love the jump to base prompt for jumping around. Allowing it to jump to an arbitrary table would be a great way to make it more powerful to make me able to work faster in Airtable :ok_hand:t3:
Is there any plan for an API to pull metadata? It’s currently very difficult to infer the schema, you have to resort to hacks like reading all records and then trying to infer types and column names from that. It’d be great if you could pull the sche...
That’s awesome to hear Maureen! Over time it’s given me a lot of insights… for example, some of the stores my friends say are expensive, I’ve found are only expensive on few (although common) things, and cheap on others.
Should be possible with this formula:
IF(MONTH(Date) < 9, IF(MONTH(NOW()) < 9, (YEAR(NOW()) - YEAR(Date)) - 6,(YEAR(NOW()) - YEAR(Date)) - 5),IF(MONTH(NOW()) < 9, (YEAR(NOW()) - YEAR(Date)) - 7,(YEAR(NOW()) - YEAR(Date)) - 6))
See example Airtable.
I think a single select and formulas are adequate to get everything you’d want out of this. I use this system in many of my bases! Supporting this as a field type raises questions such as: How many point scale? How should they be represented (some pe...
