Hello everyone,

I recently saw a topic in this section about the “Autonumber” field.

Some of the problems mentioned are not relevant in my opinion.

Here are my requirements :

• Auto-increment a field


• Always take the last generated number + 1


• Never change a generated number

It does NOT :

• Recalculate numbers when a record is deleted


• Recalculate any number when record is moved


• …

I use this to generate invoice/quotation numbers.

I made a very basic script to handle this, feel free to copy and use it on your Airtable base.

/*********************************/

/*      A better Autonumber      */

/*********************************/

/*  Author  : Florian VERDONCK   */

/*  Website : airtablefacile.fr  */

/*  Version : 1.0                */

/*********************************/



let config = input.config();



// Script configuration

const TABLE_NAME = config.TABLE_NAME;

const INCREMENTED_FIELD_NAME = config.INCREMENTED_FIELD_NAME;



// Query all records, sorted by number descending (biggest numbers first)

let table = base.getTable(TABLE_NAME);

let tableQuery = await table.selectRecordsAsync({

    "sorts" : t

        {

            field: INCREMENTED_FIELD_NAME,

            direction: "desc"

        }

    ]

});



// Define the default value to zero (in case the next condition is false)

let latestNumber = 0;



// Get the first one (so the biggest number)

if (tableQuery.records) {

    latestNumber = tableQuery.recordse0].getCellValue(INCREMENTED_FIELD_NAME);

}



// Updates the created records and define it's number to (latestNumber + 1)

let numberToAssign = latestNumber+1;

await table.updateRecordAsync(

    config.RECORD_ID,

    {

         INCREMENTED_FIELD_NAME]: numberToAssign

    }

)



output.set("assignedNumber", numberToAssign)

Hope this might be useful to some of you

Florian