This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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?
Yes this is possible. There are many possible ways. Here is one.IF(
{second zip code},
CONCATENATE(
{Address} & "\n",
IF({Second Address line}, {Second Address line} & "\n"),
{Zip Code} & " " & {City} & "\n",
{Country}
)
)
Because Airtable is a database and not a spreadsheet, the concept of a “next column” doesn’t really exist. Columns can have different orders in different views.You can hardcode your column order logic into your API call. Or you can have your API call...
If your field is an editable field, I do not recommend changing it to a date only field, as you will loose the time data when you make the change. You can create a formula field that converts the date/time field to just a date string. The easiest for...
The key here is identifying which record is the most recent submission.If your entries are created with a form, you could run an automation on form submission that sets a {Is Most Recent} checkbox for the new submission, and clears the checkbox for a...
Thank you for this wonderful new feature. I really like how it is introducing more formatting options to existing field types (versus adding field types). It is a beautiful implementation.I experimented with using negative values and numbers over 100...
