Skip to main content
A
amandas53942597
Participant
November 14, 2017
Question

Java Script for calculation in DC

  • November 14, 2017
  • 2 replies
  • 536 views

Hi,

I have zero experience with Java script and only just figured out calculations in Livecycle before they shut down support & now our forms won't open - i've had to re-crate our forms in Adobe DC.

I need to write a calculation, I have 3 number fields (Quantity, Price, Total)

Item               Quantity                                                                 Price          Total

Battery          less that 35 batteries                                               $25             $25

Battery          more than 35 batteries, less than 69 batteries        $25             $50

Battery          more than 70 batteries, less than 104                     $25              $75

OR in other words, for every 5kg of batteries (which we worked out to be approx 35 batteries) ordered there is a $25 charge (per 5kg) added to the total. So if they order 35 batteries = 5kg = $25, if they order 40 batteries it would be $50 as we'd have to round up to 10kg.

Does anyone know how I write this in Java Script to enter into 'simplified field notification' or 'custom calculation script'

SO MUCH THANKS if anyone can help!

Amanda

edit: I'm using Adobe DC, i've got a form I made previously in livecycle that I'm converting the fields to fillable fields in Adobe DC.

This topic has been closed for replies.

2 replies

try67
Community Expert
try67Community Expert
Community Expert
November 14, 2017

As the custom calculation script of the Total field enter:

var qty = Number(this.getField("Quantity").value);
var price = Number(this.getField("Price").value);
event.value = Math.ceil(qty/35)*price;
A
amandas53942597Author
Participant
November 14, 2017

Thanks try67 - i plugged that in and changed "Quantity" to be the cell name (ie Text6.0.0) & same for Price - but it didn't work. Is there something else I needed to change - It came up as NaN in the box

try67
Community Expert
try67Community Expert
Community Expert
November 16, 2017

That means that value of one of your fields is not a pure number, but contains non-digit characters.

T
Test Screen Name
Legend
November 14, 2017

LiveCycle Designer is still sold and supported but no longer  bundled with Acrobat.

A
amandas53942597Author
Participant
November 14, 2017

we have been having issues for a long time with people being able to open our livecycle created forms in adobe - we contacted adobe and they said it's no longer supported, and advised us to use adobe DC to create forms.

Which sucks because all our forms have been created in livecycle and i can't edit them straight through adobe DC create form/edit. I need to save it as a plain pdf and then add the form sections over the top of the fields previously used

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices