search

GCalToolkit / Sheets2GCal

Issue Tracker for Sheets2GCal Google Sheets Add-on
0 stars 1 forks source link

When using formula for my configured sheet, it doesn't tick update automatically. #45

Open Emmmm8888 opened 3 months ago

Emmmm8888 commented 3 months ago

Hi,

I have a 'Master Log' sheet where I log all my events. I then have another sheet which I've configured to a calendar which uses the Filter and Array formula to pull info from my Master Log. However, when I update event details on my Master Log, it updates nicely on my configured sheet but the Update checkbox does not tick itself automatically as it would if I were to manually change event details on the configured sheet directly.

Could you please tell me if there is a way that the check box could 'check' itself when I update my Master Log and it feeds into the configured sheet that is automated by a formula?

Thank you!!

P.S: Love Sheets2Cal! Working really well.

GCalToolkit commented 3 months ago

Hi, unfortunately it's not currently possible to detect changes to a sheet that are made manually because Google don't provide an event for this type of edit.

To work around this there's an option "Check Sheet vs Calendar" that goes through each row, checks if there's a difference between the Sheet and the Google Calendar and checks "Update" for rows that don't match the calendar event.

That function is also run before any "Automatic Import/Export" so that any rows changed by data pulled in from another Sheet will be set to "Update"

There is one caveat: you need to be careful if you also edit the calendar as that function only detects differences between the two and doesn't know which has been edited.