Skip to main content
Question

Autopopulate Key Field on Import

  • November 5, 2019
  • 0 replies
  • 41 views
Forum|alt.badge.img+4
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
------------------------------
This topic has been closed for replies.

  • BabiPanjikar
  • Registered
  • November 6, 2019
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
------------------------------
Terms & ConditionsAccessibility statement