Skip to main content
Bec W.
Known Participant
September 12, 2021
Question

Simplified Field Notation and Calculations Equal to and Greater then.

  • September 12, 2021
  • 2 replies
  • 608 views
Trying to implement something for the following:
Taking two form fields one being OfficeUseActualAssetsAvailable and have it equal to and not greater than the TargetAssets...
OfficeUseActualAssetsAvailable <= TargetAssets
I would Also need to set a Maxium
Which Would Be
NameOfBox = TargetAssets
Should this be working in the simplified field notation?
This topic has been closed for replies.

2 replies

ls_rbls
Community Expert
Community Expert
September 13, 2021

++Adding to the discussion,

 

As mention by Nesa this is not achieved with  Simplified Field Notation because this built-in feature is limited to only four basic mathematical operators.

 

You won't be able to establish a "less than" or "greater than" comparisson using this method in Acrobat as you would with electronic spreadsheets.

 

In the same context, even though you can employ a custom calculation script to achieve a comparisson between the values or the properties of the desired fields, this method is not exclusively necessary.

 

The easiest way to achieve this is to use the built-in "Value is the"  calculation option.

 

For example, in the "OfficeUseActualAssetsAvailable" field, select or tick the radio button "Value is the" and select from the adjacent dropdown menu "minimum". Then click on the adjacent "Pick..." button and tick the checkboxes for the fields: "OfficeUseActualAssetsAvailable" and "TargetAssets".

 

Conversely, do the same procedure in the "NameOfBox" field, but choose "maximum" from the dropdown menu, and then check the fields: "NameOfBox" and "TargetAssets".

 

This built-in feature will, in a way, establish a comparisson between the values entered in the fields.

 

For example, if a user types in a number value in the "NameOfBox" field that is less than the value of the "TargetAssets" field, it will default back to the value of the "TargetAssets" field, but it will accept a number value that is greater.

 

Nesa Nurani
Community Expert
Community Expert
September 12, 2021

No, you need to use custom calculation script.