Configuring Advanced Lookup

<< Click to Display Table of Contents >>

Navigation:  Legacy Tools > Advanced Lookup >

Configuring Advanced Lookup

Open Advanced Lookup Column App and click on ‘Configure Column’ to set up a new lookup.

clip0181

 

Choose the list having the Lookup column that you want to configure as an Advanced Lookup column. Select that Lookup column.

clip0182

General Settings

Enable search: when checked, a search icon will be visible next to Lookup dropdown on the item.

Enable new entry: when checked, allows new entries to be created from the item.

Column Mappings

Enable column mapping: when checked, allows columns to be mapped from the lookup item to the current item

clip0184

Add Column Mappings:

clip0185

 

Overwrite existing column values:

Check this option to overwrite values in columns with the values from lookup list item even if there is already a value entered in those columns

clip0478

 

Reverting to Regular Lookup Column

Revert existing Advanced Lookup Column to normal Lookup Column as shown below

clip0188

Choose ‘OK’ to Revert Advanced Lookup Column back to normal Lookup Column

clip0189

 

Update configured columns

Edit existing Advanced Lookup Columns as shown below

clip0190

In Edit Mode, List and Lookup column cannot be changed -- only General Settings and Column Mappings can be modified.
Note: To modify ‘List’ and ‘Lookup’ column revert Advanced Lookup column back to Normal Lookup column and configure a new Advanced Lookup Column

clip0191