Apr 08, 2024 03:49 PM
So we've set an Airtable Automation where every day at 12:00PM it sends an email digest to the project managers to show Rush or High Priority tasks that are due today or before today. I had one question:
Is there a way to have the link of each task on the email? For instance, once we get those emails with the tasks due, it would be nice to have it where each task comes with the respective Airtable link that leads to the corresponding task right away.
I've attached the screenshot of the current automation set. Thank you!
Apr 09, 2024 05:13 AM
Try adding a formula field that you've set up to output that record's URL and including that field in your digest? Formula would look something like this:
"https://airtable.com/appTqt9UBqYweeXJy/tblk74uhzTlPmgerR/viwqDoKDSZre5hell/" & RECORD_ID()
Where you'd need to replace the base ID, table ID and view ID as needed