5 Replies Latest reply on Jun 23, 2016 10:49 AM by kkalach

    script

    kkalach

      Good Morning,

       

      I have a script right now that fills in a box

       

      If ( actual age > 69 ; 1 ; 0 )

       

      so I would like a check put in a box.  I currently have the box filling in.

        • 1. Re: script
          Mike_Mitchell

          Well, I don't know what you mean by "filling in", but you can easily use a checkmark

           

          1) Create a value list that has "1" as its only value.

          2) Display the field using a checkbox set and choose "Check" as the icon:

           

          inspector.png

           

          HTH

           

          Mike

          • 2. Re: script
            coherentkris

            My script / calculation / custom function doesnt do stuff but i want it to do stuff... can you help?

            • 3. Re: script
              dtcgnet

              You don't need a script for that.

               

              Create a new field: IsOver69. Set it up as a Calculation field and enter your formula in the calculation area. Whenever an actual age is over 69, then the field will have a value of 1.

               

              Set up things the way Mike_Mitchell outlined. Then you'll automatically get a check mark in the box whenever someone is over 69.

              • 4. Re: script
                siplus

                If you don't need to do finds on the 69 condition and a visual clue is enough, you can simply use conditional formatting to turn the person's name to grey instead of black if age > 69.

                 

                The information will reach the user faster than having to eyeball the 69 situation.

                 

                No pun intended.

                • 5. Re: script
                  kkalach

                  I got the check mark to work!  thanks all for your help!

                   

                  Karen Kalach

                   

                  Assistant to Bill Mann

                   

                  LPL Financial

                   

                  203-271-3192

                   

                  www.thefinancialarchitect.net<http://www.thefinancialarchitect.net>