Scripting app - update a record in another base

There are two basic ways to update a record in another base (without using a 3rd party service).

• Use the REST API. I do not recommend doing this in Scripting app, because this would make your api key visible to any collaborators on the base.
• Use scripting to call an Airtable webhook automation in the other base. This method does not require revealing your api key. However, the webhook would be exposed. People are less likely to accidentally update the number.

However, it is possible to provide protection against accidental changes without storing the number in a different base, using table and field editing permissions. Store the number in a table in the same base. Change the table permissions so that no-one can add/delete records in the table. Change the field permissions so that users cannot directly edit the field, but automations can set the value. Then create an automation with a logical trigger to set the value of the number.

Out of curiosity, is there something about your base that prevents you from using an autonumber field to ensure uniqueness?

Thanks for the quick response @kuovonne!

Do you know of an example using the webhook automation with another airtable base? That sounds like an interesting idea. I will also look into the permissions route. I was unaware you could set it up so that it could be used by an automation and not the person who fired the automation.

To answer your question about using the autonumber field to ensure uniqueness, I went down that road first. The problem is, first, even though it could be worked around by deleting or archiving, the autonumber would quickly start to rack up the records. The second problem is handling multiple lot numbers for one order. I could relate multiple lot numbers to a single order by keeping them in another table, but this seems an unwise use of resources, as it would mean records would be piling up and there is no useful information associated with the lot number.

Thanks again for the help!

Receiving webhooks is a very new feature, so there aren’t many examples. It does require sending a POST request, versus a GET request, and you cannot access nested data. If you are not familiar with how to call a webhook, you may want to research that first.

This is also a relatively new feature and isn’t in all the documentation yet. Airtable automations don’t know who triggered them, as they do not need to be triggered from human interaction.

I was able to get the webhook working perfectly.

const data = { CurrentCount: Number(currentCount) + Number(multiple) };

let webhook = await remoteFetchAsync('https://hooks.airtable.com/workflows/v1/genericWebhook/appXXXXXXXXXXXX/wflJmpBH8mhqXXXXXX/wtrWFmZXmgXXXXXXX',
    {
    method: 'POST',
    body: JSON.stringify(data),
    headers: {
        'Content-Type': 'application/json',
    },
});

Thanks again @kuovonne!!