How to set the WHEN field on the schedule page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-04-2023 08:45 AM
The WHEN field on the schedule page (cmn_schedule_page is not a real field. You can't see any information about it in the XML of the record.
How do I set this value in a business rule? What format does it need? I can't find any documentation on how we can set this field ourselves outside of clicking on it via the form.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-04-2023 03:05 PM
A schedule page is a record that contains a collection of scripts that allow for custom generation of a calendar or timeline display (per documentation.)
Schedule Entries (cmn_schedule_span) are the records of events to display on the particular Schedule Page. This is the table you need to be concerned about for formatting values.
Once upon a time, I was working on a project to automate adding schedule entries using a business rule on a scoped application table. This ended up being really interesting to figure out and should be the same whether it is scoped or not. "When" actually ends up being two different fields:
- start_date_time
- end_date_time
The values I saw I needed to input looked like this: TZID=US/Central;2023-08-04 00:00:00
You should be able to get TZID from the user's profile or just set it strictly like I needed to.