When I 'get' look-up or select fields using Pyairtable, they're now coming in as list type objects: 'red' is now ['red']'5/11/24' is now ['5/11/24']The previous behavior was WYSIWYG. This is unexpected and strange and breaks years worth of ETL scri...
This is a basic hack to sort a simple list of pre-determined roll-up values (e.g. 12 months) without a script or 3rd party automation.In the example below, month values from the Sub-items table are rolled up in Items table / Unsorted column. Columns...
I built some scripts a while back using the airtable python API wrapper. I was able to create new records in a table with linked fields using only the string value of the linked record. This was very helpful since I could upload records to 'Orders,'...
I signed up for beta a long time ago, but seems I'm still on the waitlist. Has anybody one else been let in to beta?Notion's AI tools are cool and I'm using them already. Wondering if I should be shifting my workflows over, or keep waiting. It's al...
I'm having a hard time cleaning a long text value so that it can be passed to an API as a JSON value via a Post Request. After running lots of different cleaning formulas, which all yield 'bad character' errors, I think I've narrowed the problem dow...
This hack won't work for complex values (like full dates), but works without scripts and could be used for simple roll-up sorting, and possibly be adapted.
