Accessing sharepoint list value before the form loads

T

tkflick

I have 4 types of users.

Each type of user will see a slightly different version of my form.

In the OnLoad event, I get the user_name from the
System.Environment.UserName command. I then want to use that user name
to query a Sharepoint list that contains an access level associated
with that user_name. I would then use the access level to decide which
View to load. (i.e. Manager, Team Lead, etc..)

Is this even possible?

Thanks very much,
Tim
 
V

Vikas Verma

You can try to get the role of sharepoint user by using sharepoint web
services on infopath onLoad event.
 
T

tkflick

I'm sorry, could you be more specific? I'm new to Infopath/Sharepoint
and unfamiliar with the syntax and commands.

I know how to set up my secondary dataObject, but how do I pass in a
parameter, to only bring back the row of the list that contains a
user_name that matches System.Environment.UserName? And once I do
that, how to I pull the access_level value out?

I've searched and searched, but can't seem to find the answer anywhere.
I'm totally baffled here.

Thanks for the reply...
Tim
 
T

Torey

This sounds like something we are trying to do. We have a user, they
put in a last name or a login name on a form and we want it to
autopopulate the information such as their extension location etc. I am
new to infopath too.
 
Top