Text Field Properties

Forum|Forum|6 years ago
April 2, 2020
1 답변
1584 조회

How do you create a maximum on a fomula.

Expense sheet

10.00 Breakfast

10.00 Lunch

10.00 Dinner

Max calculation $25.00

Acrobat SDK and JavaScript

이 주제는 답변이 닫혔습니다.

try67

Community Expert

You need to use a script for that.

Assuming you're adding up those three fields you can use something like this as the custom calculation script of your field:

var total = Number(this.getField("Breakfast").valueAsString) + Number(this.getField("Lunch").valueAsString) + Number(this.getField("Dinner").valueAsString);

event.value = Math.min(25, total);

A

Anonymous

hello

L

LSDNo1작성자

Participant

Sorry, I was off for the day. This is all so new to me and yes that is what I want to do, so I tried this and I must have something wrong.

My fields are Bday1, LDay1 and DDay1

and the total field is TotalDay1

So this is what I have however it is not working.

var total = Number(Bday1("Breakfast").valueAsString) + Number(LDay1("Lunch").valueAsString) + Number(DDay1("Dinner").valueAsString);

event.value = Math.min(25, total);

Thank you so much for your help.
[Private info removed]

가입하기

소셜 로그인

커뮤니티에 로그인

소셜 로그인

파일을 바이러스 검사 중입니다.

이 파일은 다운로드할 수 없습니다