Tenant Bond Calculation

Forum|Forum|6 years ago
October 4, 2019
3 replies
267 views

Hi There,

My scenario is this:

To calculate a tenants bond you take their weekly rent, multiply it by 52 weeks in the year and divide by 12 months of the year.

I want to be able to enter the 'Weekly Rent' in one box, and in the second box calculate what the tenants bond would be using the above formula.

A

avid_Eclipse4282

Participant

You can do this with a calculation script on the second field.

Name your first field WeeklyRent and set its format to Number (Properties > Format > Number, 2 decimal places).
Open the properties of your second field, go to the Calculate tab, choose Custom calculation script, and click Edit.
Paste this:

javascript

var w = this.getField("WeeklyRent").valueAsString;
if (w == "") {
    event.value = "";
} else {
    event.value = Number(w) * 52 / 12;
}

Set that second field to Number format as well, and make it read-only so nobody types over the result.

The empty check stops it showing 0 before anything has been entered. If the result ever stops updating, check Tools > Prepare Form > More > Set Field Calculation Order and make sure the weekly rent field comes first.

One thing worth confirming for your form: weekly × 52 ÷ 12 gives the monthly rent equivalent. In most Australian states the bond itself is then a set number of weeks of rent (commonly four), so you may want a third field for that rather than labelling this one as the bond.

M

mattholton1Author

Participant

Hi There, Adobe Acrobat Pro DC