A scenario I want to demonstrate to our internal user group is how we can build an application that will record Annual Individual Success Plan goals for each employee and Manager to have touch-base meetings to review their progress for the year. As a way to make it easy for data entry into a form, I want to remove extra work by the user(s) to entry their Windows AD Attributes, by making calculated fields that will query this data based on the ‘User :’ field.

For example, I would like to create (3) new calculated fields for this list called [Department], [Job Title], [E-Mail]. I want to make a calculated statement for each field to retrieve the respective data from Windows AD based on the ‘User :’ field.

So for ‘Department’. . . I want to select [Department] from WinAD where [User :] LIKE ‘xyz’
And ‘Job Title’ . . . select [Job Title] from WinAD where [User :] LIKE ‘xyz’
then ‘E-Mail’ . . . select [E-mail] from WinAD where[User :] LIKE ‘xyz’

Ideally if the [User :] changes to ‘123’ the [Department], [Job Title], and [E-Mail] fields will update with new content.

If this approach isn’t possible, is there a way to recommend Auto-Populating another List Called [User List] updating on a daily/hourly basis from WinAD and referencing calculated fields to that?

Thanks – J. Wright

Advertisements