These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Hide a field and make it visible when a calculation is made?

Forum Index > Forms: LiveCycle Designer > Hide a field and make it visible when a calculation is made?
2010-06-25 09:05:00
mitch54
Registered: Jun 1 2010
Posts: 30
Answered

I am VERY new to LiveCycle-this is my first attempt at using it. I have a form that I am modifying/creating. It is a time sheet that has most of the formulas done. My problem is that I have one formula that is for overtime. The formula I am using is Sum(-7.5, TotalHoursWorked) where the total hours comes from afield that is filled in by the user. My problem is that the -7.5 shows even when the hours are not filled in. Is there any way to hide that field until a calculation is made? In other words, is there any way to make that field blank until there is a positive value for it? I've also got a field that will not let me tab out of it. Any suggestions on that part??

My Product Information:
LiveCycle Designer, Windows
Top
2010-06-28 12:24:38
#1
radzmar
Expert
Registered: Nov 3 2008
Posts: 1202
Hi,

yes that can be simply done with an if-else expression:

if(TotalHoursWorked ne null and TotalHoursWorked > 7.5) thenSum(-7.5, TotalHoursWorked)else$ = nullendif

radzmar
• LoveCycle Blog
Documents you need:
• LiveCycle Designer ES2 Docs

Top
2010-06-28 12:54:15
#2
mitch54
Registered: Jun 1 2010
Posts: 30
Thanks. I actually used the MAX function. I started playing with it a little and figured it out!!
Max(Sum(-7.5,FirstWkSunTotal) ,0)
Top