A way to trigger a automation when a certain number of records are created?
Hi Carlos. It’s not something I’ve ever tried, but I can envision a couple of ways. Let’s start with the first and maybe won’t need the second.
In your automation, your trigger is on “when a record is created”. Then you will use a find records action with a condition that matches all records (like your primary field is not empty or whatever) or use a view that zero filters. Lastly, you will create a conditional action based on the length of list of records found in the prior action. Would that, or something like it, work for you?
The Find Records step searches for the first 100 records that match the conditions. I would use your general methodology, but replace the Find Records step with a Run a Script Action that queries the table and outputs the total number of records.
You can use a script like the one below:
let {recordURL} = input.config()
let urlParts = recordURL.split("/")
let tableId = urlParts.find(x => x.substring(0, 3) === "tbl")
let count = 0
if (tableId) {
let table = base.getTable(tableId)
let query = await table.selectRecordsAsync({fields: []})
count = query.records.length
}
output.set("count", count)
^ The script above makes use of an input variable to always pull from the table in which the trigger record resides using an input variable for the record URL and extracting the table ID:
Alternatively, you could delete all lines before:
let tableId = urlParts.find(x => x.substring(0, 3) === "tbl")
and replace that line with
let tableId = "Name of Table"
but if you ever rename your table, you’d have to go back and modify the script to reflect the new table name. The original script should require no edits even if you switch the table from which the Automation is supposed to fire from.
