Nick_Rothwell - profile

Nick_Rothwell · Nov 20, 2017

I created a bunch of entries with start and finish times such as 10:00 / 14:00 a couple of months ago. Now that we’re out of BST and into GMT they’re all noted as 11:00 / 15:00 - i.e. they appear to be absolute time values displayed in the browser’s ...

Nick_Rothwell · Nov 20, 2017

On the latter: it appears that the DATETIME_FORMAT output strings were generated when we were in BST and then cached, and so didn’t change when we shifted out of BST. Modify the Date values (to their current values!) and the formatted values change. ...

Nick_Rothwell · Oct 25, 2017

(What I’m using this for is a view filter in Calendar mode: show items where linked columns are checked. If it were a checkbox list, then I can see the argument for having a view filter for all boxes checked, and for any boxes checked - and the inver...

Nick_Rothwell · Oct 25, 2017

Just to jump in here - I see that an attempt to group checkboxes via a Lookup column (against multiple records) results in a single checkbox, whose value appears to be “checked” if any of the linked columns’ checkboxes are checked, and clear otherwis...

Nick_Rothwell · Sep 26, 2017

I would think the field-displayed-in-calendar-view should be a selectable property of the view itself?

Nick_Rothwell · Sep 26, 2017

For time-only fields I tend to use a datetime of 1970-01-01 HH:MM, and create a second formula field with DATETIME_FORMAT(_From, 'HH:mm') for display, hiding the original except when editing. So yes, a dedicated time-only data type would be good.

User Statistics

User Activity

Dates/times locked to absolute time values rather than floating (and: DATETIME_FORMAT caching)?

Re: Dates/times locked to absolute time values rather than floating (and: DATETIME_FORMAT caching)?

Re: Field type Request: Checkbox List

Re: Field type Request: Checkbox List

Re: Choosing a non-primary field as display name w/o using a formula

Re: Time Field Type