When creating a new record for the appointments, I need to have a script or calculation that automatically checks a checkbox to indicate if the date is a saturday or a sunday.
Who can help me out ?
Do you really need a checkbox (i.e. a field) for this? You could simply conditionally format some layout object, or hide it based on a calculation - for example, hide when:
not ( DayOfWeek (YourDatefield ) = 1 or DayOfWeek (YourDatefield ) = 7 )
If you really want a checkbox, then make it a calculation field (result is Number) =
DayOfWeek (YourDatefield ) = 1 or DayOfWeek (YourDatefield ) = 7
and format it using a custom value list of "1".
I think that exactly what I was looking for !
The conditional format should be great.Let me test that out straight away...
Yes, it did the trick !
Thank you very much for your solution !
Retrieving data ...