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 / July 2005

Tip: Looking for answers? Try searching our database.

Section Properties Rules for "OR" split into separate rules and won't work!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
pathcm00 - 12 Jul 2005 15:40 GMT
Hello,

I'm having a little issue with InfoPath 2003.  I have a section that I
want to hide of either of two conditions are true.  I go into "Section
Properties" then Display then Conditional Formatting and create a rule
for if a is true OR if b is true hide this control.  I publish it to
SharePoint and it doesn't work.  When I reopen the InfoPath form and go
to the Section Properties the rule is split into two separate rules!
This of course will not work.  I have created other rules for controls
(not section properties) that work just fine.

Is this a bug with Section Properties?

THanks
Scott L. Heim [MSFT] - 12 Jul 2005 16:59 GMT
Hi,

I just completed these sample steps and it appears to work as expected -
can you let me know your results of following these steps?

- Create a new, blank InfoPath form
- Add a text box
- Add a Repeating Section
- Add a text box inside the Repeating Section
- Right-click on the Repeating Section, choose Properties and select the
Display tab
- Click Conditional Formatting and then click Add
- In the first drop-down list choose Select a field or group and select the
first text box (not in the Repeating section) - probably field1
- In the second drop-down list choose "is equal to"
- In the third drop-down list choose "Type text" and then enter: a
- Click the "And" button and then select "or"
- Repeat the above steps for each drop-down but enter: b in the third
drop-down
- Save and test...what are your results?

For me, if I enter an a or a b in the text box the Repeating Section is
hidden - any other letter and it is visible.

Thanks!

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights
pathcm00 - 14 Jul 2005 19:45 GMT
Hey Scott thanks for the post.

I think my "logic" is incorrect because the above works of course (your
way or with just a regular section as in my example).

I think what I need is really this:

If A is NOT true OR B IS true then UNHIDE the control.

The problem is the only thing available in the form is HIDE.  If there
were a 'hide this control" by default and an unhide function I think
this would work.  The way InfoPath is however, I don't really know if I
can get it to work (although maybe with scripting it can).  I want to
hide the control unless the User Role is "Approver" OR the User Role is
"Manager".  The incorrect logic I was using was:

If the User Role is not Approver OR the User Role is not Manager then
hide the control.  That statement will never be true DUH.

That's why I need:

If the UserRole is Approver OR the USer Role is Manager UNHIDE the
control.
Scott L. Heim [MSFT] - 15 Jul 2005 13:43 GMT
Hi,

OK - what about this option:

- I created a form with 3 Roles: Approver, Manager and Normal Users
- I added Conditional Formatting to the Repeating Section as follows:

User's Current Role  --> Is Equal To  --> Normal Users

Then: Hide This Control

In this manner, if I add myself to either the Approver or Manager Role the
section is displayed. However, if I add myself to the Normal Users role,
the section is hidden.

Does this help?

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights
 
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.