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

I need to calculate a field based on calculated field of Age (based on birthdate)

Community Beginner ,
Feb 10, 2023 Feb 10, 2023

Copy link to clipboard

Copied

I'm very new to Java and not sure how to go about creating this calculated field.  I think I need to use an array but not sure.  

 

Ultimately, I need this field to get the age from "CalculatedAge", look in a table, pull the rate needed and put into the formula:  event.value=((((this.getField("EEVLife").value/1000)*Rate)*12)/26)

 

Any suggestions?

TOPICS
How to , JavaScript , PDF forms

Views

653

Translate

Translate

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 guidelines

correct answers 1 Correct answer

Community Expert , Feb 10, 2023 Feb 10, 2023

You can do it like this:

 

var age = Number(this.getField("CalculatedAge").valueAsString);
var rate = 0;
if (age<10) rate = 0.2;
else if (age<=25) rate = 0.25;
else if (age<=35) rate = 0.5; // etc.

event.value=((((this.getField("EEVLife").value/1000)*rate)*12)/26)

Votes

Translate

Translate
Community Expert ,
Feb 10, 2023 Feb 10, 2023

Copy link to clipboard

Copied

You can do it like this:

 

var age = Number(this.getField("CalculatedAge").valueAsString);
var rate = 0;
if (age<10) rate = 0.2;
else if (age<=25) rate = 0.25;
else if (age<=35) rate = 0.5; // etc.

event.value=((((this.getField("EEVLife").value/1000)*rate)*12)/26)

Votes

Translate

Translate

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 guidelines
Community Beginner ,
Feb 10, 2023 Feb 10, 2023

Copy link to clipboard

Copied

Thank you, going to try that now!!!!

Votes

Translate

Translate

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 guidelines
Community Beginner ,
Feb 10, 2023 Feb 10, 2023

Copy link to clipboard

Copied

this is what I tried and getting a syntax error:

 

Nancy283408177mic_0-1676050860714.png

What did I do wrong?

Votes

Translate

Translate

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 guidelines
Community Expert ,
Feb 10, 2023 Feb 10, 2023

Copy link to clipboard

Copied

Use " at begin and end of field name.

Votes

Translate

Translate

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 guidelines
Community Beginner ,
Feb 10, 2023 Feb 10, 2023

Copy link to clipboard

Copied

Thank you, I see that now.  YOu are awesome!  

Votes

Translate

Translate

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 guidelines
Community Beginner ,
Feb 10, 2023 Feb 10, 2023

Copy link to clipboard

Copied

LATEST

Worked like a charm!   Thanks again.

Votes

Translate

Translate

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 guidelines