Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
Absence Entry Validation

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.
Answers
-
Please check if the sample snippet helps you.
-
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.
-
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
-
Hi Ashish,
I will try if it works for me, thank you!