Airtable has just released my latest app: My One Record.
I wrote this app because I wanted a quick way to access linked records in a grid view without the distractions of other unrelated records. I have been personally using this app in my own bases ...
I’m testing out making a few of my scripts available on my Gumroad Store. These scripts currently have a “Pay What You Want” pricing model, so you can get them for free if you like.
Duplicate Record including Linked Records: Duplicate records, inclu...
My new app “Ready-Made Formulas” is now available on the Airtable marketplace.
This app includes over a dozen “ready-to-use” formulas for common tasks such as
formatting numbers and dates as text strings to include in reportsgenerating urls for prefi...
I have a new app on the Airtable Marketplace!
Have you ever wanted to prefill a form will data that already exists in your base, but found building the url to be difficult? My new marketplace app, Prefilled Forms, creates a formula that calculates a ...
It looks like free use of Scripting block has been extended another six months! (it was originally going to expire this month.)
Will there be a similar extension on free usage of Custom Blocks?
Thank you for looking up the thread on timezones. I played around a bit more. Note that I am in the USA in "Central" time. Your formula will be slightly different since you use a 24 hour clock instead of am/pm, and you are in a different timezone.
You can use an interface button that triggers an automation.In the automation, use a "Create Record" action that creates a new record with all the same field values as the original triggering record. You might find that you actually want to set some ...
Not sure what updates you are looking for.Here are some options:If the user needs only read-only access to a single table/view, you can use a shared view.If the user needs read-only access to multiple tables, you can sync those tables to a new base a...
It depends on your single select choices.One way is to use a SWITCH formula: SWITCH( {single select field name}, "choice A", 1, "choice B", 2, "choice C", 3)Another option works if the single select value looks like a number:VALUE({single select f...
No, this formula will not change with daylight savings time. It is a hardcoded timezone offset. Changing the formula at different times of the year also will not help. You would need to have something that can tell based on the date if it is daylight...