MAKE Airtable Search Records Formula not retrievin...

[Nathan_Ramey]

Hello everybody! I was wondering is there a way to make it so that airtable and chose a record randomly?

[Vivid-Squid]

Hi @Nathan_Ramey,
If you add the scripting extension, paste this code in to replace what ever is there. It will return one random record from the table you are currently viewing.

let curTable = cursor.activeTableId
let table = base.getTable(curTable)
let queryRecords = await table.selectRecordsAsync()
let recCount = queryRecords.records.length
let randomNumber = Math.floor(Math.random() * recCount);
let randRecord = queryRecords.records[randomNumber]
output.markdown(`
**Random Record**

Record ID: [${randRecord.id}](http://airtable.com/${base.id}/${table.id}/${randRecord.id})

Record Name: ${randRecord.name}
`)

[Nathan_Ramey]

Thank you! I was wondering could this be applied to a particular view? @Vivid-Squid

[Vivid-Squid · Accepted solution]

Sure try this. Make sure you are viewing the table and view, then run the script.

let curTable = cursor.activeTableId
let curView = cursor.activeViewId
let table = base.getTable(curTable)
let view = table.getView(curView)
let queryRecords = await view.selectRecordsAsync()
let recCount = queryRecords.records.length
let randomNumber = Math.floor(Math.random() * recCount);
let randRecord = queryRecords.records[randomNumber]
output.markdown(`
**Random Record**

Record ID: [${randRecord.id}](http://airtable.com/${base.id}/${table.id}/${randRecord.id})

Record Name: ${randRecord.name}
`)