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

FormCalc Troubles

Avatar

Level 1

I am using LiveCycle Designer

I have a table that I need to do several things:

  • When someone make a selection from field PaymentProgram1, the fee for their selection should populate field Fee1.  Next the sum of fields Fee1, Fee2, etc. should populate the Subtotal field. 
  • The next calculation is depending on the selection from fields PaymentProgram1-4, this field will add the required deposits from each selection.
  • The final calculation is the balance due after the down payment is paid.

I created an if then statement:  If PaymentProgram1=1 then $56.00

I selected the field that I wanted to run this statement, I selected FormCalc for the language.  But it still does not work.

I also created this calculation for the Subtotal field:  Fee1 + Fee2 + Fee3 + Fee4

Can someone help me please?

Thank you

Angela

angelaagb@yahoo.com

0 Replies

Avatar

Employee

Hello,

You're in the forum for the product Adobe FormsCentral (http://formscentral.adobe.com), a service that allows you to create and distribute forms online. We can't help with questions about issues with PDF forms. I recommend taking a look at the Acrobat User Community site and reposting your question to the forum there:

www.acrobatusers.com/forum

Avatar

Employee

You can also get help in the LiveCycle Designer forums: http://forums.adobe.com/community/livecycle/livecycle_es/livecycle_designer_es

I'll move your post to that forum so you don't need to retype it. They can help you out...

Randy

Avatar

Level 7

The script should be something like:

If (PaymentProgram1 == "1") then

     $ = 56

endif

Set up your field to add the dollar sign using the "Patterns" feature in the field tab object pallet.

For the Subtotal field, you'll need to provide more info--are the fields part of a table? If so, the script will look something like:

     $ = Row1.Fee1 + Row2.Fee2 + Row3.Fee3 + Row4.Fee4

or

     $ = Sum( Row1.Fee1, Row2.Fee2, Row3.Fee3, Row4.Fee4)

If they are all siblings of the same subform this should work

     $ = Fee1 + Fee2 + Fee3 + Fee4

Good luck!

Stephen