Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Validation Script On Calculated Field

New Here ,
Aug 14, 2018 Aug 14, 2018

I have a field that totals a series of fields.  If the total plus another value of another field exceeds value of a third field than an alert message should be generated and the value be returned to 0.  The filed returns a false value whether the validation criteria is met or not.  Any assistance would be greatly appreciated!!!

var IDC0=Number(this.getField("IDC0").value);

var TA=Number(this.getField("TotalAward").value);

if(((Number(event.value)+IDC0.valueAsString)>TA.valueAsString));{

 
app.alert("Total of Direct and Indirect Costs Cannot Exceed the
Total Award");

   event.rc=false;

}

TOPICS
Acrobat SDK and JavaScript , Windows
687
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Community Expert , Aug 14, 2018 Aug 14, 2018

This line is a total mess:

if(((Number(event.value)+IDC0.valueAsString)>TA.valueAsString));{

Change it to:

if ((Number(event.value)+IDC0)>TA) {

Translate
Community Expert ,
Aug 14, 2018 Aug 14, 2018

This line is a total mess:

if(((Number(event.value)+IDC0.valueAsString)>TA.valueAsString));{

Change it to:

if ((Number(event.value)+IDC0)>TA) {

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Aug 16, 2018 Aug 16, 2018
LATEST

I'm a dumbass  

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