0

Incorrect Time From Trigger After Update in Web Version

The following happens when using the mobile and desktop web version of Ninox using an Android phone using Chrome and DuckDuckGo browsers, iPad using Safari and Chrome and PC desktop using Chrome and IE. It does not happen using the iPad app or and Android app. I haven“t tested other browsers.

When populating the current time in a Time field using Trigger after update, the wrong time is shown. However, using the same code in On click of a button or formula field, the correct time is shown.

For more detail, I have a tracking db with a Choice field with code in the Trigger after update field to populate the start date and time after a choice is made. I also have a button with code in On click to populate the start date and time if the start date and/or time is cleared by the user.

I have 3 date and time field, StartDate, StartTime and StartDateTime. StartDate is a Date field. StartTime is a Time field. StartDateTime is a Formula field; the formula is simply StartDate + StartTime. I do this as 3 separate field because the mobile web version of Ninox only shows part of the DateTime picker when a Date / Time field is used. I have now discovered it also only shows part of the Time picker now as well, but that another issue.

The code I am using for the Button - On Click and the Choice - Trigger after update is the same as follows:

if StartTime = null then
StartTime := now() - today()
end;
if StartDate = null then
StartDate := today()
end

When using Trigger after update in the Choice field, StartDate will be populated with today”s date, StartTime will display an incorrect time, but the StartDateTime formula field will show the correct date and time. eg. StartDate 12/05/2020, StartTime 05:25 and StartDateTime 12/05/2020 9:25 PM.

When using On click of a formula field or button, everything will appear correct. eg. StartDate 12/05/2020, StartTime 21:25 and StartDateTime 12/05/2020 9:25 PM.

I don“t understand this and it seems like a bug in the web version of Ninox. This started happening around mid November 2020.

Reply

null

Content aside

  • 3 yrs agoLast active
  • 362Views