Forum Discussion
SharePoint List - Concatenate multiple rows
Hi bryanfrumkin47,
Does the Agent to Region mapping change frequently, or very rarely. I assume the regions might be assigned based on their base location and nearby regions so it might not change frequently.
If the region assignment keeps on changing; then should this column display latest regions assigned or the one which was mapped when the particular lead was assigned?
I believe the proposed solution of adding a separate list with 2 columns should work fine.
Suggest keeping the existing Agent column as is for now, add a new list with 2 columns (Agent, Regions) and then link these columns to the Lead List.
Once this is done, map the agents in the new columns as per the lead assignment.
Once you are confident with this and no issues from users, then you can hide/remove the current agent column.
-Nimesh
Hello nimesht,
"Does the Agent to Region mapping change frequently, or very rarely. I assume the regions might be assigned based on their base location and nearby regions so it might not change frequently.
If the region assignment keeps on changing; then should this column display latest regions assigned or the one which was mapped when the particular lead was assigned?"
Once the excel sheet data is uploaded, the leads' region will not change, so "one which was mapped when the particular lead was assigned"