Absence Entry Validation

Cecilia-Oracle

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.

AshishHCM

Please check if the sample snippet helps you.

Cecilia-Oracle

Thank you so much Ashish for your quick reply. I am not familiar with fast formula, may I know the below "Heading" of the fast formula is correct and is there anything else that I have to defined in the beginning?

DEFAULT FOR START_DATE IS '4712/12/31 00:00:00' (date)

DEFAULT FOR END_DATE IS '4712/12/31 00:00:00' (date)

INPUTS ARE START_DATE (date), END_DATE (date)

Thank you very much.

AshishHCM

Hi,

You may have to define a lot more default statements, input variables and local variables too.

I would suggest refer some of the samples in Fast Formula guide or you can refer the attached file.

Hope this helps!

Kind Regards

Ashish

Cecilia-Oracle

Hi Ashish,

I will try if it works for me, thank you!