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

Question

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!

icon

Best answer by Troy Tessalone 18 August 2021, 06:08

View original

Troy Tessalone · Accepted Answer

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

Halcyon · Answer

This is awesome, thanks for the help. You’re right, an airtable automation made this really easy.

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded