Dynamic Data, Auto-Populate Function

March 24, 2009

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: