Forum Discussion

JessicaFeauto's avatar
JessicaFeauto
Qrew Member
6 years ago

Autopopulate Key Field on Import

We have a numeric key field for a table.  Every new record is just incremented to the next number (like a record ID), however, we were transferring from another system and wanted to keep the IDs in place.  
I have a Form rule that populates the key field when records are created manually.

However, when we are trying import records, it requires us to fill in the key field (which requires manipulation in Excel).  Any way to automatically do this on the import?

------------------------------
Jessica Feauto
------------------------------
Data import and export
  • BabiPanjikar's avatar
    BabiPanjikar
    Qrew Assistant Captain
    6 years ago
    Quickbase does not have functionality to set sequence number generation properties in fields like built-in record id.  What you are doing in excel is better option if that is not a pain. 

    If you are using any data integration tools like SSIS, you could easily do this to generate those numbers and create the requirement results (excel transform to excel) and then load into quickbase.

    ------------------------------
    Babi Panjikar
    ------------------------------