Apr 08, 2023 12:57 PM
I want to map specific job roles to job categories. "Open Roles" in Table 1 has the specific roles, and Table 2 has the mapping between the categories and the roles. If "Open Roles" has a matching option in "Old Role", then I want to add the "New Role" value to the "Open Role Categories" field in Table 1.
Worth noting that "Open Roles" can have multiple options and may need multiple mappings.
Solved! Go to Solution.
Apr 10, 2023 01:57 AM
Seems like you could get this done with a linked field
1. In Table 2, make your primary field contain the "Old Role" values
2. In Table 1, convert that multiple select field into a linked field to Table 2
3. In Table 1, create a lookup field to display the "New Role" value from the linked field from step 2
This should do what you're looking for I believe
Apr 10, 2023 01:57 AM
Seems like you could get this done with a linked field
1. In Table 2, make your primary field contain the "Old Role" values
2. In Table 1, convert that multiple select field into a linked field to Table 2
3. In Table 1, create a lookup field to display the "New Role" value from the linked field from step 2
This should do what you're looking for I believe
Apr 10, 2023 08:51 AM
That worked thanks! Did you have to convert the table type back and forth after doing this or else the Linked Record showed the same multiple-select option more than once. But this did the job! Thanks.