• Global community
• Language:
• Deutsch
• English
• Español
• Français
• Português
• 日本語コミュニティ
Dedicated community for Japanese speakers
• 한국 커뮤니티
Dedicated community for Korean speakers
• Re: Simplified Field Notation and Calculations Equ...

# Simplified Field Notation and Calculations Equal to and Greater then.

Community Beginner ,
Sep 12, 2021 Sep 12, 2021

Copied

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?
TOPICS
How to , JavaScript , PDF forms

Views

64

Likes

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
2 Replies 2
Community Expert ,
Sep 12, 2021 Sep 12, 2021

Copied

No, you need to use custom calculation script.

Likes

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Community Expert ,
Sep 12, 2021 Sep 12, 2021

Copied

LATEST

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.

Likes

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Resources