Hi @leslieburke,
If you just wanted to pre-fill a form for them that they submit afterwards, you could just create a formula field that opens & prefills the form for them, and then upon submitting the form, you could have an Airtable automation or a Make automation update the record for them.
@Kuovonne’s Prefilled Forms extension can help you create that formula:
If you don’t need them to fill out a form because you already know what the update should be when they click on the link, it would be easier to just have an incoming webhook & external automation tool handle all of that for you.
I do all of this using Make’s custom webhooks.
You can even create a custom webhook response for your users (using Make’s “webhook response” module) — it can be as simple as some plain text, or as complex as an entire webpage. You can even redirect them to an existing webpage.
And yes, for your Airtable formula, you would just combine the webhook URL and the Record ID in a formula that would look something like this:
"https://your_webhook_address.com?RecordID=" & RECORD_ID()
You only need to send the Record ID to Make, because you can use Make’s Airtable Get a Record module to grab all the field information that you need from Airtable.
Here’s an example of what the beginning of your scenario might look like in Make… and then you could add in a whole bunch of other modules to do whatever you want to do in Airtable or other external apps:
Here’s a more advanced post that I created on the different ways of creating the URL formula — and how you could trigger it with a JavaScript if you had access to that (but in your case, you don’t):
And again, in your case, you only need to send the Record ID to Make, because you can get all the other Airtable information by using Make’s “Get a Record” module.