Release date: September 17th, 2024 ET
We released the following updates since 8.66:
Improvements:
Calculated fields
Calculated fields now include date-and-time type, duration between dates, timecode, modulus function, and more.
Support for the Date and Time type
The type Date and Time is now fully supported in calculated fields. For example, easily calculate the number of work days since the last update with NETWORKDAYS(TO_DATE({updated_at}),TODAY())
. Or you could use NOW()-{updated_at}
and get the number of calendar days, with decimals showing fractions of a day.
New Date and Date and Time functions
Name | Description |
---|---|
NOW | Returns current date and time. |
DATE_TIME | Forms a date and time. |
NETWORKDAYS | Returns the numbers of work days between two dates, as a duration. |
WORKDAY | Returns a date that is a number of work days after a date. |
New type conversion functions
Name | Description |
---|---|
TO_DATE | Converts a date and time value to a date. |
TO_SECONDS | Converts a duration to a number of seconds. |
TO_MILLISECONDS | Converts a duration to a number of milliseconds. |
TIMECODE_STR | Converts a number of frames and a frame rate into a timecode string. |
New math function
Name | Description |
---|---|
MOD | Returns the remainder of a division. |
Bug fixes:
Client Review Site
- Fixed an issue where a logged out internal user would be re-directed to the Projects page instead of navigating directly to the shared Playlist when sharing a Playlist via Client Review Site. [SG-35772]
Generative Scheduling
- Generative Scheduling’s integration with Flow Production Tracking can now be used by sites that have an IP allow list in place. [GSCHD-1993]
Notes
- Fixed an issue where a note would render HTML content instead of displaying it as a plain text. [SG-35644]
Gantt
- Fixed an issue where filters would not work on the Task+Gantt widget when full screen. [SG-35778]
Media App
- Fixed an issue where Numeric field “0” values would be displayed as an empty value on the Media page. [SG-27861]
Canvas Widget - Countdown
- Adds the ability to choose whether or not to show the title bar on widgets. This means that the countdown widget can now show a title bar, but other widgets can now choose to hide them. [SG-32919]
Global Follow Settings
- Fixed an issue where in some cases a query field could be displayed in Global Following Settings. [SG-32926]
Fields
- Fixed an issue where a text autocomplete feature would not work on the Link field on TimeLog entity. [SG-35705]
Site Activity Monitor
- Fixed a visual issue where sometimes some Apps (for instance the Site Activity Monitor) would not be displayed as menu items in the User menu. [SG-35417]
Column Summaries
- Improved the performance of column summaries when the Open Notes Count field or a custom query field is present on the page. [SG-35749]
Fields (Administration)
- Fixed a minor visual regression where Short code field on the Status List creation form would be displayed as “Status Name”. [SG-35963]
- Fixed a UI visual glitch where a field would be present after it was deleted on the Fields dialogue. [SG-35958]
File Attachments
- Fixed an issue where attachment field content would be displayed as multiple items when creating a note and pasting a single image to the attachment field. [SG-35810]
RV
- Fixed an issue where making an API call to find WorkDay rule would result in an error. [SG-35511]
WorkDay Rules
- Fixed an issue where making an API call to find WorkDay rule would result in an error. [SG-35511]