📅 Exporting ICS (Calendar) Files for Business Central 💡
A sample extension creates RFC 5545 ICS calendar files from Business Central, shown on the Customer Card and the Sales Order, for use in Outlook, Teams, Google or Apple Calendar. It offers a record-level action and AssistEdit on date fields. Both prefill event details that users can adjust before the file downloads.
post Gerardo Rentería Blog
"This disconnection could result in missed deadlines for certain activities, with the resulting reduction in productivity or the execution of duplicate work."
Key points
- Business Central planning dates are disconnected from the calendar tools users work in every day.
- Uses the RFC 5545 ICS format, which common calendar platforms can read.
- Record-level action on the Customer Card prefills a meeting with the customer name, the customer address, the user’s email and the next working day.
- AssistEdit on the Posting Date field of the Sales Order prefills a high-priority event at 9:00 AM. The pattern can be reused on any date field.
- Objects include a temporary buffer table, generator and helper codeunits, a configuration page, two page extensions and a permission set.
Quotes
- “This disconnection could result in missed deadlines for certain activities, with the resulting reduction in productivity or the execution of duplicate work.” (Clearly articulates the business problem that the extension solves by keeping calendar data in sync across systems)
- “The generated ICS file automatically integrates with all modern calendar platforms, such as Microsoft Teams/Outlook Calendar or Google Calendar.” (Demonstrates universal compatibility without platform lock-in, following open standards for maximum utility)
AL objects mentioned
As named in the post. A name that matches one object page by exact type and name links to it; the others stay as named.
- table “ICS Event Data Buffer”
- codeunit “ICSFileGenerator”
- codeunit “ICS Business Helper”
- codeunit “ICS Assist Edit Manager”
- page “ICS Event Configuration”
- permissionset “ICSFilePermSet”
Not found in BC28-30: table “ICS Event Data Buffer”, codeunit “ICSFileGenerator”, codeunit “ICS Business Helper”, codeunit “ICS Assist Edit Manager”, page “ICS Event Configuration”, permissionset “ICSFilePermSet”.
Context
- Features: ICS file generation, RFC 5545 compliance, Record-level calendar event creation, Field-level assist edit integration, Pre-populated event configuration, Multi-platform calendar compatibility, Automatic file download, Customizable event properties
Source: Gerardo Renteria, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.