Forum Discussion

AndreaPahor's avatar
AndreaPahor
Qrew Cadet
6 years ago

Table to table import - override query

I am about to use a table to table import to update 22,000 records but want to check my logic first.

Table A contains the following fields:

Equipment Record ID - table key 

Equipment Record ID (NEW) - unique value

I need to update Equipment Record ID with the value in Equipment Record ID (NEW).

I propose using a table to table import from Table A to Table A and merge equipment on Record ID#

This seems to be a quick way of populating data - hopefully without unforeseen consequences?







3 Replies

Sort By
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    That should work assuming that the Equipment Record ID is not the actual Record ID (which is field ID number 3) in the table. An easy way to test is to copy your app and do the test in the Copy app.
  • AndreaPahor's avatar
    AndreaPahor
    Qrew Cadet
    6 years ago
    Just to clarify, the field I'm importing into is not the QBase generated Record ID # field (field 3).

    I'm importing into a field I created (Equipment Record ID) which is the key field for the table. 
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    It will probably work, but to copy an app takes about 3 clicks, so I suggest you test if this is a production app.