I need help finding the most recent record in a given table with zapier. I’m trying to use zapier to create a default value which links to another table. Here’s an example:MembersFirst Name Link Last Modified Alice . August 15th Bob . August 17th Charlie August 19th Members RollupName Members Link . Alice, Bob Here’s what I’m trying to do:Whenever a new record is added to the Members table, I want to start the zap I then want to find and update the same record that kicked off the zap — in others, the one with the most recent “last modified” time (“Charlie” in the example above) Finally, I want to update the “link” field with “.” — which is the only record in the Members Rollup table.Right now, I’m structuring the zap like this:<TRIGGER> New record is created in Members<FIND RECORD> (need to find the most recently created record in Members) « this is where I’m stuck<UPDATE LINK FIELD IN THAT RECORD> Thanks for the help!

Hi@HalcyonIt’d be better to use Airtable Automations for this: https://support.airtable.com/hc/en-us/articles/360050974153-Automations-overviewIf you want to use a Zap, then try these steps:Trigger: Airtable - New RecordAction: Airtable - Update Record (map the Record ID from Step 1)Help Article: https://zapier.com/help/create/basics/set-up-your-zap-action#set-up-your-action

Best answer

How to update linked value for most recently created record in Airtable?

3 years ago
August 18, 2021
3 replies
464 views

H

Halcyon
New
1 reply

I need help finding the most recent record in a given table with zapier. I’m trying to use zapier to create a default value which links to another table. Here’s an example:

Members

First Name	Link	Last Modified
Alice	.	August 15th
Bob	.	August 17th
Charlie		August 19th

Members Rollup

Name	Members Link
.	Alice, Bob

Here’s what I’m trying to do:

Whenever a new record is added to the Members table, I want to start the zap
I then want to find and update the same record that kicked off the zap — in others, the one with the most recent “last modified” time (“Charlie” in the example above)
Finally, I want to update the “link” field with “.” — which is the only record in the Members Rollup table.

Right now, I’m structuring the zap like this:

<TRIGGER> New record is created in Members

<FIND RECORD> (need to find the most recently created record in Members) « this is where I’m stuck

Thanks for the help!

Best answer by Troy TessaloneBest answer by Troy Tessalone

Hi @Halcyon

It’d be better to use Airtable Automations for this: https://support.airtable.com/hc/en-us/articles/360050974153-Automations-overview

If you want to use a Zap, then try these steps: