Text Field Properties

[LSDNo1]

How do you create a maximum on a fomula.

Expense sheet

10.00 Breakfast

10.00 Lunch

10.00 Dinner

Max calculation $25.00 

[try67]

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

[mituskisawada]

hello

[LSDNo1]

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]

[try67]

Do not reply by email! It includes your full contact details and posts them to this public forum, which is not a good idea. I will remove them from the message above for you.

[try67]

The only thing you need to adjust in the code I provided are the names of the fields inside the quotes.

[LSDNo1]

Thank you so very much.