Upload question

I was going to suggest using the "Must be unique" option on each field you would like to be unique but I need to clarify something first.

Are you wanting to upload a file and have QuickBase basically look through the file and do something? Or do you mean importing a csv when you say uploading a file? If importing a csv then you could absolutely use the Must be unique option for fields.

My suggestion is to upload the file to a special table in your app for uploads.  his is a temporary scratchpad table where you can make various report to scrub your data and prepare it for import.  Then have a button to import from he scratchpad to the real table.

for example that table can have Summary reports sorted on the Unique fields to sort them up to the top to be dealt with manually.  If the non unique values are true duplicates, you can make a summary report off the scratchpad table and use the More ... button to copy these record to another table.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

If you are wanting to check you data before uploading and have access to MS Excel, there is a Remove Duplicates function in the Data tab of the ribbon. You can select the columns in question one at a time and the Remove Duplicates function will delete duplicates and tell you the number of records that were duplicate. You could also insert a PivotTable and create a count of your records to see if there are more than one records with the same value. A third option is conditional formatting; there is an option to highlight cells that have duplicates.

------------------------------
Adam Keever
------------------------------