filling an appointment field
I have two date fields, one field called 'start date' and one 'end date'. Is there a possibility to fill this data in an appointment field automatically? Lets say in the trigger after update of the two date fields?
This way i can see the period of that task in the calendar whitch is not possible with just my two date fields. Only the start date and the end date is colored, not the dates between them.
5 replies
-
You could put this in the Trigger after update of the 'end date' field...
YourAppointment := appointment('start date', 'end date') -
Thanks, works fine...
Any way to remove the hours and just show the date in the appointment field?
-
@Steven
From the reference manual.. https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language then search for start(appointment).. which gives you the starting timestamp... then strip off the time by converting it to a date. You could also use a format string.
date(start(Appointment))
-
Ok, thanks i'll try
-
@Steven... You bet. In my GSD (Get Stuff Done)... I decided to use three different date fields.. Start Date / End Date .. for tasks .. and Appointment for meetings....
Content aside
- 5 yrs agoLast active
- 5Replies
- 2658Views