Automation Scheduled Email: how to link records in the message so user can update the records

[nothingbutair]

I created a scheduled email to send weekly when the status of my table matches certain conditions.  The message was done in a grid view to include the column information.  I am trying to figure out how the user that receives the email can actually update the records using the email instead of having to go into the base table. What am I missing? Is there a way to click to the records in order to update from the email that is sent out.  Thanks!

[TheTimeSavingCo]

Depends on what kind of update you're looking for really.  If it's a lot of stuff, your best bet's a link to a form that'll update the record for you.  If it's just a single value (e.g. change status from X to Y) then you could use a link in your email with a webhook of some sort to do it instead, so the user would just click that and the update would happen automatically

[ScottWorld]

@nothingbutair 

Here are 2 great options for this:

1. For a quick update, you can use a Make custom webhook to do this. I demonstrate this with step-by-step instructions on this Airtable podcast episode.

2. For more detailed updates, use Fillout’s advanced forms for Airtable, which lets you update records from a form. Each record will have its own unique form link that will take the user to the form for that record.

p.s. If your company has a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consulting — ScottWorld 

[nothingbutair]

Ok I will look at webhook. I was hoping there was a way to just link a view or record so that once clicked it would just take them to the table.  I am not looking for them to update as much as I am wanting to direct them to the table instead of just looking at a grid view that I emailed.

[ScottWorld · Accepted solution]

Yes, that's even easier. Just put the link to the record in the email. You can create a formula that creates a unique link to each record.