Working with fields in an inserted table.
In each row I have a couple of fields the user enters. These fields have a Validation Pattern enabled as the user must enter data correctly.
Then there is a field that is calculated based on the data entered by the users. It is this field that throws a warning dialog box "The value you entered for Total_Row1 is invalid. To ignore validations for Total_Row1, click Ignore".
Even if I disable the Validation Pattern on the fields used for the calculation the warning dialog still pops up. So it seems to be isolated to the calculation field.
The calculation field displays Time and I had it originally set as a Date/Time field, but also tried using a Text fields (as the calculation should appear as 0:45 for 45mins in that field).
I have a suspicion the warning only appears because I used a Table to format the fields, as I've used similar validation patterns and calculation fields in other forms and don't see the message when fields don't appear inside table.
I'm thinking the easiest work-around would be to disable the validation for that particular calculation field, but I have no idea how to script that. Any help heaps appreciated.