Nov 01, 2020 05:07 PM
Is there any way to create an automation or something that would allow me to push a button in AirTable and it would change the content /value of another field?
Field 1 - Record title.
Field 2 - Button called. e.g. “Reset Date” (button field) - this button would initiate change in Field 3
Field 3 - Date field (with a manually selected date) - This field date will be changed to “Now()”
I want to refresh the date in Field 3 to “now”.
But I want the Field 3 to remain a static field with manually selected date. I want to update the date manually (without having to use the calendar widget in the date field)
Is there a way t create a button to trigger that? I looked at Batch Update app and Automations, none of which seem to be able to be triggered with a Button.
I see scripts as an option for Buttons. Is script the only way to get what I am looking for?
Last option is Integromat or course and they have the mobile app which can trigger flows by pushing button there.
Nov 01, 2020 09:21 PM
Strangely, the Airtable team has decided that buttons can not trigger automations, which is extremely odd & frustrating, since the most obvious use case for an automation is to be able to trigger it via a button. :man_shrugging:t2:
The best you can do for now is to simply use a checkbox field instead of a button field, and then when you check the checkbox, your automation can run.
However, if you want to stick with buttons instead of checkboxes, your options are very limited.
I am a professional Airtable consultant and a Registered Integromat Partner, and the Integromat link contains my personal referral code.
Please submit this “button triggering automations” idea as a feature request to email@example.com, and maybe they will address this issue for us.
Nov 03, 2020 08:37 PM
Well that it is strange decision. Buttons would be of great use or automations. Is a nice worded email better than submitting here? … to Product Suggestions - Airtable Community Forum
Great suggestion with the checkbox, it’s a decent work-around. Gimmicky but at least workable.
Jul 29, 2021 10:29 AM
Buttons that can’t run automations or update other fields eliminate my use for AirTable. The only interactive item in a shared view without logging in are the buttons. I’m using this as shipping / order manifest that syncs with QuickBooks via Zapier. Everything works great but my warehouse can’t mark the order as shipped. I don’t want them using the full / restricted view via login. A simple go to the link see whats open and needs to go out and mark as done once it has.
Jul 29, 2021 07:26 PM
Airtable now supports webhooks, so you can now trigger an automation with a button by triggering an Airtable webhook.
Jul 29, 2021 07:51 PM
Not quite yet. Airtable webhook automations require the payload to be in “post” format, but a button field can only submit data in “get” format. Thus, you cannot pass the webhook any identifying data from a button field.
Jul 29, 2021 07:57 PM
When I want a button field in a shared view to make changes to an Airtable base, I use a prefilled form url. The button field calculates the prefill for the form. (You can use the prefilled forms or ready-made-formulas apps to calculate the formula.) The user clicks the button, which opens a form. The user submits the form. (Depending on the use case, sometimes the user enters other data in the form, but not always.) Then, an automation takes over using the data submitted in the form.
Jul 29, 2021 08:08 PM
Oh damn, I forgot about that! Thanks for clarifying! I’ve only used webhooks with Integromat so far, which is why I got confused.
Anyways, @Jesse_Elkin, you can always do what I do with my clients, which is just have the button trigger an Integromat webhook, and then have all of your automations over there.
Jul 30, 2021 05:17 AM
Thank you guys very much. Seems like a lot more work than necessary just to mark an order as shipped. I can see how this solution would work in some cases but it’s excessive to have it pop up a new window and click another button, then close the window and see if it updated the field to the word shipped. Doing that every time doesn’t save time unfortunately. Back to Google spreadsheet with a drop down for now.
Jul 30, 2021 05:58 AM
I would just use a checkbox field. It’s better than clicking a button anyways, because you have visual proof that it was checked, and a timestamp when it was checked.