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.

"IF" calculations in InfoPath

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Paul - 12 Apr 2007 16:17 GMT
Hello,

Thanks for reading me.
I am trying to create a 'IF' style command in InfoPath that returns X
or Y depending on the results of a drop down box on the form. So if
they choose A in the list, X is returned in a textbox.

I tried an excel equation but get this message: 'IF' is not a valid
XSLT or XPath function.
I can't seem to find an equvilant function. Any help would be most
appreicated.

The actual equation I was entering was: IF(datapoint="None","Design
Review Not Required","Design Review Required")
Hoping that if None was selected from the drop down box 'datapoint'
then a textbox would display "Design Review Not Required, and in all
other instances it would report "Design Review Required.

Many thanks,

~ Paul
Greg Collins [InfoPath MVP] - 12 Apr 2007 17:12 GMT
Excel functions are not supported. You need to use XPath functions. However, you can do this very easily in the following manner:

Use two Expression Boxes--one for each message. Then add conditional formatting onto each of them such that:
   If datapoiont="None" hide "Design Review Required" expression box
   If datapoint != "None" hide "Design Review Not Required" expression box

Signature

Greg Collins [Microsoft MVP]
Visit Braintrove ( http://www.braintrove.com )
Visit InfoPathDev ( http://www.InfoPathDev.com )

Paul - 13 Apr 2007 09:55 GMT
Hi Greg,

That's great, thank you. With a bit of jiggery-pokery I got it to
work.

Thank you very much indeed for your kind assistance.

~ Paul
Greg Collins [InfoPath MVP] - 13 Apr 2007 20:54 GMT
Hi Paul--glad you got it working!

Signature

Greg Collins [Microsoft MVP]
Visit Braintrove ( http://www.braintrove.com )
Visit InfoPathDev ( http://www.InfoPathDev.com )

 
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.