Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Oct 22, 2021 07:35 AM
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!
Solved! Go to Solution.
Oct 22, 2021 10:30 AM
@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!
Oct 22, 2021 08:03 AM
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()
Oct 22, 2021 10:30 AM
@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!
Oct 22, 2021 10:39 AM
Oh, haha!! Thanks for the correction!! :stuck_out_tongue: And glad that it worked!