Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hello everyone,

I have two Zaps connected to a single table, and they currently use an identifier in the Zapier table. However, I only want the Zaps to pick up the most recent entry. Right now, the Zapier table displays a list of all previous entries, and since the identifiers have similar names, I need a way to filter it to show only the latest one.

Additionally, how can I configure the Zapier table to look up the Zapier timestamp and use it for this process?
 

 

The process that I am currently using.

Hi there, ​@hmhg! 👋

With Date & Time fields there isn’t a “most recent” type of search operator that you could use in a Find Record action to search a table. But you could potentially use a Find Records (Output as Line Items) to get all the records with that same identifier. Then use a Formatter (Utilities > Line-item to Text) action to pull the Record ID for each of the records the previous step found, to get the Record ID of the last record:

aa05040be649635cbc80391abcc0c86a.png

a06704d96819905ae033489cdfd0dca4.png

Then, you could use that Output Item Last field in a Find Record action to pull all the details for just that specific record:

5bdfd94f1ea1ea91285c611dd5a5bbed.png

Do you think that sort of approach could work?

Thanks 

Hi there, ​@hmhg! 👋

With Date & Time fields there isn’t a “most recent” type of search operator that you could use in a Find Record action to search a table. But you could potentially use a Find Records (Output as Line Items) to get all the records with that same identifier. Then use a Formatter (Utilities > Line-item to Text) action to pull the Record ID for each of the records the previous step found, to get the Record ID of the last record:

aa05040be649635cbc80391abcc0c86a.png

a06704d96819905ae033489cdfd0dca4.png

Then, you could use that Output Item Last field in a Find Record action to pull all the details for just that specific record:

5bdfd94f1ea1ea91285c611dd5a5bbed.png

Do you think that sort of approach could work?

Thanks for the detailed answer. While this approach could work, I used a unique identifier for each unit in the table. That made it easier.

You are most welcome, ​@hmhg! 🤗 Glad to hear you were able to improve things by using a unique identifier for the records in the table—that’s the perfect way to ensure that the correct record is found. Nice work! 🙌

Seems like you’re all set for now but please do reach back out if there’s anything else we can help with. 

In the meantime, happy Zapping! ⚡️

Terms & Conditions