Forum Discussion

MichelleCoslet's avatar
MichelleCoslet
Qrew Assistant Captain
6 years ago

Import data into text (Look up) field, numeric (reference) & build in Date Created fields

I have a spreadsheet full of data that I need to import into my App. The three fields that are NOT available to import into are: Assembly ID [text (look up)] field Related Operator [Numeric (refe...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
It is not possible to update the [Date Created] field.  That is a built in system field.  But you can always create a new field to accept the one time import value for the date created and then have your own formula field to use the one time import date field if present or else the native [Date Created] field.

To get the [Related Operator] you will need to download the operator table into excel with the operator name and the Record ID# and then use a VLOOKUP (....,false) to lookup the record ID# of the operator.

same with Assembly ID
MichelleCoslet's avatar
MichelleCoslet
Qrew Assistant Captain
6 years ago
What do i do with this information though. I saved the Operators table as a spreadsheet. I see the record ID (Operator ID in my case).
Not sure on the next step.
Thank you