Fields That Can Be Specified for "Field Mappings"

Article Number:040546

In the "Field Mappings" setting of the Lookup field, the following fields can be specified for both the Source Field and the Destination Field:

Destination Field Source Field
Text
  • Text
  • Lookup
    \* Only when the Text field is specified for "Key Field"
  • Radio Button
  • Drop-down
Number
  • Number
  • Calculated
  • Lookup
    \* Only when the number field or the record number field is specified for "Key Field"
  • Record number
Text area
  • Text
  • Text area
  • Lookup
    \* Only when the Text field is specified for "Key Field"
Rich text
  • Text
  • Text area
  • Rich text
  • Lookup
    \* Only when the Text field is specified for "Key Field"
Radio Button Radio Button
Check box Check box
Multi-choice Multi-choice
Drop-down Drop-down
Link Link
\* Only when the type of the entered value is the same
Date Date
Time Time
Date and time
  • Date and time
  • Created datetime
  • Updated datetime
User selection
  • User selection
  • Created by
  • Updated by
Department selection Department selection
Group selection Group selection