About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Best answer

How to update a record without creating duplicates in Tables using Zapier?

  • 23 February 2024
  • 4 replies
  • 103 views
J

Hi folks, first time here. Greetings.

I’m struggling with Tables. I have a form on an interface page, page Q1. When I use a zap to update a record on form submission, it creates a new record and leaves the original record in the table. Instead I just want it to update the record, not duplicate it.

Here’s the table showing a duplicate entry instead of just updating column Q1 to true:

Here’s the Zap:

 

I’d be utterly grateful if someone could explain to me how to avoid the duplicate record in the Table!

Thanks in advance.

icon

Best answer by Troy Tessalone 23 February 2024, 18:13

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @James C 

Check your Zap Runs history to see the DATA IN/OUT for each Zap Run to help you troubleshoot why duplicates are happening: https://zapier.com/app/history/

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
J

Thanks @Troy Tessalone , I went ahead and checked that.
Data in/out are fine with and it all goes through ok with status 200’s for GET, GET, PATCH.

I just looks like zaps to “Update Record” actually mean “Create New Record”  leaving the existing record in the Table - why on earth I don’t know! Seems bonkers to have additional rows in a table for each new update to a record, rather than updated the record all on one row.

 

 

Data In

table_id:

01HQ6865V3EB3RRHDZWTH1V8YY

record_id:

01HQBBN7P20A3ZV76KAPY7HVJY

new__data__f13:

True

zap_id:

228110104

zap_step_id:

228110105

zap_path_run_id:

006299f6-8aee-aacc-96bf-6abb7e22c491

 

Data Out:

new:

data:f1:

y@l.com

f2:

null

f3:

null

f4:

 

f5:

true

f13:

True

f14:

null

f15:

null

f16:

null

id:

01HQBBN7P20A3ZV76KAPY7HVJY

edited_at:

2024-02-23T16:09:35.071841+00:00

created_at:

2024-02-23T16:09:31.074000+00:00

schema_revision_id:

25

errors:

old:

data:f1:

y@l.com

f2:

null

f3:

null

f4:

 

f5:

true

f13:

 

f14:

null

f15:

null

f16:

null

id:

01HQBBN7P20A3ZV76KAPY7HVJY

edited_at:

2024-02-23T16:09:31.073719+00:00

created_at:

2024-02-23T16:09:31.074000+00:00

schema_revision_id:

25

errors:

record_id:

01HQBBN7P20A3ZV76KAPY7HVJY

table_id:

01HQ6865V3EB3RRHDZWTH1V8YY

change_id:

01HQBBNBP81TNMZQKH5NEMT7J2

 

Logs output:

{ "data": [ { "change_id": "01HQBBNBP81TNMZQKH5NEMT7J2", "old": { "data": { "f1": "y@l.com", "f2": null, "f3": null, "f4": "", "f5": true, "f13": "", "f14": null, "f15": null, "f16": null }, "id": "01HQBBN7P20A3ZV76KAPY7HVJY", "edited_at": "2024-02-23T16:09:31.073719+00:00", "created_at": "2024-02-23T16:09:31.074000+00:00", "schema_revision_id": 25, "errors": {} }, "new": { "data": { "f1": "y@l.com", "f2": null, "f3": null, "f4": "", "f5": true, "f13": "True", "f14": null, "f15": null, "f16": null }, "id": "01HQBBN7P20A3ZV76KAPY7HVJY", "edited_at": "2024-02-23T16:09:35.071841+00:00", "created_at": "2024-02-23T16:09:31.074000+00:00", "schema_revision_id": 25, "errors": {} }, "record_id": "01HQBBN7P20A3ZV76KAPY7HVJY" } ], "events": { "planned": [], "suppressed": [] }, "meta": null }

Troy Tessalone
Userlevel 7
Badge +14

@James C 

If you suspect an issue, you can try opening a ticket with the Zapier Tables Team: https://eap.zapier.app

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
J

@Troy Tessalone Will do, thanks very much for your time and input 👏

Terms & Conditions