Skip to main content

Status Update Automation After Record Opened in Interface

  • September 10, 2024
  • 1 reply
  • 15 views

Forum|alt.badge.img+4

Hi guys,

I currently have a status filed (New, Opened, Responded). I have the "New" and "Responded" sorted via automations, but is there anyway to update the "Status" from "New" to "Open" when someone opens the record within an interface screen.

Any thoughts or help would help massively!

1 reply

TheTimeSavingCo
Forum|alt.badge.img+31
  • Brainy
  • 6457 replies
  • September 10, 2024

Not easily I'm afraid; Airtable doesn't provide any automation triggers from opening a record via an Interface right now

Overengineered, but I think this might be possible with a Make webhook that would redirect the user to the expected Interface, and so we'd need to:
1. Create a Make webhook that receives the record ID
2. Make that scenario update the "Status" to "Open" if the existing Status is "New"
3. Make that scenario redirect the user to the expected Interface page as explained here: https://community.make.com/t/is-it-possible-to-redirect-a-webhook-url-to-a-new-url/12974/4
4. Make the user click this webhook link to go to the record in the Interface: I wrote a guide for this here: https://community.airtable.com/t5/show-tell/how-to-guide-update-an-airtable-record-via-a-button-field-with-a/td-p/193422

Not too sure about the user experience for this.  I think after they click the button it'll be open in a new tab, and it'll be a black screen for a second before transitioning to the Interface