I am creating a leave system.
There are fields like:
- Type of leave as text
- From date as date
- To date as date and there is a calculated column named 'RequestedDays' which calculates the number of leave days requested excluding weekends.
Now, I need a field in the edit form which dynamically updates to 8*'RequestedDays' as soon as requestor enters his From date and To date.
I would also like to edit this 'leave hours' field manually and then submit to my manager for approval. How can I do this?