Skip to main content

New beta: button field


Forum|alt.badge.img+19

Update (June 25, 2020): The button field is now available for all users ā€” read more in our launch blog post: https://blog.airtable.com/now-available-button-field


:wave: Hey all ā€” Iā€™d like to announce the public beta of button field, a new field type that allows you to create buttons that trigger customizable actions. These actions include:

  • Opening a link based on a URL formula
  • Opening a specific record in page designer
  • Opening an embed in the URL preview block
  • Sending emails with SendGrid

Perhaps most relevant to this community ā€” you can use this new field type to run scripts directly from grid view, kanban view, gallery view, and expanded records. This will make scripts more readily accessible to end users and seamlessly integrated with their existing workflows. You can also customize your buttons with helpful labels that describe what your scripts do.

When a script is run from a button, the first input.recordAsync call in the script will use the record the button was clicked from. As an example:

// Change these to match your base.
let table = base.getTable('Table name');
let field = table.getField('Field name');

// When run from a button field, the script skips the prompt
// and automatically uses the button's record.
let record = await input.recordAsync('Choose a record', table);

let cellValue = record.getCellValue(field);
output.markdown(`# You have selected ${value}.`);

30 replies

ScottWorld
Forum|alt.badge.img+33
  • Brainy
  • 8774 replies
  • June 9, 2020

This is an awesome addition to Airtable! :slightly_smiling_face:


  • Participating Frequently
  • 5 replies
  • June 9, 2020

Wow I canā€™t wait to use this.


Forum|alt.badge.img+18
  • Inspiring
  • 251 replies
  • June 9, 2020

Wow ! Hereā€™s juneā€™s gift ?
Thatā€™s the way I like Airtable !
Thanks to @Kasra Dev Team, thanks to @Stephen_Suen !

oLĻ€


kuovonne
Forum|alt.badge.img+27
  • Brainy
  • 6001 replies
  • June 9, 2020

Thank you for this new ability to run a script for a specific record when looking at the record! This is awesome functionality and will make many workflows much easier.

The ability to open a specific record in Page Designer is quite nice as well.

Itā€™s great to see all the new things that a button can do. If you ever want to solicit ideas for other button actions, let us know. Iā€™m sure the community has lots of ideas.


Kamille_Parks11
Forum|alt.badge.img+25

@Stephen_Suen Iā€™m sure youā€™ve heard enough about my thoughts on Buttonsā€¦

But the last thing Iā€™ll suggest is zooming to a record in the Map Block.


Forum|alt.badge.img+19
  • Author
  • Inspiring
  • 79 replies
  • June 9, 2020
kuovonne wrote:

Thank you for this new ability to run a script for a specific record when looking at the record! This is awesome functionality and will make many workflows much easier.

The ability to open a specific record in Page Designer is quite nice as well.

Itā€™s great to see all the new things that a button can do. If you ever want to solicit ideas for other button actions, let us know. Iā€™m sure the community has lots of ideas.


Weā€™d love to hear your ideas! Please leave any feedback/suggestions via this form: https://airtable.com/shr78fy7G3400LC9D


  • Participating Frequently
  • 7 replies
  • June 10, 2020

Will it be possible to implement the button in forms in order to run the script in the background?


Forum|alt.badge.img+18
RoW wrote:

Will it be possible to implement the button in forms in order to run the script in the background?


Itā€™s not possible right now - Iā€™ve already tried it (not with a form, but with a public facing shared view). If the button is configured to launch a link, then it works - you can give people pretty buttons to click for links. But if the button is configured to trigger a script, they are disabled in public facing shares.

Itā€™s a bummer, but I get why they did it - if itā€™s being triggered from a public facing shared view, thereā€™s no guarantee that thereā€™s an instance of the parent base running to receive the script call and process it. Plus, scripts rely on a user session when they run, and people using a shared view or form donā€™t have a session with Airtable.


Forum|alt.badge.img+4
  • Inspiring
  • 192 replies
  • June 10, 2020
RoW wrote:

Will it be possible to implement the button in forms in order to run the script in the background?


As @Jeremy_Oglesby mentioned this isnā€™t possible right now, but Iā€™d love to hear what youā€™re hoping to do with buttons inside forms.


Kasra wrote:

As @Jeremy_Oglesby mentioned this isnā€™t possible right now, but Iā€™d love to hear what youā€™re hoping to do with buttons inside forms.


@Jeremy_Oglesby and @Kasra, I would also like to see scripts running in the background! Iā€™m trying to migrate scripts from a google sheet where clicking an icon on the sheet updates a cell value. We use this to create ā€œtalliesā€ for our team in how we are contacted for a request. The buttons are Emails, Phone, Ticket, etc, and they tally for that user into a spreadsheet. We support online Courses at a private university and the data from this simple script has been very valuable. We would love to implement it into AirTable using these buttons, but so far Iā€™m not sure it will work unless the script runs in the background.


Forum|alt.badge.img+18
Kasra wrote:

As @Jeremy_Oglesby mentioned this isnā€™t possible right now, but Iā€™d love to hear what youā€™re hoping to do with buttons inside forms.


@Kasra - One very specific example I have for you:

My wife and I homeschool our children, and we use Airtable to organize our work and put together task lists for our children of the work that needs to be completed (their self-work).

Currently, we just log in to Airtable with our own accounts and have our children work with a filtered view to access links weā€™ve provided, download PDFā€™s, and check off the work they complete with a checkbox field. We donā€™t really want to pay for them as ā€œProā€ collaborators, because this is the only thing we have them using Airtable for right now.

