Hello Kelly,

Thank you for reaching out to us.

At the moment, you can add the URL through the database, but please note that it will come up as HTML:

So, it's a bit ugly, but at least it works.

To do that, you need to access the wp_options table in your database, and in there search for "amelia_settings" in the "option_name" column. It will return one row, so you need to edit it. Look for “ics” and you'll see this:

"ics":{"description":{"appointment":"","event":"","translations":{"appointment":null,"event":null}}}

Modify the appointment, so it looks like this:

"appointment":"Zoom Join: %zoom_join_url%"

And that's it.

We'll work on a better solution in the future.

If you have any more questions please open another ticket and we will gladly help you there.

We wish you all the best.

Have a nice day. 

Hello again Kelly,

You need to edit it:

"ics":{"description":{"appointment":"","event":""

in:

"ics":{"description":{"appointment":"","event":"Zoom Join: %zoom_join_url_date%"

or in:

"ics":{"description":{"appointment":"","event":"Zoom Join: %zoom_join_url_date_time%"

It depends on what you need.

But, it will not be shown to you as a location, but as in the screenshots we have sent you.

Also, nothing is "Cut off", but the name is too long in the Google Calendar event, so it doesn't fit in the field. You can scroll through it with the keyboard and see if there is more text.

Hope this explains it. 

Hello again Kelly,

We have forwarded your ticket to our level 2 agents and as soon as we get some feedback from them we will contact you immediately. 

Kelly, that's a JSON file that contains a lot of data. We don't have access to every customer's data, so I initially sent you the structure of the JSON file, which is:

"ics":{"description":{"appointment":"","event":"",

In short:

"ics" defines the ICS file.
"description" which is in the first { is used for describing that ICS file.
"appointment" and "event" in the second { are used to identify descriptions for :

1. Appointments
2. Events

The empty brackets (in my example) contain the description of the ICS file related to either appointments or events.

You need to add the placeholder within the description. So, in your case, replace this:

"ics":{"sendIcsAttachment":true,"sendIcsAttachmentPending":true,"description":{"appointment":"Hi %customer_first_name% - Booking approved!  Check your mail for details. ","event":"Event sign up confirmed! Check your mail for details. ",

with this:

"ics":{"sendIcsAttachment":true,"sendIcsAttachmentPending":true,"description":{"appointment":"Hi %customer_first_name% - Booking approved!  Check your mail for details. ","event":"Event sign up confirmed! Check your mail for details. Zoom Join: %zoom_join_url_date%"

If you want to add Zoom URL into ICS file for appointments, replace the original with this:

"ics":{"sendIcsAttachment":true,"sendIcsAttachmentPending":true,"description":{"appointment":"Hi %customer_first_name% - Booking approved!  Check your mail for details. Zoom Join: %zoom_join_url%","event":"Event sign up confirmed! Check your mail for details. Zoom Join: %zoom_join_url_date%"

Hello again Kelly,

They have sents us this and this should work we have tested it before we have sent it to you. I will forward the ticket to them again. 

Hello Kelly.

Are you still using https://scrumpossible.com/ as your website?

Because, if you do, you're trying to add Zoom links into ICS files without having the Zoom integration configured:

You can't send a Zoom invitation without configuring Zoom in the first place.

Once you configure Zoom as per our documentation, you will also need to link your employee with the Zoom profile in Amelia/Employees, when you access your employee's profile.

Also, I don't know what you're using in your video to modify database entries, but I strongly advise you not to use those types of plugins. The length of some cells is simply too long for you to edit through WordPress plugins, and it could lead to reverting everything to the default settings, so you should be accessing your database directly through your cPanel, or with a direct URL to phpMyAdmin.

The only WordPress plugin I can suggest is WP phpMyAdmin which I installed to check what you added to "amelia_settings". As it turns out, whatever plugin you used in the Loom video didn't actually make any changes to the database:

I also don't see any Notification settings configured, nor is the ICS file even enabled for sending: 

In fact, I believe that all settings and integrations reverted to default settings (Google Calendar, for example, since I saw your employee currently has an error regarding the Google Calendar connection, and the Settings/Integrations/Google Calendar is blank).

This most likely happened after you used that plugin to modify the database entry. This is exactly what I was referring to when I said I strongly advise you not to use those plugins. I hope you have a backup you can revert to. If you don't, you'll need to go through Amelia/Settings all over again and connect your employee to both Zoom and Google Calendar once you do that.

Now, since you already have Amelia's latest version, you don't actually need to go through the database anymore. When you configure Notification settings, and enable the sending of the ics file, you can add the Zoom placeholder in the description:

And it will work normally. This is how it would look on my Google Calendar when I receive the email as a customer:

I suppose it may look odd (like Marko mentioned in one of his first responses) in other calendars, but the links will be there.

Let me know if you need any further assistance after this.

Hey Kelly

Only if you don't have anything to lose (appointments, booked events, etc). If people booked appointments or events, I wouldn't recommend doing this.

Or, you can ask SiteGround if they can only revert the changes made to the JSON content of the option_value cell within "amelia_settings" option_name from wp_options database table.

If they can't do this, and you have appointments/attendees to lose, you should just go through Amelia/Settings and configure everything again.