Now available: button field

An Airtable base allows you to store, visualize, and format the information that matters to you, but an Airtable base is also a custom software application. It uses your information to facilitate meaningful action, like planning an event or running a video production pipeline. In other words, Airtable enables you to do things.

With this in mind, we’re very excited to introduce the new button field type: a powerful new way for a user to trigger their own custom action for a record. Imagine, with just a click of a button, being able to:

send an email with a prefilled subject line, to address, and body textopen up a view, block, or dashboard from elsewhere in the same baseschedule a Google Calendar event with information prefilled from a recordgenerate a custom invoice and save it as a PDFrun a custom script that creates new records, validates data, or pulls in external information This button field brings up the page designer-created invoice for a client’s order with a single click.

There’s something viscerally satisfying about pushing a button—about being able to see, in the most direct way possible, how your action causes a particular outcome. Additionally, when taking action requires just one click of a bright, colorful button, it makes it that much easier for new collaborators to learn how to effectively use your base. Let’s take a closer look at some of the ways in which you can use the button field to turn your intent into action.

Click a button to open a URL

Join a Zoom meeting; post on Twitter; create a Google Calendar invite; open the Fedex tracking page for a package; create a Jira ticket: all these actions and more can be accomplished with the button field’s open URL action, which lets you create a button (with your own custom label and color) that, when clicked, takes you to a formulaic URL.

Send an email

As one example, suppose you have a table of people in your Airtable base—like an employee directory—that includes a list of those people’s emails, as well as other associated information. You can set up a button field that allows you to draft an email to any of these people with one click, including prefilling the subject line and body of the email using information from that person’s record.

All you have to do is configure your button field’s URL formula to something like:

“mailto:” & ENCODE_URL_COMPONENT({Email address}) & “?subject=” & ENCODE_URL_COMPONENT({Subject}) & “&body=” & ENCODE_URL_COMPONENT({Body})

Once this is set up, clicking the button for a record will open your default mail client, prefilled with all of the information from that record.

In this example, the URL formula incorporates information from other fields, including the employee’s first name and department, to make the drafted email more personal. Open Airtable links

While you can, of course, use the open URL action to go to external sites or use external services, it can also be handy to navigate within Airtable using the button field. If you find yourself constantly referencing a specific dashboard or view, a button field can make navigating to that dashboard or view a one-click process. You can also link to records, blocks, forms, share links, or other tables.

Links within the same base will open in the same window without a

Continue reading

This post was originally published on this site