It would be great if I could just provide a shared view for them to work off of - they could still access links and download PDFā€™s they need, and then it would be nice if I could provide a button they could click that would trigger a script to 1) check the checkbox field to mark the assignment as done, and 2) depending on if the assignment is marked as needing to be uploaded to our schooling system, create a task for me in a different table to upload the assignment.

This would allow us to give our children the ability to interact with our base in only the very specific way we want them to, without risking our data or the structure of our base by opening it up to them.

In other words, I want to use the button field to circumvent your subscription structure :laughing: (this is only partially trueā€¦ there is a very real weakness in Airtableā€™s structure when it comes to user permissions and allowing only very restricted interaction - a weakness that is being capitalized on by services such as Stacker)


  • Participating Frequently
  • 7 replies
  • June 10, 2020
Kasra wrote:

As @Jeremy_Oglesby mentioned this isnā€™t possible right now, but Iā€™d love to hear what youā€™re hoping to do with buttons inside forms.


I would like to be able to fill blank fields of one or a group of fields of a form instead of writing again and again the default value


  • Participating Frequently
  • 9 replies
  • June 10, 2020

Great addition! Canā€™t wait to use it to run scripts from grid view!


  • Inspiring
  • 10 replies
  • June 13, 2020

This is going to make my life much easier. This is very intuitive for my end users!


Thanks for this.
I used this and it is very convenient.
Please see helpgap.com.
It is a simple implementation .
With the Button field it was tough to get these things done easily.
Thanks.


Jeremy_Oglesby wrote:

@Kasra - One very specific example I have for you:

My wife and I homeschool our children, and we use Airtable to organize our work and put together task lists for our children of the work that needs to be completed (their self-work).

Currently, we just log in to Airtable with our own accounts and have our children work with a filtered view to access links weā€™ve provided, download PDFā€™s, and check off the work they complete with a checkbox field. We donā€™t really want to pay for them as ā€œProā€ collaborators, because this is the only thing we have them using Airtable for right now.

It would be great if I could just provide a shared view for them to work off of - they could still access links and download PDFā€™s they need, and then it would be nice if I could provide a button they could click that would trigger a script to 1) check the checkbox field to mark the assignment as done, and 2) depending on if the assignment is marked as needing to be uploaded to our schooling system, create a task for me in a different table to upload the assignment.

This would allow us to give our children the ability to interact with our base in only the very specific way we want them to, without risking our data or the structure of our base by opening it up to them.

In other words, I want to use the button field to circumvent your subscription structure :laughing: (this is only partially trueā€¦ there is a very real weakness in Airtableā€™s structure when it comes to user permissions and allowing only very restricted interaction - a weakness that is being capitalized on by services such as Stacker)


Hey Jeremy,

Did you find a workaround for this checkbox issue? Iā€™m trying to find a way for non-users to interact with my database which would then trigger a script in the background.


Forum|alt.badge.img+18
Morgan_Molidor wrote:

Hey Jeremy,

Did you find a workaround for this checkbox issue? Iā€™m trying to find a way for non-users to interact with my database which would then trigger a script in the background.


Hi @Morgan_Molidor ā€“ welcome to the community.

No, thereā€™s no workaround that allows a non-collaborator to trigger a Scripting block. They can only be manually triggered by a collaborator in the base.

Based on the trajectory of Airtableā€™s recent features, Iā€™m feeling hopeful that they are moving in the direction of deeper integrated automation, but for now Forms are still the only means for a non-collaborator to interact with your base (outside of third-party tools).


Jeremy_Oglesby wrote:

Hi @Morgan_Molidor ā€“ welcome to the community.

No, thereā€™s no workaround that allows a non-collaborator to trigger a Scripting block. They can only be manually triggered by a collaborator in the base.

Based on the trajectory of Airtableā€™s recent features, Iā€™m feeling hopeful that they are moving in the direction of deeper integrated automation, but for now Forms are still the only means for a non-collaborator to interact with your base (outside of third-party tools).


@Jeremy_Oglesby thanks! I am hopeful too.


Hi, how can a button field be edited after the initial setup? Canā€™t find the way:


Justin_Barrett
Forum|alt.badge.img+20
Balint_Drahota wrote:

Hi, how can a button field be edited after the initial setup? Canā€™t find the way:


Welcome to the community, @Balint_Drahota! :grinning_face_with_big_eyes: Check your Airtable login. The only reason I can think of that would give you such a short list of options is if youā€™re not logged in as an editor.


Justin_Barrett wrote:

Welcome to the community, @Balint_Drahota! :grinning_face_with_big_eyes: Check your Airtable login. The only reason I can think of that would give you such a short list of options is if youā€™re not logged in as an editor.


OMG yeah, that was the case :grinning_face_with_big_eyes:


Hi! This is a great feature!

ĀæWhy is the button disabled when the view is shared, either by link or embeded?


Kasra wrote:

As @Jeremy_Oglesby mentioned this isnā€™t possible right now, but Iā€™d love to hear what youā€™re hoping to do with buttons inside forms.


Hi Kasra, Iā€™d hope the button could be enabled in shared view. Any workaround?


Hari_Balasubram wrote:

Thanks for this.
I used this and it is very convenient.
Please see helpgap.com.
It is a simple implementation .
With the Button field it was tough to get these things done easily.
Thanks.


Hey @Hari_Balasubramanian! How did you enabled the button in the shared view?


Raimundo_ladron wrote:

Hey @Hari_Balasubramanian! How did you enabled the button in the shared view?


Buttons are another field type now like Long Text , Date , Number etc . I think it has come out of Beta and you must be able to see it in the field types.