Yet Another Date Related Problem !!!

Yet Another Date Related Problem !!!

@ZOHO Creator Support Team:


I have a Form with ...

1) a Date Field (Date_Of_Birth)

2) a Single Line Text field (Age_In_Years_And_Months)

3) in the on User Input section of the Date_Of_Birth field I ...

a) call a User Function to Calculate Age based on this Date

b) update the Age_In_Years_And_Months field with the result (e.g. 11 years 5 Months)


Test Cases:


1) If I change the date by editing the current value (e.g. change 1969 to 1975) ... and then immediately follow up with a click on the Submit Button ...

- I can see that the on User Input section is triggered ... and the Age_In_Years_And_Months field is updated
- but the old value shows up in the Age_In_Years_And_Months field/column of the View


2) If I change the date by editing the current value (e.g. change 1969 to 1975) ... and then click on another field ...

- I can see that the on User Input section is triggered ... and the Age_In_Years_And_Months field is updated
- after that, if I click on the Submit Button, the correct value shows up in the Age_In_Years_And_Months field/column of the View


3) If I change the date using the Date Picker Widget ... everything works as expected ... whether I immediately click the Submit Button ... or click elsewhere first.

 
When a change to the date field is made by typing it in the Box ... the results of the corresponding actions are not being saved ... looks like the contents of the Form are being saved BEFORE the results of the corresponding actions are displayed/updated on the Form.



Gaev