Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Is there any functions like the function Large in Excel?

Topic Labels: Formulas
165 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hey here,

I’m tring to find the second to the max value of a array, but i can’t find any functions like Large in Excel.
Is there any way to implement this function?
Thanks for your help

2 Replies 2

I’m not sure how you could do it with a formula field but in an automation you could use

function secondLast(array) {
  return array.at(array.length - 2)
}

secondLast(yourArray)

Thanks! And i have tried to deal with it by using some js scripts :grinning_face_with_smiling_eyes:

`let mainTable = base.getTable(“list”);
let mainTableRecords = await mainTable.selectRecordsAsync({fields:[“volume”,“cal”]});
let mainTableSum =await mainTable.selectRecordsAsync({fields:[“cal”]});
for (let record of mainTableRecords.records) {
let recordget= record.getCellValue(“volume”);
if(recordget===null){}
else{
var sumval= recordget[0]+recordget[1];

    await mainTable.updateRecordAsync(record, {
            "cal": sumval
        })
   };

}
`