Adobe Forms - Simple IF Statement

Question

Hi there - forgive the complete noob question, hope you can help.

SecureDep = Security Deposit
RentPW = Rent Per Week

RentPCM = Rent Per Calendar Month (Calculated at RentPW*52/12)
ContractLength = Contract Length in months

I'm trying to populate the Balance to Pay field.

Security Deposit can either be 2 weeks or 6 weeks. The Balance to Pay will change depending on this single field.

If the Security Deposit is 2 weeks, then the Balance to Pay will be ContractLength * RentPCM

If the Security Deposit is 6 weeks, then Balance to Pay will be RentPCM+(RentPW*4)

So....unsuccessfully I have tried:

IF(SecureDep/2=RentPW, ContractLength*RentPCM, RentPCM+RentPW*4) This didn't work in Simplified Field Notation

Can someone please kindy help me with this? I don't know any Javascript and already tried 2 hours to find a solution, thank you so much!

George_Johnson · Accepted Answer

The custom calculation script could be something like this:

(function () {

// Get the input field values, as numbers

// Blank fields will equal 0 (zero)

var SecureDep = +getField("SecureDep").value;

var RentPW = +getField("RentPW").value;

var RentPCM = +getField("RentPCM").value;

var ContractLength = +getField("ContractLength").value;

// If any of the inputs are zero or less, set this field value to blank

if (SecureDep <= 0 || RentPW <= 0 || Rent PCM <= 0 || ContractLength <= 0) {

event.value = "";

} else {

// Calculate this field's value

if (SecureDep / 2 == RentPW) {

event.value = ContractLength * RentPCM;

} else {

event.value = RentPCM + 4 * RentPW;

}

})();

It will be important that the field calculation order is correct. If you don't know how to confirm that it is, you can do a search and/or post again.

Thom Parker · Answer

Here's an article on simple calculations:

Here's one on using an "if' statement in a calculation:

And here's a site on everything you want to know about PDF JavaScript calculations:

Sign up