Key field not updating existing records

Question

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------------------------------

markshnier__you · Answer

What is your key field? Are you including that field in your upload?------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

fatimakhan · Answer

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------------------------------

markshnier__you · Answer

Does 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
------------------------------

fatimakhan · Answer

The field name is Identifier. The Agent ID"Date"&nbsp; (A123456"03/10/2022") is what goes in the field.------------------------------Fatima Khan------------------------------

markshnier__you · Answer

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------------------------------

Forum Discussion

Key field not updating existing records