how to use new fuction sync with google calendar

[Jorge Luis]

I'm trying to use the new Memento Database feature to sync with Google Calendar, but I've already completed the first step of exporting menu, LInk and I don't know what to do next to make them appear in the calendar.

[Simon Hall]

I can't seem to get this to work at all. The relevant library has both a date field and a time field.

When I go to Import & Export the only option I get are Link to Google Sheets, Import & Export, Send All.

If I select Import & Export the options are Import from CSV, Export to CSV.

The Link to Google Calendar option doesn't appear at all

Am I missing something?

[Jorge Luis]

The field has to be "Date/time" no separated

[Simon Hall]

Thanks Jorge

Though this is NOT what it says in the Memento help articles.

So the question becomes.... how can I merge my current Date and Time fields into a single Date/Time Field

Regards

[Jorge Luis]

MAybe you dont have the BETA version

In fact, even if the database has a date field, the option to sync with Google Calendar should appear.

memento 5.8.0 BETA

[Simon Hall]

No I don't. Again there is no mention in the help that this is only in BETA. I'll wait until the full release

[David Gilmore]

You did not get an answer to that indirect question on how to merge a separate date and time Memento fields into a combined datetime field. Actually you will find that date fields often will have a time setting as well, just ignored. The same with a time field.

But to merge those two fields:

ver e as entry();
var ddate = new Date(e.field("datefield"));
ver dtime = new Date(e.field("timefield"));
ddate.setHours(dtime.getHours(), dtime.getMinutes(), dtime.getSseconds(), dtime.getMilliseconds());
e.set("datetimefield", ddate.getTime());