import and update existing records

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • In Progress
I need to import records from excel on a daily basis. I need QB to update the existing records if the claim number is the same ( existing Vs imported). However for all the other records that entered manually ( not imported) there will be sometimes same claim ID or sometimes blank ( not unique). I'm not sure how to resolve this issue as the Claim ID in this case will not be unique and can't be set as a key field? any another idea how to resolve this?
Photo of EH

EH

  • 282 Points 250 badge 2x thumb

Posted 11 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,358 Points 50k badge 2x thumb
It is possible to set the key field to be a formula field. Is there some combination of the Claim number and another field which WOULD be unique? If so then that could work to create that Key field in both QuickBase and also as part of your excel import.
Photo of Carrollee Gresham

Carrollee Gresham

  • 62 Points
Hi.  I have a similar question.  I am importing csv data daily.  Some of the records created will need to have information in certain columns updated with hew data.  How do I set this up?  I have a unique id set up for each record . . .   I would greatly appreciate any help on this.   
Thanks,
Carrollee
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,358 Points 50k badge 2x thumb
I suggest that you post this as a new question with a more complete description.