Best answer

The Zap creates multiple records for new leads with the same phone number when importing.

  • 27 September 2023
  • 17 replies
  • 100 views

Userlevel 1
Badge +1

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.

Hi,

I’m running into a problem I haven’t had before (it worked as intended). 

I would like to update the information on new leads, and I’m using the “Find or Create Record” feature for this. The parameter I use is the phone number:

 

 

This is used here:

 

But...multiple records are being created: 

 

 

Do you have any idea what goes wrong?

 

Thanks so much :)

icon

Best answer by Troy Tessalone 27 September 2023, 20:18

View original

17 replies

Userlevel 7
Badge +14

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.

Hi @ssielmann 

Good question.

Below is likely why duplicates are being created.

You can add a Formatter > Number > Format Phone Number step.

The Lookup Value phone number has a leading +.

 

The Zapier Tables Phone Fields doesn’t have a leading +.

 

Userlevel 1
Badge +1

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.

Thanks @Troy Tessalone  :) 

 

This makes sense, but I still get duplicate values: 

This is my config: 

Is it correct? 

 

Thanks so much for helping!

Userlevel 7
Badge +14

@ssielmann 

That isn’t a valid phone number value, which may be contributing to the issue.

 

Userlevel 1
Badge +1

You’re right @Troy Tessalone  , the test value is wrong. But the live data is correct! Thanks for checking, great idea. 

 

Any other hint by any chance? Can’t believe it’s not working.

Userlevel 7
Badge +14

@ssielmann 

We would need to see screenshots from the live Zap Runs to see the DATA IN/OUT for each Zap step.

https://zapier.com/app/history/

Userlevel 1
Badge +1

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.

Sure thing 🤓

 

 

 

 

 

Complete list of data in:

  • table_id:
    01HAM9F50HEC25EXCPH1VPQ7TW
    filter_count:
    1
    field_data_key:
    data__f9
    operator:
    exact
    lookup_value:
    xxxxxxxxxx
    new__data__f1:
    {{205916918__fields__User First Name}}
    new__data__f2:
    {{205916918__fields__User Last Name}}
    new__data__f5:
    {{205916918__fields__User E-Mail}}
    new__data__f7:
    {{205916918__fields__User E-Mail}}
    new__data__f8:
    2023-09-27T21:34:30.816Z
    new__data__f9:
    491456543786
    new__data__f10:
    {{205916918__fields__ref}}
    new__data__f11:
    {{205916918__fields__aff}}
    new__data__f16:
    {{205916918__fields__User Street & No}}
    new__data__f17:
    {{205916918__fields__User ZIP}}
    new__data__f18:
    {{205916918__fields__User City}}
    new__data__f19:
    Ja
    new__data__f20:
    {{205916918__fields__Mandate City}}
    new__data__f21:
    golilo
    new__data__f27:
    {{205916918__fields__Unterschrift - Signature}}
    new__data__f26:
    {{205916918__fields__Mandate Date}}
    new__data__f28:
    {{205916918__fields__Unterschrift}}
    new__data__f38:
    Aboalarm
    new__data__f29:
    {{205916918__fields__Bitte nenne uns den Link zu deinem Facebook-Profil}}
    new__data__f30:
    {{205916918__fields__Nutzt du dein Facebook-Profil auch beruflich?}}
    new__data__f31:
    {{205916918__fields__Bist du vor oder nach dem 25. Mai 2018 Facebook beigetreten?}}
    new__data__f33:
    {{205916918__fields__Beschreibe, welche Art von Werbung du erhalten hast:}}
    new__data__f34:
    {{205916918__fields__War die erhöhte Belästigung vielleicht sogar ein Grund dafür, dass du deine Handynummer gewechselt hast?}}
    new__data__f32:
    {{205916918__fields__id-b190d980}}
    new__data__f35:
    {{205916918__fields__Ich werde meine Einstellungen zur Privatsphäre ändern}}
    new__data__f36:
    {{205916918__fields__Ich werde Daten von meinem Facebook-Profil löschen}}
    new__data__f37:
    {{205916918__fields__Ich werde mein Facebook-Profil löschen:}}
    new__data__f39:
    Ja
    zap_id:
    205916918
    zap_step_id:
    208478537

 

And data out: 

 

  • new:

    data:f1:
    null
    f2:
    null
    f3:
    null
    f4:
    null
    f5:
    null
    f6:
    null
    f7:
    null
    f8:
    2023-09-27T21:34:30Z
    f9:
    491456543786
    f10:
    null
    f11:
    null
    f13:
    null
    f14:
    null
    f15:
    null
    f16:
    null
    f17:
    null
    f18:
    null
    f19:
    Ja
    f20:
    null
    f21:
    golilo
    f22:
    null
    f23:
    null
    f24:
    null
    f26:
    null
    f27:
    null
    f28:
    null
    f29:
    null
    f30:
    null
    f31:
    null
    f32:
    null
    f33:
    null
    f34:
    null
    f35:
    null
    f36:
    null
    f37:
    null
    f38:
    Aboalarm
    f39:
    Ja
    id:
    01HBC91BBMJZVRWD6RVDK36GTJ
    edited_at:
    2023-09-27T21:34:34.866546+00:00
    created_at:
    2023-09-27T21:34:34.868000+00:00
    schema_revision_id:
    72

    errors:

    record_id:
    01HBC91BBMJZVRWD6RVDK36GTJ
    table_id:
    01HAM9F50HEC25EXCPH1VPQ7TW
    change_id:
    01HBC91BBV9YJTKQBJ1ZS71NAD
    _zap_data_was_found:
    false

    Fields with no value:

    old

Userlevel 1
Badge +1

I just saw, that an extra “49” was appended to the phone number. This can be an issue, but not the ultimate one, because the zap also does not update this appended version of it the next time I run it. 

Userlevel 7
Badge +14

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.

@ssielmann

Did you update this value to be the output from the Formatter step?

 

Userlevel 1
Badge +1

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.

Yes :) 

 

 

Userlevel 1
Badge +1

The crazy thing is - it all used to work a couple of hours ago :/ 

Userlevel 7
Badge +14

@ssielmann 

You can try submitting a ticket to the Zapier Tables team to see if perhaps some recent update broke this Zap action: https://eap.zapier.app

Userlevel 1
Badge +1

Thanks, will do!

Userlevel 1
Badge +1

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.

@Troy Tessalone I had another idea and created a text field for the matching (instead of using the phone field, which has its own rules). 

 

No there are no duplicates, but the information does not appear anywhere in the table. 

 

It was all successful and didn’t give any errors, do you have any idea why this could happen?

 

 

Userlevel 7
Badge +14

@ssielmann 

FYI: Step 4 logic is really a find else create record

 

You’ll need to check the DATA OUT

That should include the Record ID.

 

Userlevel 1
Badge +1

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.

Yes, the record IDs are the same, so that matching should happen in theory. 

 

I can even find the values when testing: 

It appers in the logs: 

 

 

...but somehow disappears along the way: 

 

Userlevel 1
Badge +1

It’s really lost: 

 

 

vs

 

 

Userlevel 7
Badge +14

@ssielmann 

If Zapier Tables isn’t working for you try using Airtable.

Reply