Hi all,
Apologies for just dropping in to ask a question but I'm not a programmer by trade and my knowledge of the fundamentals clearly isn't good enough!
So I've got a table with the correct line manager for each person but the data that sits on the Exchange server is incorrect. I'm creating a list of people who need their manager updating so someone else can make the adjustments.
In a nutshell, I need to grab the unique ID in my table (listed as the Alias on the Exchange), use that to grab their incorrect line manager (if it is) and compare that to a column with the correct manager listed. If it's correct, put YES in the correct column, all is well and move to the next row. If incorrect, put NO in the correct column, list the correct manager in the adjustment column and move to the next row.
Example (excuse the lack of originality in the names):
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Unique ID
[/TD]
[TD]Name
[/TD]
[TD]Manager
[/TD]
[TD]Correct?
[/TD]
[TD]Adjustment
[/TD]
[/TR]
[TR]
[TD]r574
[/TD]
[TD]John Doe
[/TD]
[TD]Dave Man
[/TD]
[TD]YES
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]h463
[/TD]
[TD]Jane Doe
[/TD]
[TD]Frank Man
[/TD]
[TD]NO
[/TD]
[TD]Mike Man
[/TD]
[/TR]
[TR]
[TD]l923
[/TD]
[TD]Another Doe
[/TD]
[TD]Steve Man
[/TD]
[TD]YES
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Any help is super appreciated!
Apologies for just dropping in to ask a question but I'm not a programmer by trade and my knowledge of the fundamentals clearly isn't good enough!
So I've got a table with the correct line manager for each person but the data that sits on the Exchange server is incorrect. I'm creating a list of people who need their manager updating so someone else can make the adjustments.
In a nutshell, I need to grab the unique ID in my table (listed as the Alias on the Exchange), use that to grab their incorrect line manager (if it is) and compare that to a column with the correct manager listed. If it's correct, put YES in the correct column, all is well and move to the next row. If incorrect, put NO in the correct column, list the correct manager in the adjustment column and move to the next row.
Example (excuse the lack of originality in the names):
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Unique ID
[/TD]
[TD]Name
[/TD]
[TD]Manager
[/TD]
[TD]Correct?
[/TD]
[TD]Adjustment
[/TD]
[/TR]
[TR]
[TD]r574
[/TD]
[TD]John Doe
[/TD]
[TD]Dave Man
[/TD]
[TD]YES
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]h463
[/TD]
[TD]Jane Doe
[/TD]
[TD]Frank Man
[/TD]
[TD]NO
[/TD]
[TD]Mike Man
[/TD]
[/TR]
[TR]
[TD]l923
[/TD]
[TD]Another Doe
[/TD]
[TD]Steve Man
[/TD]
[TD]YES
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Any help is super appreciated!