Timesheet - Validation script

Many thanks, you have been very helpful.

I have a question number 2 regarding the overtime to be assigned to different fields.

I am trying to build an overtime form to calculate the overtime hours with the layout below:

Standard weekly hours

O/T start     OT/finish     OT@1.00     OT@1.50     OT@2.00    

What we are trying to achieve is to calculate the overtime and have it assigned into the relevant OT field taking into the consideration a weekly standard hours.

Standard working week: 37.50 hours    

Employee selects the date.

if it falls down on weekday, overtime hours are calculated and displayed in OT@1.50 column

If it falls down on weekend, overtime hours are calculated and displayed in OT@2.00 column    

If standard hours are less than 37.50 hours then OT hours will be calculated and displayed in OT@1.00 until the value reaches 37.50, then the whole process above starts again.

If we could have this built, it would make life so much easier.

Look forward to hearing from you.

Let's try to simplify this problem. Say you have three drop-down fields with those values, called Dropdown1 to Dropdown3.

You can use this function as a doc-level script and then call it from the custom Validation event of each one of those fields to achieve what you've described:

function validateDropDownsTotal() {
    var maxAllowedValue = 1;
    var allFields = ["Dropdown1", "Dropdown2", "Dropdown3"];
    var total = Number(event.value);
    for (var i in allFields) {
        if (event.target.name==allFields) continue;
        total+=Number(this.getField(allFields).valueAsString);
    }
    if (total>maxAllowedValue) {
        app.alert("Error!");
        event.rc = false;
    }
}