I'm needing some assistance with Form Validation.
I have a column inside my sharepoint listed called "Payroll Close Day". This column allows the end user to select from a choice of values being "Monday, Tuesday, Wednesday, Thursday and Friday".
I have added another column called "Period End Processing Day", set up the exact settings.
I need some advice to understandable if it is possible to:
- Stop the user selecting the same day in the "Period End Processing Day" as what is selected in the "Payroll Close Day".
- When the user selects the "Period End Processing Day", ensure the day selected is the "Payroll Close Day" + 1. So if they select Tuesday in the "Payroll Close Day", the "Period End Processing Day" must be Wednesday.
Thanks in advance and any suggestions would be appreciated.