Event Email Template - Timezones

As a newbie in Suite I am struggling with setting up an email template correctly.
The context is webinar registrations via our website.

I am looking for how to add a timezone to an event, since we get global registrations. I am assuming that the time entered upon creating the event is server time?

So if my server is in Frankfurt and my delegate is in Mumbay and I now send an automated confirmation using an email template with the $fp_events_date_start they will see the start date as per server time (yes?) which is not only useless but confusing. I just cannot identify the place where I can tag an event with the timezone itā€™s created in.

Alternatively I might attach an .ics file but that needs to pull itā€™s time variable from the event in question automatically, otherwise the whole process canā€™t be automated. Any thoughts much appreciated, I canā€™t possibly be the first person to have that specific issue?

  • create a template

Iā€™m afraid this isnā€™t going to be easy to solveā€¦

Time/date variables in SuiteCRM are standardized to UTC when they go in the database. This brings some uniformity to data storage. Then these values can be displayed to users across the globe by getting calculated, taking into account the timezone set in the userā€™s profile.

But what you seem to need is the Delegateā€™s timezone setting, which you donā€™t even have stored in SuiteCRMā€¦

My add on PowerReplacer has advanced time/date calculus features and would allow you to use a template that molds to the recipientā€™s timezone - but you would still need to store that in a custom field so that the system knows what to calculate.

I was hoping the the email module would send out some kind of identifier along with this variable $fp_events_date_start, where it makes itself known as ā€˜beingā€™ UTC, so that the email client on the receiving end could do its magic and convert to local time? Thatā€™s probably assuming a bit much. I get your drift about having to store the userā€™s time zone in order to use it. But with leads that is unrealistic, since half of them will not bother ot fill in their time zone on a web form and then the exercise becomes futileā€¦

Maybe the Lead form can get that timezone value from the browserā€™s settings? Iā€™m not sure itā€™s possible but maybe something could be achieved with Javascript.

You can add the static ā€œUTCā€ notice by editing the template of the event email.

Yes I had alread thought about that. Iā€™ll have to ponder this a bit more. Breave new world of globalization with its whole new can of worms. Anyhow, thank you for your time :wink:

1 Like