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 · Jan 31, 2023

As long as your heading is always on a single line (not spanning multiple lines using line breaks), then this will do the trick.First formula field: "Heading" IF(Recipe, REGEX_EXTRACT(Recipe, "[^\n]*")) Second formula field: "Recipe Body" IF(Recipe, ...

Justin_Barrett · Jan 31, 2023

@matt_stewart1 Please share the code that you've created so far, and we can help you refine it.

Justin_Barrett · Jan 26, 2023

Unfortunately I don't have time to dig into this very deeply and run any specific tests. The problem might stem from the fact that the filename that you're trying to use contains spaces. Then again, the example from @matt-pwi doesn't contain spaces a...

Justin_Barrett · Jan 13, 2023

Re: the "deprecated" warning, that's not about the command in its entirety, but the specific way that my original script is using it. Long story short, using that method without passing anything to it--meaning nothing inside the parentheses--used to ...

Justin_Barrett · Jan 03, 2023

@plyske wrote:Right now I have an email automation that fires too quick, so the emails that are being sent, are w/o information. How would I do the above mentioned? Do I need to make a new Field in the table? How does the automation look like? You di...

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: splitting content in long form text in a formula

Re: Use automation to count up by one whenever field is edited

Re: Automate changing the file name of an attachment

Re: Automate changing the file name of an attachment

Re: Delay email automation