Hi Airtable Community,I am wanting to create dashboards to represent my data from Airtable, using Google Looker Studio. What is the best way to get my data from Airtable into Looker Studio automatically? I have tried using the 3rd party Airtable Conn...
Hi Airtable Community,I have the error as shown in the subject in my script. I am struggling to determine the field that it is referring to. Is there a way to identify fields by this "code" or am I missing something? I have no linked fields in my tab...
Hi Airtable Community,
I have a base that receives and manipulates data coming in using a webhook. Data comes in as a single record (so each webhook brings in a single record of data) and that single record needs to be processed completely before the...
Dear Airtable Community,
I have created an automation that has multiple actions:
Triggered by a webhook (beneficiary data comes in with various traits)
Creates a new record in Table 1 with this new data as is (no manipulation)
Runs a script that a...
Hi All,
I am using script to assign a unique ID to a household. Part of doing this includes counting the number of records that currently exist in the table that the unique ID will be assigned to. I am struggling to obtain this count.
I created a col...
@Justin_Barrett Thanks for the reply.
The issue was that I was testing the script - and in that test a dummy RecordID is created, therefore the updateRecords function is not able to find that RecordID in the table. Once I let the script run it ran as...
Hi @Justin_Barrett,
Thanks for the response! I’ve posted the script below:
//Create Arrays for IDs, DOBs and Genders
var inputConfig = input.config();
var idArray = inputConfig.hhMembersIDs.split(“,”);
var dobArrayRaw = inputConfig.hhMembersDOBs.spli...
