Forum Discussion

JessicaAdkins's avatar
JessicaAdkins
Qrew Cadet
8 years ago

Can QB scrub a list for unique identifiers before importing?

Is it possible for QuickBase to scrub a list for unique identifiers before importing new data into a table? For example, I have a spreadsheet but only want specific rows uploaded and that would be b...
Ask about Quickbase functionality
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
You can upload the raw file to a "scratch" table and then make summary report of the UI.  Then make a summary report of the Unique identifiers, which will of course have 1 row per UI and then "Copy these records to another table" using the More ... button.

 
JessicaAdkins's avatar
JessicaAdkins
Qrew Cadet
8 years ago
Wouldn't that time be almost equivalent to the original scrubbing of the S/S? I'm trying to eliminate that step completely.