Jun 07, 2023 09:35 PM
Hello everyone! I'm attempting to construct email and Slack automation to remind my team to update specific projects (records) in a project management interface. When we were in data mode, I merely included a link to the Record URL in the automation message body. Is there a method to refer to a specific project or record in the formatting of the record review? Or in the format of the record summary?
I sent the following video to customer support. They suggested I post here since I have not heard back from them.
Jun 08, 2023 01:23 AM
Hmm, your interface URL should look something like this for the record summary / review, right?
`https://airtable.com/appiwunH4wOlqyp6D/pagAQW1QOfb0hZwSi?6GemF=recrL3QTSopwzvg9X`
If so, you should be able to replace "rec..." with the ID of the specific record you want and it should do what you're looking for I think
Jun 08, 2023 11:28 AM - edited Jun 08, 2023 11:29 AM
Hi @kanyewest7,
@Megan_Lask happened to ask the same question over here (same day too!) 🙂
To answer, you can construct an interface URL using a formula field to combine the part before the "rec..." at the end with RECORD_ID() in the same formula. The formula would look something like:
"https://airtable.com/appP5hH3nWTbTk2Iv/pag4lRoOvssMC0fRx?kgkbw=" & RECORD_ID()
with your interface's URL (minus the last "rec" part) between the quotes instead.
Then you are free to use this field in an automation or paste in Slack.
Hope that helps!
-Stephen