On Monday I’m launching an Airtable newsletter called Base Notes, where I’ll be sharing Airtable tips, news, and other info every week! Subscribe here if you’re interested:
Airtable
✏️ Subscribe to Base Notes - Airtable
Fi...
Early this year I wrote a script1 to help a user organize some sequential events, where one event would start when the previous event ended. Rather than continue to post updates to that original thread, I felt it would be best to start a new one.
Th...
Every so often someone asks how to format numbers in a string the same way that they appear in a number or currency field. Various formulas have been created in the past (including some that I’ve posted in threads on this topic), but a recent thread ...
Is anyone experiencing odd problems with view controls (filters, sorting, etc.)? They’re suddenly not working correctly in my bases, and none of my records are appearing at all when any filter is applied. Only if a view is unfiltered can I see any re...
A question arose recently that’s come up a few times in the past: is it possible to give form users the ability to either pick an item from a predefined list or add their own “other” option, and have manually-added options actually appear in the list...
@TWarwick The problem that I see is that all of your logic is wrapped up in the OR() function. Here's why that's not doing what you want.OR() will output True or False if any of its expressions is equivalent to true; in this case, any of those two fi...
@TWarwick The LAST_MODIFIED_TIME() function can accept more than one field reference. Changes in any or all of the listed fields would cause it to output a new modification time.
Sorry for the delayed reply, @Dollie . I've been navigating a cross-country move for the past several weeks, and haven't been checking my notifications for a bit. That and I almost never visit this forum any more for various reasons.Anyway, the only ...
@Cody_Winchester The Autonumber field type is what you're looking for. When setting the field type for a field, it's toward the bottom of the list. Or just start typing "autonumber" and the options will filter down to make it easier to find.
