Skip navigation
sm38240
sm38240 Calculating status...
Currently Being Moderated

Changing presence based on value of another calculated field

Apr 6, 2012 8:02 PM

Hi,

 

I am trying to hide a signature field if the value of another calculated field is less than a certain value.  I am attempting to use:

 

 

if (TotalRelUpper.rawValue<150) then

signature.presence="invisible"

endif

 

If I put this formcalc statement in the click section of the calculated field, the signature field presence will change state, but I want it to automatically change state based on the calculated value.

 

Ideas appreciated.

 

Thanks!

843 Views   7 Replies   Latest reply: BR001, Apr 10, 2012 8:43 PM
 
Replies
  • Srini Dhulipalla
    Currently Being Moderated
    1. Srini Dhulipalla,
    Apr 8, 2012 9:08 AM   in reply to sm38240
    Report

    Did you try placing the code in the Calculate event of the field?

     

    Thanks

    Srini

     
    |
    Mark as:
  • sm38240
    Currently Being Moderated
    2. sm38240,
    Apr 10, 2012 6:02 AM   in reply to Srini Dhulipalla
    Report

    Srini,

     

    Thanks for the info.  When I place the following code in the calculate section, the calculation does not work.  The signature field is invisible and no value will make it visible.

     

    Thanks,

     

    Stan

     

     

     

    form1.#subform[0].TotalRelUpper::calculate - (FormCalc, client)

     

     

    TotalRelUpper.rawValue=UpperNFC.rawValue+UpperExp.rawValue

     

    if (TotalRelUpper.rawValue<150) then

    VPsignature.presence="invisible"

    endif

     

     

     
    |
    Mark as:
  • Srini Dhulipalla
    Currently Being Moderated
    3. Srini Dhulipalla,
    Apr 10, 2012 7:59 AM   in reply to sm38240
    Report

    Stan,

         You are missing the else part in the code..

      

    TotalRelUpper.rawValue=UpperNFC.rawValue+UpperExp.rawValue

     

    if (TotalRelUpper.rawValue<150) then

         VPsignature.presence="invisible" 

    else    

         VPsignature.presence="visible"

    endif

     

    Thanks

    Srini

     
    |
    Mark as:
  • sm38240
    Currently Being Moderated
    4. sm38240,
    Apr 10, 2012 3:30 PM   in reply to Srini Dhulipalla
    Report

    Srini,

     

    Even with the else statement, the code does not work in the calculate section.

     

    form1.#subform[0].TotalRelUpper::calculate - (FormCalc, client)

     

    TotalRelUpper.rawValue=UpperNFC.rawValue+UpperExp.rawValue

     

    if  (TotalRelUpper.rawValue>150)then

        VPsignature.presence="visible"

    else

        VPsignature.presence="invisible"   

    endif

     

    The calculated field is read only and is the sum of two other fields filled in by the user.  I want to have a signature field appear or disappear based on the value in the calculated field.

     

    Thanks,

     

    Stan

     
    |
    Mark as:
  • whyisthisme
    Currently Being Moderated
    5. whyisthisme,
    Apr 10, 2012 3:50 PM   in reply to sm38240
    Report

    try putting it in the layoutReady event

     
    |
    Mark as:
  • sm38240
    Currently Being Moderated
    6. sm38240,
    Apr 10, 2012 6:15 PM   in reply to whyisthisme
    Report

    Thanks for the suggestion.  I tried placing the code in several of the layoutready events, to no avail.  There has to be a simple solution, but as a novice in form building, it eludes me.  Other inputs are welcome.

     

    Thanks

     
    |
    Mark as:
  • BR001
    Currently Being Moderated
    7. BR001,
    Apr 10, 2012 8:43 PM   in reply to sm38240
    Report

    Hi Stan,

     

    You just need to make sure the last expression evaluated to the calculate event it the one you want in the result, so you can do;

     

    TotalRelUpper.rawValue=UpperNFC.rawValue+UpperExp.rawValue

    if  (TotalRelUpper.rawValue>150)then

        VPsignature.presence="visible"

    else

        VPsignature.presence="invisible"   

    endif

    TotalRelUpper.rawValue

     

    The last line can set there like that, or you could do;

     

    var total=UpperNFC.rawValue+UpperExp.rawValue

    if  (total>150)then

        VPsignature.presence="visible"

    else

        VPsignature.presence="invisible"   

    endif

    TotalRelUpper.rawValue=total

     

    Regards

     

    Bruce

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points