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

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

3 years ago

What is your key field? Are you including that field in your upload?

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

FatimaKhan
Qrew Trainee
3 years ago
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
    ------------------------------