Skip to main content
Question

Can QB scrub a list for unique identifiers before importing?

  • July 6, 2017
  • 0 replies
  • 47 views

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 based on a unique identifier from a column. Without manually doing that in the spreadsheet, is there a way to preset accepted UIs in the column prior to import?

    This topic has been closed for replies.

    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.

     
    Are you trying to import X rows where some column = ABC123 basically the same unique ID value. Or do you have a list where 2 rows have the same unique ID and you only want to import one of them? Either way I think you could do this by using the Filter option in excel. Then copy only visible cells and paste that into your quickbase import.
    Terms & ConditionsAccessibility statement