Changes

Custom Lookup Options

9 bytes removed, 20:42, 5 July 2021
m
no edit summary
===Updating an Existing Custom Lookup===
# To update an existing custom lookup, import the updated file and be sure to type out the exact name of the lookup you want to update in the '''Lookup Name''' field. Specify the lookup key and any primary key needed. Click '''Next''' to continue.
# You will see a warning that notifies you that an existing lookup with the same name already exists. All existing records for rows with that lookup name will be deleted and re-imported with the new updated data. Click '''Next''' to continue and click '''Yes''' on the alert pop-up.
# Click '''Next''' to finish the import.
|-
||Lookup Key
||The Lookup Key is a non-unique identifier used to return all records rows with a matching Lookup Name.
|-
||Primary Key
||(Optional) The Primary Key is an optional unique key used to return a single record row that matches the Lookup Name and Primary Key value. Records Rows without a matching Primary Key will be imported as new recordsrows.
|}
Smartstaff
2,091
edits