How to get Latest created record in airtable?

Does your automation script need to find the latest record or do you need to indicate the latest record for something outside of the automation?

If your automation script wants the latest record, and your automation us running off a “record is created” trigger, that triggering record is the latest record at the moment it was created. Thus the automation script can simply use the triggering record as the latest record.

If you need to have a different way of indicating the latest record, such as a checkbox field marked for the latest record. Have an automation run whenever a new record is created that clears the checkbox from the one previous record with the checkbox, and then sets the checkbox in the new record.

Hey, thank you for replying
Yes, I am writing 2 automation scripts for both - when the record is created for one table and when checkbox is ticked for another table, my question is how do you use the triggering record in script or how do you get the id of triggering record in script?
I don’t want to sort all the records and get the latest record, I was wondering if there is any other way.

Use an input variable. Create the variable in the left pane of the script editor and set the value to the record ID.

Then in the script, use input.config to get the value of the input variable.

const inputConfig = input.config()
const recordID = inputConfig["recordId"]

Looks like this is a duplicate thread that has already been answered: