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 2006

Tip: Looking for answers? Try searching our database.

Entering Formulas into an expression box

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Katie Pargola - 26 Jun 2006 13:41 GMT
I need to have the expression boxes print something after the prior field is
filled in. I am creating a work book for my husband's diet but based on his
weight loss his points will change. So I am trying to figure out how to make
the expression box type out the necessary points for the week. Below is what
I am trying to write but since I am not familiar with the Infopath formulas i
cant figure out how to write it. I can do it in excel but this is o bviously
not the same.

If weight is greater than or equal to 250, points =28-35; if weight is
between 225 and 249, points = 26-33, if weight is between 200-224, points =
24-3.

I also need to have his weight loss calculated so that would be start weight
- current weight but how do i write that in the expression box?

If someone knows how to write it or can write it for me that would be great.

Thanks
Kalyan Reddy - 04 Jul 2006 13:17 GMT
Hello Katie Pargola,

You can do so by using Rules on the text box to show values in the
expression boxes when the value in the text box changes
Insert a text box, Open properties and click on Rules
Insert 3 rules on this text box
The formulas are  
Rule 1 Condition is . >= 250  action is set Value in expression box
Rule 2 Condition is  . <= 249 or . >= 225 action is set Value in expression
box
Rule 3 Condition is . >= 200 or . <= 224 action is set Value in expression
box

And for calculating weight  Use this formula on the text box
((field3)) - ((field4)) where field 3 is Start weight and field 4 is Current
weight

I hope these will help You.

Signature

Kalyan Reddy
Visit http://www.autonomysystems.com

> I need to have the expression boxes print something after the prior field is
> filled in. I am creating a work book for my husband's diet but based on his
[quoted text clipped - 14 lines]
>
> Thanks
Katie Pargola - 04 Jul 2006 17:23 GMT
I am still having trouble after I put in the rules & conditions - it doesn't
display anything once a number is entered.

> Hello Katie Pargola,
>
[quoted text clipped - 33 lines]
> >
> > Thanks
Kalyan Reddy - 05 Jul 2006 11:00 GMT
Hello,

I did this and it worked for me. If you can send ur mail Id I can send u the
template.xsn

Signature

Kalyan Reddy
Visit http://www.autonomysystems.com

> I am still having trouble after I put in the rules & conditions - it doesn't
> display anything once a number is entered.
[quoted text clipped - 36 lines]
> > >
> > > Thanks
Katie Pargola - 05 Jul 2006 14:51 GMT
katie@pargola.net

thanks

> Hello,
>
[quoted text clipped - 41 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.