Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / November 2006

Tip: Looking for answers? Try searching our database.

How to assign a field value to a User Role?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Deb - 10 Nov 2006 20:11 GMT
I have three user roles: Initiator, Approver, and InfoSec.   Initator fills
out the form, including a field for the manager's email address, then clicks
the Submit button which mails it to the manager who needs to fill the role of
Approver.  How do I get the value of the email address in the Manager field
to fill the role of Approver?

Thanks!
Deb - 10 Nov 2006 20:16 GMT
Actually, maybe I'm making this more complicated than it needs to be.  I have
three sections in my form that related to each Role.  The first section is
for the Initiator, which is easy.  When they click the Submit button it needs
to be sent via email to the person they indicated as the manager.  That's
also easy.  Now comes the hard part.  When that manager opens the form, I
need to be sure it's them and display the section for Approver.  The only way
I could think to do that was with an Approver role.  So, how do I know that
manager is the Approver and how do I know it's the manager that's looking at
the form?

Thanks in advance for helping me to untangle myself.

> I have three user roles: Initiator, Approver, and InfoSec.   Initator fills
> out the form, including a field for the manager's email address, then clicks
[quoted text clipped - 3 lines]
>
> Thanks!
Josh - 11 Nov 2006 05:37 GMT
Is the form sumitted within a network? Does the network use Active
Directory for user names and permissions? Does each user have a
specific logon to the computer or does everybody use the same login?

For starters, you'll need to pull in the managers login from the
computer. Then you'll want to match that with the manager field. If
that validates, then you'll allow the approver field to be shown with
conditional formatting.

You can also set a rule, that approver can not be the person who
originally submitted the form. This would eliminate the original signer
from signing the document. You also stated that its emailed to manager.
If thats all automatic, then the manager would be the only person
looking at the form anyway.

Josh

> Actually, maybe I'm making this more complicated than it needs to be.  I have
> three sections in my form that related to each Role.  The first section is
[quoted text clipped - 15 lines]
> >
> > Thanks!
Deb - 13 Nov 2006 20:21 GMT
Yes.  We're an AD environment and yes each user logs in with their own
account.  Problem here is I'm not a programmer so don't know how to code to
look for the logged in user and compare it to the manager's name the
initiator provided.

> Is the form sumitted within a network? Does the network use Active
> Directory for user names and permissions? Does each user have a
[quoted text clipped - 32 lines]
> > >
> > > Thanks!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.