Employee list
Hello, I have a multi-select text field with employee name choices that is going to be archived and no longer used. In that fields place I will be adding fields that relate back to a connected em...
Forum Discussion
I use the VLookUP for migrating large data sets. If it is just a few hundred records or so, this is faster:
Make a custom report with two columns
The Multiple choice text field: The New Text field from the relationship.
Set a filter to only show records where Related Employee = BLANK
Sort the report using the Multiple choice text field. This puts all the record in order by the employee name.
Grid edit the report to fill in the new values in your second column. Use the Fill Down feature to quickly fill in the values for the identical records. When you click Save, the updated records will drop off the report.