claires52602722

Inspiring

Answered

% Scripts in Acrobat pro fields

16 replies
1663 views
Translate

Hi Folks, I know nothing about scripts, but am trying to show a % in a field based on a total in 1 field minus a figure in a 2nd field = the % in the 3rd field. Anybody know if this is achievable?

Acrobat SDK and JavaScript

This topic is closed to new replies. Start a new post to keep the conversation going.

claires52602722Correct answer

Inspiring

10 out of 534 is not 5.34%... It's 1.87%.

Apologies, I get it now.

Thank you for being patient with me.

I still do not understand coding (or math it seems!) - but this script has worked. I just need to paste it into the other cells on the form and adjust the target cells.

Thank you so much for your help with this - I am most grateful.

claires52602722Author

Inspiring

Aah ok - how would I do that - as I said, this java stuff might as well be Klingon to me

I really do appreciate you help.

Translate

Community Expert

Community Expert

If I understand it correctly, it should be:

var a = Number(this.getField("DAY 17_2").value);

var b = Number(this.getField("27 32No of Chicks_2").value);

if (b==0) event.value = "";

else event.value = (a/b);

Translate

claires52602722Author

Inspiring

Ok - that seems to work well with 100 or 1000 chicks, but doesn't seem to work with an uneven number (which it may well be).

Any suggestions?

Figure should be 5.34% at the bottom?

Translate

claires52602722Author

Inspiring

Example:

My clients is sending 1000 newly hatched chicks via an airline

14 of these chicks die in transit

So I need the 3rd box to show 1.4%

Translate

Community Expert

Community Expert

This is a standard formatting option. Look on the Format tab of the field properties

Translate

Thom Parker - Software Developer at PDFScriptingUse the Acrobat JavaScript Reference early and often

claires52602722Author

Inspiring

Thank you Thom,

I have formatted the cell Percentage, what I am after is a script that will show (C) as a % of box (B) based on the total in box (A).

I actually need box (C) to show 2% in this example rather than 98%

Translate