Скачать или смотреть June 2020 Updates | Created by, Last Modified by, and Button Fields!

Another month in the books, and some fantastic new features from Airtable! In this post, I'll be detailing my three favorite new Airtable features with the June 2020 update. Specifically, I'll be detailing three new fields:

Created by
Last Modified by
Button

It's uncommon that we see one new field type released, but to have three new fields all drop at once is really exciting! These fields are dependent field types. That is, they derive their values from other fields and can't be directly edited. The Button Field, most excitingly, has a slew of functions that it can perform. Essentially, this field allows you to establish rules so that when you "push the button" specific things happen!

In this video I outline an imagined use-case for these three fields. I create new Contacts in my database (instantly seeing who is responsible for each new contact using the "Created by" field).

Then, I use a button to attach an image to each contact. To do this, I built a button that opens the Pexels Block, allowing me to quickly search for a royalty free image. Once I select one, it updates my record and also shows me the user who made the last update, utilizing the "Last Modified by" field.

Lastly, I wrap things up with a more advanced button that sends an email to the contact in question and even attaches the corresponding image to the email. To get this over the line, I used some pretty gnarly formulas, so I'll be sure to include the nastiest of those (a formula that 'scrapes' the URL of an image) here below:

MID({Photo Text},FIND(" (",{Photo Text})+2,FIND(")",{Photo Text})-FIND(" (",{Photo Text})-2)

That's it for this post - let me know what new use-cases you start implementing for your buttons... I can't wait to further explore the new features!

_________________________________________


Learn more at these links: 🔗 👇

Join us for our next live training!
https://www.garethpronovost.com/webin...

Take our free Airtable Crash Course!
https://garethpronovost.com/airtable-...

Getting Stuck? See how we can help!
https://garethpronovost.com

Get our Airtable Field Type download!
https://www.gapconsulting.io/airtable...

_________________________________________


Table of Contents: 📖 👇

00:00 - Intro
00:50 - New Updates
01:52 - Outline the Database
02:51 - Created by Field
04:58 - Last Modified by Field
06:08 - Button Field (Using a Block)
08:05 - Button Field (Open a URL)
08:53 - Formula Magic (Scrape the Image URL)
10:27 - Building the Email Automation
12:48 - Disabling the Button with Conditions
14:31 - Get More Help!

_________________________________________


Software Resources (may contain affiliate links): 💻 👇

Airtable - https://airtable.com/invite/r/v0eI3ASY

_________________________________________


#GAPConsulting #GarethPronovost #Airtable