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

Auto colour change?

Aug 17, 2012 3:24 AM

Categories: Macintosh Tags: #auto #change #colour #form #100% #total #calculated

I would like to know how to make a calculated total automatically change colour when it hits 100%

674 Views   9 Replies   Latest reply: Fi_TW, Aug 17, 2012 11:18 AM
 
Replies
  • manjeete
    Currently Being Moderated
    1. manjeete,
    Aug 17, 2012 3:42 AM   in reply to Fi_TW
    Report

    Hi

     

    You should describe your question. What is 100% here? And color for what? TextField Color or Border Color, onfocus color what?

     

    Regards,

    Manjeet

     
    |
    Mark as:
  • Fi_TW
    Currently Being Moderated
    2. Fi_TW,
    Aug 17, 2012 4:08 AM   in reply to manjeete
    Report

    Hi, sorry for not being clear.

     

    I have a form with a set of 8 text fields, the last of which calculates the sum of the previous 7 fields. I would like the colour of the text to change on the calculated field when the sum = 100

     
    |
    Mark as:
  • manjeete
    Currently Being Moderated
    3. manjeete,
    Aug 17, 2012 4:26 AM   in reply to Fi_TW
    Report

    Hi,

     

    You want to change the text(textfield values). You have designed your form in LiveCycle Designer. Right.

     

    So, go to the last TextField and select it. Then go to the script section chose calculate event and also chose FormCalc as scripting language not the javascript. Write the below code

     

    if (this.rawValue ==100) then

    TextField1.ui.textEdit.border.fill.color.value = "86,155,189";

    endif

     

    Regards,

    Manjeet

     
    |
    Mark as:
  • Fi_TW
    Currently Being Moderated
    4. Fi_TW,
    Aug 17, 2012 4:31 AM   in reply to manjeete
    Report

    Thanks for the reply, Ive not used LiveCyle however, I designed the form in InDesign and then exported it to Acrobat where I have created the form fields.

     

    I have a custom calculation script field... I will try adding it there

     
    |
    Mark as:
  • Fi_TW
    Currently Being Moderated
    5. Fi_TW,
    Aug 17, 2012 4:40 AM   in reply to Fi_TW
    Report

    If I choose this option then I loose my 'sum' calculation...

     
    |
    Mark as:
  • George Johnson
    9,208 posts
    Aug 11, 2002
    Currently Being Moderated
    6. George Johnson,
    Aug 17, 2012 10:39 AM   in reply to Fi_TW
    Report

    You do not need to use LiveCycle Designer. You can do something like the following as the custom Calculate script:

     

    (function () {

     

        // Add up all of the field values

        var sum = +getField("text1").value;

        sum += +getField("text2").value;

        sum += +getField("text3").value;

        sum += +getField("text4").value;

        sum += +getField("text5").value;

        sum += +getField("text6").value;

        sum += +getField("text7").value;

        sum += +getField("text8").value;

     

        // Set this field value

        event.value = sum;

     

        // Set this field's text color

        event.target.textColor = sum == 100 ? color.red : color.black;

     

    })();

     

    Change the field names and colors to suit your needs. You probably want to explicitly round the sum to avoid things like: 0.2 + 0.1 = 0.30000000000000004, which will throw off the check for equivalence to 100 if non-integers are used for the inputs.

     

    Edit: corrected typo

     
    |
    Mark as:
  • Fi_TW
    Currently Being Moderated
    7. Fi_TW,
    Aug 17, 2012 10:55 AM   in reply to George Johnson
    Report

    Hi George,

     

    Thanks, this looks like just what I need... can you explain where I put it in Acrobat, you have a novice here : ).

     

    I changed the field names and dropped it into the 'Calculate', 'custom calculation script' box but I see thats not quite right.

     

    Should everywhere you put a // go into a different area?

     

    Thanks for your help

     
    |
    Mark as:
  • George Johnson
    9,208 posts
    Aug 11, 2002
    Currently Being Moderated
    8. George Johnson,
    Aug 17, 2012 10:58 AM   in reply to Fi_TW
    Report

    It is intended to be the custom calculate script for the field. I did have to correct a typo after my initial post, so try again. You can remove the comments if you like. They are the lines that begin with //.

     
    |
    Mark as:
  • Fi_TW
    Currently Being Moderated
    9. Fi_TW,
    Aug 17, 2012 11:18 AM   in reply to Fi_TW
    Report

    Woo hooo!!  It worked

     

    Thanks SO much

     
    |
    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