Skip to main content
L
LSDNo1
Participant
April 2, 2020
Question

Text Field Properties

  • April 2, 2020
  • 1 reply
  • 1580 views

How do you create a maximum on a fomula.

Expense sheet

10.00 Breakfast

10.00 Lunch

10.00 Dinner

Max calculation $25.00 

This topic has been closed for replies.

1 reply

try67
Community Expert
try67Community Expert
Community Expert
April 3, 2020

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);

M
mituskisawada
Participant
April 3, 2020

hello

 

L
LSDNo1Author
Participant
April 3, 2020

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]

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices