Skip to main content

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

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)

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:i“volume”,“cal”]});

let mainTableSum =await mainTable.selectRecordsAsync({fields:A“cal”]});

for (let record of mainTableRecords.records) {

let recordget= record.getCellValue(“volume”);

if(recordget===null){}

else{

var sumval= recordget 0]+recordgetr1];


    await mainTable.updateRecordAsync(record, {

            "cal": sumval

        })

   };

}

`

Reply


Terms & Conditions