Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Sum Column Script

Avatar

Level 2

This is not working; THANK YOU to anyone kind enough to point out what's missing.

----------------------------------------------------------------------------------------------------------------------------------------

   <field h="5.293mm" name="IncomeTotal" w="19.134mm" x="54.478mm" y="126.775mm">

            <ui>

               <textEdit>

                  <border hand="right" presence="hidden">

                     <?templateDesigner StyleID aped0?></border>

                  <margin/>

               </textEdit>

            </ui>

            <font size="11pt" typeface="Myriad Pro"/>

            <para vAlign="middle"/>

            <traversal>

               <traverse ref="TextField4[3]"/>

            </traversal>

           <sum(IncomeTotal [Income1, Income2, Income3, Income4, Income5, Income6, Income7, Income8, Income9])>

         </field>

1 Reply

Avatar

Level 10

Hi,

First of all I would not recommend inputting script directly in the XML Source. If you go to the Design View you can open the Script Editor (5) from the Windows menu. I would recommend making it larger, so that you can see a few lines of script:

LC Designer Workspace.png

You can see an example here for referencing objects in both JavaScript and FormCalc. This also includes an example for summing columns: http://assure.ly/kUP02y.

Niall