HI, this is my code for my payload posting to a table using Google Apps Script: var payload = JSON.stringify({"records": [{"fields": {"OnlineSubmissionLink": [{ "id": linkedRecordID }], // Set the linked record field// "SaleDate": formattedSaleDate,/...
Hi, I am having trouble connecting to the Airtable Library from Google App Script. Google App Script is asking me for a Script ID but I don't seem to be able to find one. I am also confused by the replacement of the Airtable API with PAT which I equa...
I have a Bikes table containing a form that collects bike details, either for bikes donated to a charity, or bikes that are repaired on behalf of customers by the charity. The view is linked to a Customer table.
On my form, the first field is a ‘Bi...
I have created a Form to collect Customer data but the need for an Email address field to be ‘Required’ is conditional on the selection of a previous field. Is this something one is able to set, or is a field simply Required or not?
Thanks!
Thank you. I have this so far:// Airtable integration with PATconst airtable = Airtable.configure({endpointUrl: 'https://api.airtable.com',apiKey: ScriptApp.getEnvironment().getVariable('AIRTABLE_PAT')});const table = airtable.base('appCf1sGZAwiIBU6k...
