This allows you to introduce automation elements in your projects, automatically running specific tasks and actions.
#SCRIPT AIRTABLE HOW TO#
Var ss = SpreadsheetApp.getActiveSpreadsheet() What is Airtable scripting and how to get started The scripting app allows you to write code in Airtable. When the automation runs successfully, a corresponding email will be sent to selected email targets, containing the customizable information of your choosing during the automation configuration process. fetch table names from the control panel of the spreadsheet Dark When building an Automation, you may choose the Send an email action. //////// function to trigger the entire data syncing operation /////////// addItem('Manually sync all data', 'syncData') createMenu('Airtable to google sheets sync') Var tablesToSync_fromSheetRange = "A14:B15" //UPDATE CELL RANGE HERE (for tables that you want to sync) Var baseID = "XXXXXX" //ADD YOUR BASE ID HERE I would create a temporary view, filter it based on something existing in your data to select the records you want to update, then update records in this view using the 'Add/remove multiple choices' action of the Batch Update extension. Here is the script var api_key = "XXXXXX" //ADD YOUR API KEY FROM AIRTABLE HERE Hi WilliamSweet, You can use the Batch Update extension by Airtable to quickly update records contained within a view. Using Zapier is not an easy option since we have more than 400 fields. Problem is, it seems each time the script runs it retrieves the Fields in a random-ish order, which is a problem because those fields are referred to in the reports. Im using a script (that I found here in the community, thanks btw!) to pull data from Airtable to Google Sheets in order to make some weekly reports for employees in a company.
0 kommentar(er)
