Copy link to clipboard
Copied
Hi,
I need my fillable form to automatically divide two sub-totals. What is the javascript code that I need to place in the last line to get these two subtotals (Cash Availability/CashNeedsFor30Days) to divide? Thank you in advance!
Use this code as the custom calculation script:
var v1 = Number(this.getField("Cash Availability").valueAsString);
var v2 = Number(this.getField("Cash Needs for 30 Days").valueAsString);
if (v2==0) event.value = "";
else event.value = v1/v2;
Copy link to clipboard
Copied
Divide by what? 2? What's the name of the field that contains the sub-total you want to divide?
Copy link to clipboard
Copied
Field Name "Cash Availability" divided by "Cash Needs for 30 Days".
Copy link to clipboard
Copied
Use this code as the custom calculation script:
var v1 = Number(this.getField("Cash Availability").valueAsString);
var v2 = Number(this.getField("Cash Needs for 30 Days").valueAsString);
if (v2==0) event.value = "";
else event.value = v1/v2;
Copy link to clipboard
Copied
Thank you so very much!!! You saved me!
Copy link to clipboard
Copied
Write this in "Simplified Field Notation": Cash\ Availability/CashNeedsFor30Days
Copy link to clipboard
Copied
Unfortunately, this one wouldn't work for me. I don't understand why, but it wouldn't divide the fields. The above custom calculation script did the trick though. Thank you for reaching out - greatly appreciated!!
Copy link to clipboard
Copied
Thats because I thought your field name is "CashNeedsFor30Days" but it's "Cash Needs for 30 Days"
the code should be: Cash\ Availability/Cash\ Needs\ for\ 30\ Days
It's better not to use spaces in field names if using SFN.