find the biggest number from all results

[elhanan cohen]

Hi! I export all records from Airtable and I want get the the largest number

 

[Supreme]

Hey @elhanan cohen

Can you please share the workflow URL in which you are trying the same to get the latest record number?

 

[elhanan cohen]

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

 

[Supreme]

Please check your third step we have added a JS code action step to get the latest record, I hope this might help you out.

 

[elhanan cohen]

Thanks! working!
const jsonData =
[All records]

// Extracting the "counter" values from the JSON data and finding the largest number
const largestCounter = jsonData.reduce((max, item) => {
const counter = item.fields["counter"];
return counter > max ? counter : max;
}, -Infinity);

console.log("The largest number in the 'counter' field is:", largestCounter);