4 Replies Latest reply on Mar 27, 2020 1:20 AM by 4071240

    Absence Entry Validation

    4071240

      Is there any fast formula that can check the previous absence record upon absence submission, if there are absence records with the same absence type of the current selected absence type that have applied on the day before the current selected date (also consider day off, holiday), system could prompt an error message to ask the user to cancel the previous one and submit one absence request as a whole.

       

      Example, User has applied a no pay leave on 5-6 Mar 2020, and now applying another no pay leave on 9-10 Mar 2020. As 7-8 is day off (Sat & Sun), and 5-10 should considered as a consecutive absence records, system should prompt error message to ask user to cancel 5-6 Mar 2020 absence and apply for 5-10 Mar 2020 instead.

       

      Please advise, thank you.