Skip to main content

Script for finding > 100 records

  • February 25, 2023
  • 2 replies
  • 48 views
R
Forum|alt.badge.img+3

Dear community,

This is my first time posting here but I would like a script that allows me to find > 100 records. Automations has a limit of 100. All the script needs to do is find all the records in my 'user' and update them as linked records in a column in the 'retention' table.

Reason for this is that I want to calculate the retention of the user base, unfortunately I have 1300 records/users that I need to include all of them in this calculation. Does anyone have any experience with this?

2 Attachments

2 replies

R
Forum|alt.badge.img+3
  • roevmos
  • Author
  • New Participant
  • February 25, 2023

Fixed!

 

// Initializing the Table!
let users_table = base.getTable("Users");
// Load the Users records
let queryResult = await users_table.selectRecordsAsync(
{
fields: users_table.fields
}
);
// Extract the IDS of the Students
let usersIDS = queryResult.records.map(user => user.id)
output.set("List of 'Airtable User record ID'", usersIDS)
Karlstens
Karlstens
Forum|alt.badge.img+24
  • Karlstens
  • Brainy
  • February 25, 2023

Fixed!

 

// Initializing the Table!
let users_table = base.getTable("Users");
// Load the Users records
let queryResult = await users_table.selectRecordsAsync(
{
fields: users_table.fields
}
);
// Extract the IDS of the Students
let usersIDS = queryResult.records.map(user => user.id)
output.set("List of 'Airtable User record ID'", usersIDS)

Your script looks like it will work well. Some methods in Automations are limited, where you’ll have to setup a batching mechanism to update 1000’s of records (which I’ve only ever needed in testing, never production). But simply finding and returning records isn’t limited as such. Any limits are typically mentioned in the support doco.

With one 30 second automation script, you can find and return many, almost countless records - but I’m found you can only update ~6,000 records before the 30 second limit times-out. 

R
Terms & ConditionsAccessibility statement