Automation Emails with Record Grid that links to the referenced Records

[Josh_Bushinsky]

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!

[ScottWorld]

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()

[Josh_Bushinsky · Accepted solution]

@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!

[ScottWorld]

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