I am new to zoho. i have been trying to learn about zoho since two weeks. currently i am working with zoho creator where i created an application(Employee Management). In the application i have a form where there are fields as follow:

1. serial number as an auto number field
2. Email as an Email field
3. Date as Date field
4. Is Entering or Leaving as radio field(options: Entering and Leaving)
5. Arrival time as single line field
6. Departure as single line field

while accessing the application user has to enter fields mentioned in 2 and 4 in the above list and they are mandatory fields as well where date and time are given dynamically. every thing works fine when user is entering. According to my application user has to fill the above mentioned mandatory fields while entering and leaving office. Now the problem is when user selects Leaving, I need to update the row with email entered while leaving office which is the same email provided while entering the office. how can i update the row having the email address entered while entering office?  

I have another question as well. is there any click event for submit button?? 

Hope to get my queries answered as soon as possible and sorry for the long post.

 

Regards,

Sagar Shrestha