Locating a specific, dynamic record and updating a field

[msw_SLP]

Hi Airtable gurus,

I am trying to create an automation that will locate a specifc record based on the record ID then update the Status field.

It would look like this:

Trigger: When a webhook is received (an invoice is paid in Stripe) I actually have the webook created

Event: 1. Locate record (the appointment record that was created based on a Calendly appointment creation), 2. Update that record to reflect that the invoice for that appointment was PAID

I feel like I am close to getting the automation to work, but I can't figure out how to find that appointment record based on the record ID. Any help would be so appreciated!

[Eric_L · Accepted solution]

Hi,

If I understand correctly, your webhook has triggers the automation, and passes a string that corresponds to a record ID, and you now want to use this ID to update that record to mark it as paid.

If this is the case, then all you need is :

1. Add a "Record ID" field to your table. That field is a formula and the formula is simply: RECORD_ID()
2. In your automation, add the "Update Record" action
3. Select the right table, and in the "Record ID" field, click on the input and navigate to your Webhook's payload. Your record ID should be there, if properly configured from Stripe.
4. Below that, select the field to update, and put the value you want.

Does this help?