Forum Discussion

Qrew Trainee

3 years ago

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

Data import and export

FatimaKhan

Qrew Trainee

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

Qrew Legend

3 years ago

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
Qrew Trainee
3 years ago
The field name is Identifier. The Agent ID"Date" (A123456"03/10/2022") is what goes in the field.

------------------------------
Fatima Khan
------------------------------
- MarkShnier__You
  Qrew Legend
  3 years ago
  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
  ------------------------------