Discussions

Expand all | Collapse all

Autopopulate Key Field on Import

  • 1.  Autopopulate Key Field on Import

    Posted 6 days ago
    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
    ------------------------------


  • 2.  RE: Autopopulate Key Field on Import

    Posted 5 days 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
    ------------------------------