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

How to populate information depending on the value of another field?

Contributor ,
Feb 05, 2025 Feb 05, 2025

I am working on a fillable PDF and I need to display under PERFORMANCE LEVEL the following depending on the TOTAL SCORE.

Total Score                Performance Level

100-120                      Excellent

85-99                           Doing OK

50-84                           Needs Attention

Below 50                    Urgent Action Required

Thank you in advance for any assistance extended.

TOPICS
PDF forms
204
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
1 ACCEPTED SOLUTION
Community Expert ,
Feb 05, 2025 Feb 05, 2025

Enter the following custom calculation in the Performance Level field:

var ttl=this.getField("Total Score").value;
if(ttl<50){event.value="Urgent Action Required"} else
if(ttl>49 && ttl<85){event.value="Needs Attention"} else
if(ttl>84 && ttl<100){event.value="Doing OK"} else
{event.value="Excellent"}

View solution in original post

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
Community Expert ,
Feb 05, 2025 Feb 05, 2025

Enter the following custom calculation in the Performance Level field:

var ttl=this.getField("Total Score").value;
if(ttl<50){event.value="Urgent Action Required"} else
if(ttl>49 && ttl<85){event.value="Needs Attention"} else
if(ttl>84 && ttl<100){event.value="Doing OK"} else
{event.value="Excellent"}

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
Contributor ,
Feb 06, 2025 Feb 06, 2025
LATEST

I tried this solution and it worked. Thank you so much.

 

 

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