Hi,
I know very little about JavaScript, and am on a fast learning curve.
I converted an Excel Form (2003) to an Adobe Form (Adobe x Pro).
I have completed the simple JavaScript additions with the: Text Field Properties, Calculate.
After seemingly endless hours on the internet, and going through books, I cannot find a definitive answer to my problem.
To convert (2) Excel calculation/formula into JavaScript
Number 1
=IF(D14>0,D14/D13,0%)
and Function: IF (logical_test, [value_if_true], [value_ if_false])
Number 2
=(C13*80%)-C14
With the above JavaScript equivalents, I would be able to complete other calculations.
I would appreciate any help with this.
Convertiing Excel Formula to Adobe Java Script (Help)
2011-11-13 21:00:10
My Product Information:
Acrobat Pro 10.1, Windows
Acrobat Pro 10.1, Windows
2011-11-13 21:51:42
#2
Hi George,
Completed on Acrobat X Pro (not Live Cycle Designer)
Completed on Acrobat X Pro (not Live Cycle Designer)
2011-11-14 02:09:10
#3
To learn more about JS core functionalities and syntax: http://w3schools.com/js/default.asp
Specific Acrobat JS reference: http://www.adobe.com/devnet/acrobat/javascript.php
There are also many good tutorials about this subject on this website.
Number 1 (set the field as a percentage field):
Number 2:
Specific Acrobat JS reference: http://www.adobe.com/devnet/acrobat/javascript.php
There are also many good tutorials about this subject on this website.
Number 1 (set the field as a percentage field):
2011-11-14 02:45:33
#4
Dear try67,
This is a terrific outcome , thank you for taking the time and effort to resolve my issue.
I will log onto the websites you suggested to further my learning curve. And jump onto your scripts website as well.
Regarding my Form: I have many similar calculations to complete. I will tackle the job late tomorrow, and update you how it went.
Again thanks.
This is a terrific outcome , thank you for taking the time and effort to resolve my issue.
I will log onto the websites you suggested to further my learning curve. And jump onto your scripts website as well.
Regarding my Form: I have many similar calculations to complete. I will tackle the job late tomorrow, and update you how it went.
Again thanks.
2011-11-14 02:49:00
#5
Notice that the field names I've used are the names of the cells you've used in your Excel spreadsheet. If the names of your form fields in the PDF are different, then you should adjust that, or the script won't work.
Good luck!
Good luck!
2011-11-14 02:54:05
#6
Another thing to be aware of: unlike in Excel, in Acrobat the calculation order is not determined automatically. So if you have many calculated fields (and I'm assuming some of them use the values of other calculated fields), then you need to make sure the calculation order is correct. To do so go into Form Edit mode > Other Tasks > Edit Fields > Set Field Calculation Order...
2011-11-14 02:59:31
#7
Noted. When I set up the Form perimeters I ensured that the Excel spreadsheet Capitals and Numbers lined up.
When the additional calculations are completed, I understand that the Capitals and Numbers must coincide with the change of cell.
With the 2nd calculations they are in sets of 3 and the products also change.
I will take care.
Again thanks.
When the additional calculations are completed, I understand that the Capitals and Numbers must coincide with the change of cell.
With the 2nd calculations they are in sets of 3 and the products also change.
I will take care.
Again thanks.
2011-11-16 12:42:50
#8
To Forum,
Thanks Try6767. I followed your guide and (finally) have completed the JavaScript.
Much appreciated.
Thanks Try6767. I followed your guide and (finally) have completed the JavaScript.
Much appreciated.
Was your form created using LiveCycle Designer (XML) or Acrobat. Each program uses a different language and syntax.
LiveCycle Designer has a Scripting Reference under the Help menu.
George Kaiser