Not Displaying Appointments on Mondays???!?!?!?
I have a very weird situtation occuring on my Ninox Database.
For some very strange reason, it is refusing to show any appointments on Mondays for 2 of my tables.
anyone ever have this problem before?
Have you looked at the other views, 5 day or 1 day, or unchecked the 'show only working hours' button? What type of field is the date derived from, Date or Date + Time or Appointment? Have you tried changing the date of that particular record, seeing if it shows up, and then changing it back again?
Hi All, If anyone has an idea on what is happening with my Ninox Database. Any help would be great.
I have tested further and created a new table with 1 appointment field and put in a date that was on a Monday between 8am and 10am and it will not show up on the calender regardless of the view beign 1 day- 5 days or 7 days and showing all hours of the day.
screen shots provided:
Now i change the time to after 10am:
All help will be greatful as my whole system relise on being able book at anytime
So the Ninox team got in touch with me (5 star in their customer care) and after 45 min on Zoom and an 8 hour sleep, I received the following email for the solution.
It seems that this issue is related with the 'Independent timezone date' feature, released in the latest Ninox Version.
Please try the following process in order to Enable this feature on your databases
This solved my problem immediatly....However, i am now experience UTC issue where no matter what time i put into a time field and appointment. It will show up in the calender 10 hours later i.e appointment that starts at 8am will show starting at 6pm on the same day. I have a "trigger after update" code for the appointment to be set from a date field and 2 time fields, one start time and one finish time (I have tried it with the duration field with the same result)
I have resulted to using the code:
- time(10, 0)
to get my time back to the correct zone.
Not ideal but a temporary fix