Automation Emails with Record Grid that links to the referenced Records

Hi there,

We use email automation to send emails include a grid with records in the email body. How do I include a link to those records in the grid so that email recipients with Airtable accounts can click the referenced record and immediately be taken to the correct record to update?

thanks!

Welcome to the community, @Josh_Bushinsky!

You will need to create another field on your grid, which is a formula field that equals the URL for that record.

If you expand one of your records, you will see that its URL looks something like this:

https://airtable.com/appXXXXXXXXXX/tblXXXXXXXXXX/viwXXXXXXXXXX/recXXXXXXXXXX

The URL shows the app ID, the table ID, the view ID, and the record ID.

So create a formula that matches everything but the record ID, and then for the record ID, use the function RECORD_ID()

So your final formula would look something like this:

"https://airtable.com/appXXXXXXXXXX/tblXXXXXXXXXX/viwXXXXXXXXXX/rec" & RECORD_ID()

1 Like

@ScottWorld Thanks for the welcome and the quick help. The new formula worked perfectly, except that RECORD_ID() returns “recXXXXXXX”. So the final formula is:

https://airtable.com/appXXXXXX/tblXXXXXX/viwXXXXXX/”& RECORD_ID()

Once I reran a test of the Find records step of the Automation, the links worked perfectly. Thanks again!

1 Like

Oh, haha!! Thanks for the correction!! :stuck_out_tongue: And glad that it worked!

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.