Key field not updating existing records
Hi, I am having an issue with updating an existing record. The key field is exactly the same but new downloads keep creating new records. ------------------------------ Fatima Khan -----------...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendWhat is your key field? Are you including that field in your upload?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
I am using this as a key field (Agent ID"Date") and I named it Identifier. It is the same on both spreadsheets for the upload.
------------------------------
Fatima Khan
------------------------------
------------------------------
Fatima Khan
------------------------------
- MarkShnier__YouDoes your field name actually have Quotes in the name? Maybe rename the field not to have quotes and rename the column heading in the upload.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- The field name is Identifier. The Agent ID"Date" (A123456"03/10/2022") is what goes in the field.
------------------------------
Fatima Khan
------------------------------- MarkShnier__You
When the data is actually imported, what is ending up in the key field?
My guess is that the quotes in the data are confusing the import.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------