How can I fetch only the most recently added Airtable record?

Below are a couple of approaches you can take to ensure you only work with the most recently added record:

---

1. Use the Appropriate Trigger

If your goal is to fire your automation when a record is created (not updated), consider using the "When record created" trigger instead of the "When record updated" trigger. That way, your workflow will start with the newly added record as soon as it’s created.

---

2. Sort and Limit with a List Operation

If you need to use a List operation (for example, on a scheduled workflow rather than an event-based trigger), you can:

1. Configure the List Operation:

   • Choose the List operation in your Airtable node.
   • Under the options, enable sorting and set it to sort by your created timestamp (or another field that reliably indicates record order) in descending order.
   • Limit the results to 1 record.

2. Example JSON Options:

JSONCopied
{
  "sort": [
    {
      "field": "Created Time",
      "direction": "desc"
    }
  ],
  "maxRecords": 1
}

Note: Depending on your chosen setup, the field name may differ. Use the field that best represents when the record was added.

---

3. Post-Processing with a Sort Node

If you must work with the trigger node and it returns multiple records, you can add a processing step (such as the Sort node or a Function node) to sort the incoming array of records by a timestamp field (e.g., created time) in descending order, then select the first record.

For example, a simple JavaScript snippet in a Function node might be:

JAVASCRIPTCopied
// Assume items is the array from your trigger
items.sort((a, b) => {
  // Replace 'createdTime' with your actual timestamp field
  return new Date(b.json.createdTime) - new Date(a.json.createdTime);
});
return [items[0]];

---

Choose the strategy that best fits your use case. If you simply want to react to new records being added, switching to the "When record created" trigger is likely the easiest and most straightforward solution.