Forum Discussion

FatimaKhan's avatar
FatimaKhan
Qrew Trainee
4 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's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
What is your key field? Are you including that field in your upload?

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
  • FatimaKhan's avatar
    FatimaKhan
    Qrew Trainee
    4 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's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      4 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's avatar
        FatimaKhan
        Qrew Trainee
        4 years ago
        The field name is Identifier. The Agent ID"Date"  (A123456"03/10/2022") is what goes in the field.

        ------------------------------
        Fatima Khan
        ------------------------------