Skip to main content
Question

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

  • April 24, 2019
  • 0 replies
  • 83 views
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 (reference)] field
  • Date Created (Build in Date/Time) field
Is there a way around this? I have over 7k entries that need to be imported so doing so by hand is not really an option.

TIA
      This topic has been closed for replies.

      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
      Terms & ConditionsAccessibility statement