Forum Discussion

MehdiMaskoot's avatar
MehdiMaskoot
Qrew Trainee
7 years ago

I need Import to do only inserting without updating existing records

Hi everyone, I have a table that I want to import my spread sheet data into it, without updating my existing records. I don't have Record ID as my Primary key. My table has its own PK. When I try to i...
Data import and export
SuryaExpert's avatar
SuryaExpert
Qrew Assistant Captain
7 years ago
As long as you have the primary key field in the xl that you are importing from, quickbase will only insert/update. If you want to only insert, I would consider removing that column from the XL.
MehdiMaskoot's avatar
MehdiMaskoot
Qrew Trainee
7 years ago
Yes, I was able to do it by creating an Action.
But, why QB team doesn't simply provide a checkbox to ask if user wants to also update or he/she only wants to insert.
They are checking for existing records anyways. They could simply ignore the existing records based on the user request and it would be even much faster to only insert.
Thanks anyways.