Ryan_Banks - profile

Ryan_Banks · Feb 23, 2023

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...

Ryan_Banks · Feb 02, 2023

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...

Ryan_Banks · Oct 26, 2022

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...

Ryan_Banks · Oct 04, 2022

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...

Ryan_Banks · Sep 30, 2022

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...

Ryan_Banks · Oct 26, 2022

@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...

Ryan_Banks · Oct 05, 2022

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...

User Statistics

User Activity

Integrate Airtable with Google Looker (Data) Studio

Error: Field "fld5tAFeW3sH3A4tK" cannot accept the provided value. How to find this Field?

Webhook automation trigger: automation starts before previous automation has completed

Obtain Record ID - Using input.config

Count the number of Records in a Table using Script

Re: Obtain Record ID - Using input.config

Re: Obtain Record ID - Using input.config