Justin_Barrett - profile

Justin_Barrett · Jan 01, 2022

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...

Justin_Barrett · Oct 15, 2021

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...

Justin_Barrett · Sep 06, 2021

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 ...

Justin_Barrett · May 05, 2021

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...

Justin_Barrett · Mar 20, 2021

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...

Justin_Barrett · Dec 28, 2024

Definitely a superior solution. At this stage there's no reason to use that old hack that I came up with. It was an interesting experiment at the time and helped folks to get things done, but I definitely don't recommend it any more.

Justin_Barrett · Sep 09, 2024

@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...

Justin_Barrett · Sep 07, 2024

@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.

Justin_Barrett · Aug 07, 2024

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 ...

Justin_Barrett · Jun 27, 2024

Sorry, but I'm not currently taking on contract projects.

User Statistics

User Activity

New Airtable newsletter: Base Notes

Set Sequential Event Times

Formatting numbers using regular expressions

View controls not working

Automation: Allow users to add new options to a predefined list via a form

Re: Automatic Sequential Numbering of Non-Sequential Items (READ JUN 9 2021 FOLLOW-UP)

Re: Delay email automation

Re: Delay email automation

Re: Automatic Sequential Numbering of Non-Sequential Items (READ JUN 9 2021 FOLLOW-UP)

Re: Autofill drag with alphanumeric?