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!
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.