search

GCalTools / Sheets2GCal

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

1 of 4 sheets not syncing #47

Open efox13 opened 6 months ago

efox13 commented 6 months ago

I have 4 tabs in a google sheet using the Sheets2GCal extension. 3 of them were created at one time and are running perfectly. The 4th was created after and has been working fine, except for when I manually delete rows. Upon deleting a row, it automatically checks off all the update boxes for any rows under the deleted one. The other sheets do not do this.

The second issue is that the 4th sheet will no longer update. I have been using this sheet 4th for a couple of months and it has worked fine, however yesterday and today it will not sync. When I Export, I get the error "Please select "Delete" or "updtae" for some events and verify your data is valid. I have 4 rows checked off to update.

GCalToolkit commented 6 months ago

Could you share (read-only) a copy of the Sheet, minus any sensitive data, with info at GCalTools dot com? If not, could you post some screenshots showing the header (row 1)?

This usually means the header has been altered, or you might have some formulas that are affecting other rows inadvertently.

Thank you for your patience with this, and please feel free to follow up by email at the same address if you'd rather not share any of this with the world!

efox13 commented 6 months ago

[image: image.png][image: image.png]

On Thu, May 16, 2024 at 12:00 PM GCalTools @.***> wrote:

Could you share (read-only) a copy of the Sheet, minus any sensitive data, with info at GCalTools dot com? If not, could you post some screenshots showing the header (row 1)?

This usually means the header has been altered, or you might have some formulas that are affecting other rows inadvertently.

Thank you for your patience with this, and please feel free to follow up by email at the same address if you'd rather not share any of this with the world!

— Reply to this email directly, view it on GitHub https://github.com/GCalToolkit/Sheets2GCal/issues/47#issuecomment-2115627691, or unsubscribe https://github.com/notifications/unsubscribe-auth/BIRC4HH266R5JUU536TXW6LZCTJ3NAVCNFSM6AAAAABH2I7BPOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCMJVGYZDONRZGE . You are receiving this because you are subscribed to this thread.Message ID: @.***>

GCalToolkit commented 6 months ago

Unfortunately to post images to GitHub you need to visit https://github.com/GCalToolkit/Sheets2GCal/issues/47 in your browser instead of replying by email. Alternatively you can just them by email to the address I indicated above (my email contact is also listed on http://www.gcaltools.com and www.sheets2gcal.com).

efox13 commented 6 months ago

Capture 1 Capture 2

After submitting my initial issue, I noticed that cell 1C had been changed to "cv" instead of "Title" which I have since changed back. The sheet says it is no longer connected to a calendar. When I go to configure sheet, the correct google calendar link shows. When I click link sheet, it changes to ???

Capture 3 Capture 4

GCalToolkit commented 6 months ago

Is this a calendar that you own? Afaik the calendar ID for your own calendars shouldn't contain an underscore... Did you double-check that ID? If so it's possible that I coded more restrictions for linking than importing, but I'll have to check that.

Can you still import that calendar to a new Sheet, and does it display the same ID?

efox13 commented 6 months ago

It's not a calendar I own, I just have edit access on it.

I ended up recreating the sheet and both issues seem to be fixed/working for now on the new sheet.

GCalToolkit commented 6 months ago

Ok, in that case I'll check the "Link Sheet" code as it might be unnecessarily restrict the ID. Thanks for letting me know!