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.

have a table with householdname lookup (dropdown field). is there a way to count how many records there are with the same value in that field, and if more then one, then delete the latest record (CreatedDate). Thanks

Hi ​@Jazzy3 

How is data being added to the Zapier Table?

If done via a Zap, then the action to use to avoid duplicates should be: Tables - Find or Create Record

 

being done by form submission. i have to create 2 separate ZAPS to update a record so i can compare two separate fields and then delete the new record that was created if it already existed. this is all being done because ZApier Interfaces cant do lookups only form submissions on Interfaces, unless i am wrong? i was looking for a way to make this more efficient. Thanks Troy

 

​@Jazzy3 

For us to have more context, post screenshots showing how your 2 Zap have their steps outlined.

i simplified what i was trying to do, so now i need to update the latest record of a table (records might have same household name). using Find Records (Zapier Tables) to lookup Household Names. if i return more then 1 i simply want to use the latest one (Results Old Created At). Thanks

​@Jazzy3 

If there can be 2+ records returned, then you will need to add a Code step logic to derive the record ID associated to the record created timestamp you want to use.

Essentially sort by the record timestamp, then pick the first option.

Zap Code steps have a built in AI Assistant to help with the code.

https://help.zapier.com/hc/en-us/articles/15666688064013-Generate-a-Code-step-using-AI-Beta

 

TIP: Try asking ChatGPT for help configuring the Zap Code logic.

Terms & Conditions