Hello Zoho Forms, I love the way you work. I need a help for the following-
If any employee makes up to 2 informed late, their full attendance bonus will be in the receivable attendance bonus where there is a hidden field in the form showing individual's attendance bonus when a name is picked from the dropdown.
Rule-1: If Number of Informed Late Days is less than or equal to 2, it shows full attendance bonus hidden inside the attendance bonus field.
Rule-2: If Number of Informed Late Days is equal to or greater than 3, attendance bonus will be 0.
Rule-3: If Number of Uninformed Late Days is equal to or greater than 1, attendance bonus will be 0.
Rule-4: If Number of Uninformed Late Days is equal to 0, hidden full attendance bonus will be on the receivable attendance bonus' field.
Rule-5: If Number of Absent Days is equal to or greater than 1, attendance bonus will be 0.
N.B: There are 3 fields that affect Receivable Attendance Bonus field, they are 1. Informed Late Days, 2. Uninformed Late Days, 3. Absent Days. Receivable Attendance Bonus is a formula field which acts when a rule is met and affects hidden field called Attendance Bonus. When a name of employee is picked from the dropdown, his attendance bonus hits the Attendance Bonus field NOT the Receivable Attendance Bonus field. I am unable to implement 3 fields (informed, uninformed and absent) action into Receivable Attendance Bonus field. Please help.