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 / April 2007

Tip: Looking for answers? Try searching our database.

Setting a field value using a rule

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Reetu - 23 Apr 2007 19:48 GMT
Hi All,

I need to set MinimumHours field based on OfficeName field and JobTitle
field.

I need to apply the following formula:

if (OfficeName = "A" or OfficeName  ="B") And (JobTitle = "C" or JobTitle =
"D")
{
   MinimumHours = 40;
}

I did apply the above rule in the following way but it does not work
correctly.

if OfficeName  = "A" or
OfficeName = "B" And
JobTitle = "C" or
JobTitle = "D"  then MinimumHours=40

It works if oficeName =B and JobTitle =C. But if OfficeName = A it does not
work. I know there should be some way to group office condition in one
bracket and JobTitle in other bracket but I didn't see a way to do that.

Any idea how to do this?

Regards,
-Reetu
Frank Mueller (MSFT) - 26 Apr 2007 20:51 GMT
Hi Reetu,

You will have to add the rule to both OfficeName and JobTitle, as rules fire
after a node value is changed. In order to have more complex conditions you
need to set the first drop down in the condition editor to "the expression"
rather than the fieldname.

Hope this helps.
Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

> Hi All,
>
[quoted text clipped - 27 lines]
> Regards,
> -Reetu
 
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.