Olivia_Ehrenrei - profile

Olivia_Ehrenrei · Jan 30, 2022

Is there a method on base(‘tableName’) that can get the length (number of records) of the table? Here is part of my code: var Airtable = require('airtable'); var base = new Airtable({ apiKey: 'myApiKey' }).base( 'myBaseId' ); base('tableName'). ...

Olivia_Ehrenrei · Jan 28, 2022

I want to know (and then trigger an automation) when there are 10,000 records added to my table. How can I do this?

Olivia_Ehrenrei · Jan 28, 2022

I’m using a custom script to get records form the base I am in. To do this, I am using using: base.getTable('Incoming'); Now, I’d like to create new records using data from the records in base.getTable('Incoming') in a table that lives in a differen...

Olivia_Ehrenrei · Jan 27, 2022

I’m trying to use the scripting app to: Get all of the records from one table (this Table is called “Incoming”)Copy all the records from the Incoming table to a different table called “Copied” Here is my code: let tableIncoming = base.getTable('Incom...

Olivia_Ehrenrei · Jan 23, 2022

I have a table that gets a lot of log data – about 8,000 records per month. Since a table can only hold 50,000 records and a base can only hold 100,000 records, I’d like to move the table to another base (on a given date or after a specified amount o...

Olivia_Ehrenrei · Jan 30, 2022

kuovonne: There are several other techniques to get the number of records, using different combinations of scripting, automations, and base design. That’s helpful! I’m using the API in a react app – how would recommend the best way to get the ...

Olivia_Ehrenrei · Jan 30, 2022

kuovonne: const table = await input.tableAsync('Pick a table'); const queryResult = await table.selectRecordsAsync({fields: []}); const recordCount = queryResult.records.length; output.text(`Table [${table.name}] has ${recordCount} record(s).`);...

Olivia_Ehrenrei · Jan 28, 2022

kuovonne: You would not create a react app. That is for creating a custom app, not using the REST API. The documentation for the REST API is quite good and has all the information that an experienced developer needs. But how can I use the API ...

Olivia_Ehrenrei · Jan 28, 2022

I think I can craft them on my own, but I’m still unsure of how to reference the base in the scripting app? Would I have to create a custom React app to do this? Also, I just saw the “sync table” feature: Is there a way to do this programmatically? ...

Olivia_Ehrenrei · Jan 28, 2022

I guess I’m wondering how to access the below (from API docs) in the scripting: var Airtable = require('airtable'); var base = new Airtable({apiKey: 'YOUR_API_KEY'}).base('appLeAWrWWE5ctwux'); How can I use the API in a script if I don’t have access...

User Statistics

User Activity

Is there a method on base('tableName') that can get the length (number of records) of the table?

Is there a way to count the number of rows in a table?

In scripting, is there a way to access a different base than the one that you are in?

Scripting functions -- Creating/copying records

Is there a way to programmatically move a table from one base to another?

Re: Is there a method on base('tableName') that can get the length (number of records) of the table?

Re: Script to count records in tables and total in base

Re: In scripting, is there a way to access a different base than the one that you are in?

Re: In scripting, is there a way to access a different base than the one that you are in?

Re: In scripting, is there a way to access a different base than the one that you are in?