Problems with the syncronization

[IMT1111]

When I set to import to the calendar automatically, it deletes all the formulas and leaves just the values. If I protect the the columns with the formulas so the user that uses the Sheets2GCal extension can't edit the columns with the formulas, Sheets2GCal doesn't synchronize with calendar automatically, just manually. The manual import works even if those columns are protected but apparently no the automatic one. Thanks so much

[GCalToolkit]

I'll look into this today and let you know what I find ASAP. Thanks for letting me know!

[IMT1111]

Thanks so so much!!

On Thu, 24 Aug 2023, 10:22 GCalToolkit, @.***> wrote:

I'll look into this today and let you know what I find ASAP. Thanks for letting me know!

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

[IMT1111]

I'm trying today and now it doesn't even let me update the calendar from the sheet manually because I I had to protect some columns that it doesn't need to edit (start, end, start time, end time and location). The extension has permission to edit the rest of columns but it is not running like that. If I give permission to edit everything it will delete me all the formulas and it will replace them by the values only. It only needs to edit the columns: event ID, Link, delete and update. I don't understand why it wants to edit everything. Thanks so much for your help

[image: image.png]

Many thanks! Please do not hesitate to contact me if you have any further questions. With best regards,

Israel Mendoza-Tellez

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify Israel Mendoza-Tellez. This message contains confidential information and is intended only for the individual named. You should not disseminate, distribute or copy this email. Please notify Israel Mendoza-Tellez immediately by email if you have received this email by mistake and delete this email from your system. You are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Thanks for your cooperation.

---

Esta comunicación contiene información que es confidencial y también puede contener información privilegiada. Este mensaje ha sido enviado por Israel Mendoza Téllez, única y exclusivamente para ser leído por el destinatario, quedando terminantemente prohibida cualquier distribución, copia, reenvío del mensaje, transcripción, grabación, fotografiado, o mención del contenido de esté mensaje con ninguna persona o medio. Si usted no es el destinatario/s, o aunque lo sea, tenga en cuenta que cualquier distribución, copia o uso de esta comunicación o la información que contiene está estrictamente prohibida. Si usted ha recibido esta comunicación por error por favor notifíquelo por correo electrónico o por teléfono y elimine el mensaje inmediatamente. Tenga en cuenta que pudiera darse el caso de que se emprendan acciones legales por incumplimiento de estas condiciones. Gracias por su colaboracion.

On Thu, 24 Aug 2023 at 10:22, GCalToolkit @.***> wrote:

I'll look into this today and let you know what I find ASAP. Thanks for letting me know!

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

[GCalToolkit]

Hi Israel, that's normal - to reduce the significant overhead of checking existing values cell by cell before updating Sheets2GCal overwrites the row. Google limits the time that App script is allowed to run between user interactions, and checking cell values is time-consuming. This means that updating cells which have changed would mean a massive reduction in the number of rows/events that the add-on could manage.

However, the formulas should not be affected as the automatic update uses exactly the same code as the manual update. Unfortunately, to test properly under the exact same conditions as yourself requires me to test with triggers... which limits the speed at which I can test.

Thanks you for your patience with this issue, and if you'd like to continue the conversation by email please contact me via my website or "info" at "GCalToolkit" dot com.

[GCalToolkit]

I'm sorry for the delay, but could you please clarify a few things to help me reproduce this? Are the formulas being deleted from new rows, from existing rows which are being updated, or from every row in the Sheet?

[IMT1111]

Thanks for your message. They are deleted from the whole columns both from the new entries and the ones to update, and they are replaced by the value of the fórmulas. I had to go back to the historic versions of the sheet to recover the fórmulas. Thanks so much for your help

On Sat, 26 Aug 2023, 18:54 GCalToolkit, @.***> wrote:

I'm sorry for the delay, but could you please clarify a few things to help me reproduce this? Are the formulas being deleted from new rows, from existing rows which are being updated, or from every row in the Sheet?

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

[GCalToolkit]

I'm currently trying to figure out why the manual update is working normally but the triggered version isn't even though they call the exact same function. It seems that for some reason Google Sheets is behaving differently when the user isn't present, but I'm still testing.

Also, are your formulas the same for the entire column? If so, have you already tried using ARRAYFORMULA instead of using formulas in each cell as explained here: https://www.bpwebs.com/apply-formula-to-entire-column-in-google-sheets ?

[IMT1111]

I was trying this morning and now when doing manually It doesn't work either because of the protected cells. I Will try what you say about the arrayformula but It may write the value in each cell so It could end Up with the same problema. Thanks so much

On Sat, 26 Aug 2023, 21:26 GCalToolkit, @.***> wrote:

I'm currently trying to figure out why the manual update is working normally but the triggered version isn't even though they call the exact same function. It seems that for some reason Google Sheets is behaving differently when the user isn't present, but I'm still testing.

Also, are your formulas the same for the entire column? If so, have you already tried using ARRAYFORMULA instead of using formulas in each cell as explained here: https://www.bpwebs.com/apply-formula-to-entire-column-in-google-sheets ?

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

[IMT1111]

I think the problem is just because It rewrite the value. It should just read the rows that have changed and update the calendar. I don't see the need of editing those columns apart from the ID and the Link etc. It should edit and change the info in the calendar event but no in the Google sheet

On Sat, 26 Aug 2023, 21:26 GCalToolkit, @.***> wrote:

I'm currently trying to figure out why the manual update is working normally but the triggered version isn't even though they call the exact same function. It seems that for some reason Google Sheets is behaving differently when the user isn't present, but I'm still testing.

Also, are your formulas the same for the entire column? If so, have you already tried using ARRAYFORMULA instead of using formulas in each cell as explained here: https://www.bpwebs.com/apply-formula-to-entire-column-in-google-sheets ?

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

[IMT1111]

I just tried again unprotecting the sheet and with IMPORTRANGE and again deleted the formula and wrote the values in every single cell, so like this the extension definitelly isn't useful for anybody that wants to use any type of formula, even the type IMPORTRANGE or ARRAYFORMULA ETC. I wrote IMPORTRANGE in the cell D1 (heading) and it rewirtes even there. At the moment the extension can only be used by people who input by forms or by typing manually

On Fri, 25 Aug 2023, 10:20 GCalToolkit, @.***> wrote:

Hi Israel, that's normal - to reduce the significant overhead of checking existing values cell by cell before updating Sheets2GCal overwrites the row. Google limits the time that App script is allowed to run between user interactions, and checking cell values is time-consuming. This means that updating cells which have changed would mean a massive reduction in the number of rows/events that the add-on could manage.

However, the formulas should not be affected as the automatic update uses exactly the same code as the manual update. Unfortunately, to test properly under the exact same conditions as yourself requires me to test with triggers... which limits the speed at which I can test.

Thanks you for your patience with this issue, and if you'd like to continue the conversation by email please contact me via my website or "info" at "GCalToolkit" dot com.

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

[GCalToolkit]

Thank you for your patience, I'm nearly ready to release an update that keeps all formulas intact during manual or automatic updates. I do have a few questions though about how you are using the formulas and the behaviour you would expect. The easiest way would be to either share an example Sheet with me containing the formulas you'll be using, or some screenshots.

For example, would you expect all cells containing a formula to ignore any changes to the calendar - even though subsequent Sheet > Calendar operations would then overwrite edits to the calendar? Are new rows created from new calendar events expected to prioritise the calendar data or (if present) a formula set for an entire column?

With over 70k users I have to be very careful when changing behaviour like this to ensure that it doesn't adversely affect other users who might use formulas in very different ways... so even though I have a version that works for me I still need to do extensive testing.

[IMT1111]

Thanks so much for your message. In my case I haven't edit the calendar events as I expected them to be updated by the extension from the sheet. Basically under the option "UPDATE CALENDAR FROM SHEET" (the one I use), I would expect the extension not to edit the columns C to O at all. I would expect it to check if the content of a row has changed and update the event consequently or if a new row was added, to create a new event in the calendar with those details. It should be forbidden to edit the sheet to avoid it changing the formulas. The other option (IMPORT CALENDAR TO SHEET) should edit the sheet, but not this one. If you want to add an option that works in both directions, it would be different (that the user can edit either the sheet or the calendar, and the other would reflect the changes), but the user wouldn't be able to use formulas with this option.

• Would you expect all cells containing a formula to ignore any changes to the calendar - even though subsequent Sheet > Calendar operations would then overwrite edits to the calendar? - YES
• Are new rows created from new calendar events expected to prioritise the calendar data or (if present) a formula set for an entire column? - I would prefer to have formulas in every cell to create the events, so if specific conditions are met, the row would display information to create an event, otherwise the row would remain blank with no event.

Let me know if you understand what I mean or have any questions, or maybe you have a better idea. Another concern is that I'm not sure how well the column B (UPDATE) will detect when the content of cell in a row has been changed by a formula in the cell or by the ARRAYFORMULA option. Maybe it will expect the cells to be updated manually? Thanks so much for your message. After trying for a while the ARRAYFORMULA option you suggested doesn't work either as the extension writes data and the array formula needs the range to be blank to be able to display the data. Also, the option to automatically synchronize the sheet with the calendar doesn't run at the time selected but at different times like in a random way so it isn't possible to plan ahead when the events will be posted in the calendar. Thanks so so much for all your help with this.

With best regards,

Israel Mendoza-Tellez

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify Israel Mendoza-Tellez. This message contains confidential information and is intended only for the individual named. You should not disseminate, distribute or copy this email. Please notify Israel Mendoza-Tellez immediately by email if you have received this email by mistake and delete this email from your system. You are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Thanks for your cooperation.

---

Esta comunicación contiene información que es confidencial y también puede contener información privilegiada. Este mensaje ha sido enviado por Israel Mendoza Téllez, única y exclusivamente para ser leído por el destinatario, quedando terminantemente prohibida cualquier distribución, copia, reenvío del mensaje, transcripción, grabación, fotografiado, o mención del contenido de esté mensaje con ninguna persona o medio. Si usted no es el destinatario/s, o aunque lo sea, tenga en cuenta que cualquier distribución, copia o uso de esta comunicación o la información que contiene está estrictamente prohibida. Si usted ha recibido esta comunicación por error por favor notifíquelo por correo electrónico o por teléfono y elimine el mensaje inmediatamente. Tenga en cuenta que pudiera darse el caso de que se emprendan acciones legales por incumplimiento de estas condiciones. Gracias por su colaboracion.

On Wed, 30 Aug 2023 at 10:54, GCalToolkit @.***> wrote:

Thank you for your patience, I'm nearly ready to release an update that keeps all formulas intact during manual or automatic updates. I do have a few questions though about how you are using the formulas and the behaviour you would expect. The easiest way would be to either share an example Sheet with me containing the formulas you'll be using, or some screenshots.

For example, would you expect all cells containing a formula to ignore any changes to the calendar - even though subsequent Sheet > Calendar operations would then overwrite edits to the calendar? Are new rows created from new calendar events expected to prioritise the calendar data or (if present) a formula set for an entire column?

With over 70k users I have to be very careful when changing behaviour like this to ensure that it doesn't adversely affect other users who might use formulas in very different ways... so even though I have a version that works for me I still need to do extensive testing.

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

[GCalToolkit]

The changes I've made so far are all for Calendar => Sheet and basically ignore any edit to cells already containing a formula, which is something people have asked for in the past too.

Updating the Calendar from the Sheet doesn't affect formulas as it only updates the relevant cells, as you said.

However, rereading your posts I realise that you are expecting the Automatic Import to update the Calendar from the Sheet whereas it's the opposite: it imports updates from the Calendar to the Sheet (which was affecting formulas)

So I think what you really need is "Automatic Update" in addition to "Automatic Import". This is a work in progress because I need a way to handle errors with calls to the Calendar API when the user isn't present. It's been a problem for a while now as unlike Sheets, Google calendar didn't let you easily roll-back to an earlier version if there is a problem.

I'll first update so formulas are preserved on Syncing Calendar=>Sheet, then take another look at Automatic Update and let you know how long I think it might take.

[IMT1111]

Oh ok, I understand, so sorry for my confusion. Yes, that option would be great. I think it wouldn't be a problem what you say that Google Calendar doesn't let you easily roll-back to an earlier version if there is a problem because in this case as all the events are backed on the sheet if it would be an error it could delete all the events created previously from that sheet (as we have the event ID on the column Q), and create all the events again. Also, it is easy to use a calendar just for this to not mess with the events in other calendars if there is any error etc. I think it is worth having that Automatic update available even if we may encounter any error. We can always run it manually to override the possible errors but it would avoid running it manually every single time. Thanks so much for everything!!!

Please do not hesitate to contact me if you have any further questions. With best regards,

Israel Mendoza-Tellez

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify Israel Mendoza-Tellez. This message contains confidential information and is intended only for the individual named. You should not disseminate, distribute or copy this email. Please notify Israel Mendoza-Tellez immediately by email if you have received this email by mistake and delete this email from your system. You are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Thanks for your cooperation.

---

Esta comunicación contiene información que es confidencial y también puede contener información privilegiada. Este mensaje ha sido enviado por Israel Mendoza Téllez, única y exclusivamente para ser leído por el destinatario, quedando terminantemente prohibida cualquier distribución, copia, reenvío del mensaje, transcripción, grabación, fotografiado, o mención del contenido de esté mensaje con ninguna persona o medio. Si usted no es el destinatario/s, o aunque lo sea, tenga en cuenta que cualquier distribución, copia o uso de esta comunicación o la información que contiene está estrictamente prohibida. Si usted ha recibido esta comunicación por error por favor notifíquelo por correo electrónico o por teléfono y elimine el mensaje inmediatamente. Tenga en cuenta que pudiera darse el caso de que se emprendan acciones legales por incumplimiento de estas condiciones. Gracias por su colaboracion.

On Wed, 30 Aug 2023 at 15:51, GCalToolkit @.***> wrote:

The changes I've made so far are all for Calendar => Sheet and basically ignore any edit to cells already containing a formula, which is something people have asked for in the past too.

Updating the Calendar from the Sheet doesn't affect formulas as it only updates the relevant cells, as you said.

However, rereading your posts I realise that you are expecting the Automatic Import to update the Calendar from the Sheet whereas it's the opposite: it imports updates from the Calendar to the Sheet (which was affecting formulas)

So I think what you really need is "Automatic Update" in addition to "Automatic Import". This is a work in progress because I need a way to handle errors with calls to the Calendar API when the user isn't present. It's been a problem for a while now as unlike Sheets, Google calendar didn't let you easily roll-back to an earlier version if there is a problem.

I'll first update so formulas are preserved on Syncing Calendar=>Sheet, then take another look at Automatic Update and let you know how long I think it might take.

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

[GCalToolkit]

You wouldn't believe the mess I've seen people get into when editing calendars, and not everything is recoverable using the Sheet - in particular changes made to repeat event series, for example. Recreating a calendar can also be a nightmare for users with many guests to thousands of events/Meets - sending thousands of new invitations to new versions of events is not a pleasant experience! Nevertheless, I'm hopeful I can find a solution, and I'll do some more work on it this week and let you know how I get on.

Also, I forgot to mention that it's currently impossible to automatically detect changes pulled into a Sheet as a result of a formula. Unfortunately the only way around this would be to update every event whether they have changed or not, or to store a shadow copy of every sheet to compare against... which might be fine for anyone with only a few hundred rows, but is very inefficient and will inevitably cause issues for large calendars.

[IMT1111]

Ok thanks, I understand. Thanks for clarifying, I will tick the boxes so it updates the events.

On Wed, 30 Aug 2023, 16:35 GCalToolkit, @.***> wrote:

You wouldn't believe the mess I've seen people get into when editing calendars, and not everything is recoverable using the Sheet - in particular changes made to repeat event series, for example. Recreating a calendar can also be a nightmare for users with many guests to thousands of events/Meets - sending thousands of new invitations to new versions of events is not a pleasant experience! Nevertheless, I'm hopeful I can find a solution, and I'll do some more work on it this week and let you know how I get on.

Also, I forgot to mention that it's currently impossible to automatically detect changes pulled into a Sheet as a result of a formula. Unfortunately the only way around this would be to update every event whether they have changed or not, or to store a shadow copy of every sheet to compare against... which might be fine for anyone with only a few hundred rows, but is very inefficient and will inevitably cause issues for large calendars.

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

[GCalToolkit]

Hi Israel, I've just released a big update which adds Automatic Import/Export without affecting formulas. I managed to work around not being able to use the "Update" column by first Importing changes to Google Calendar, then checking for differences between the updated Sheet and the Calendar before updating the Calendar. I am a little concerned that this might take too long to run as a trigger (without the user present)... but I'll never know if I don't try, so the new version should be live very soon if it isn't already.

You'll know you are using the new version as the menus have also changed - "Update Calendar from Sheet" is now "Export Sheet to Calendar". Please test it out and let me know how it performs!

[IMT1111]

Wow incredible, thanks so much, I'm going to start trying it and I let you know. So far I thought:

• The Check Sheet vs Calendar option doesn't detect if an event has been deleted in Sheets. It doesn't tick even the Update box. In this case, the columns C, D, E, F, G and N would be blank but Q and R wouldn't as an event was created before. It would be great if in this case, it would tick the Delete box so that event will be deleted.
• As the extension doesn't detect when changes are made as the result of the formula, only changes by editing cells manually, would it be possible when the automatic import/export to run first the Check Sheet vs Calendar so it detects the differences and tick the update box or delete box?

Please do not hesitate to contact me if you have any further questions. With best regards,

Israel Mendoza-Tellez

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify Israel Mendoza-Tellez. This message contains confidential information and is intended only for the individual named. You should not disseminate, distribute or copy this email. Please notify Israel Mendoza-Tellez immediately by email if you have received this email by mistake and delete this email from your system. You are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Thanks for your cooperation.

---

Esta comunicación contiene información que es confidencial y también puede contener información privilegiada. Este mensaje ha sido enviado por Israel Mendoza Téllez, única y exclusivamente para ser leído por el destinatario, quedando terminantemente prohibida cualquier distribución, copia, reenvío del mensaje, transcripción, grabación, fotografiado, o mención del contenido de esté mensaje con ninguna persona o medio. Si usted no es el destinatario/s, o aunque lo sea, tenga en cuenta que cualquier distribución, copia o uso de esta comunicación o la información que contiene está estrictamente prohibida. Si usted ha recibido esta comunicación por error por favor notifíquelo por correo electrónico o por teléfono y elimine el mensaje inmediatamente. Tenga en cuenta que pudiera darse el caso de que se emprendan acciones legales por incumplimiento de estas condiciones. Gracias por su colaboracion.

On Mon, 4 Sept 2023 at 23:31, GCalToolkit @.***> wrote:

Hi Israel, I've just released a big update which adds Automatic Import/Export without affecting formulas. I managed to work around not being able to use the "Update" column by first Importing changes to Google Calendar, then checking for differences between the updated Sheet and the Calendar before updating the Calendar. I am a little concerned that this might take too long to run as a trigger (without the user present)... but I'll never know if I don't try, so the new version should be live very soon if it isn't already. You'll know you are testing the new version as the menus have also changed - "Update Calendar from Sheet" is now "Export Sheet to Calendar". Please test it out and let me know how it performs!

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

[GCalToolkit]

You wrote "would it be possible when the automatic import/export to run first the Check Sheet vs Calendar". This is exactly what happens: the update boxes are not actually checked, but the events to be processed are those flagged by that option.

Deleted rows are the biggest problem since there is no way to detect these, and without the event ID the event can't be deleted from Google calendar anyway. The only solution I can see for this right now is a "hard export" which wipes the entire calendar and performs a full export... but that is extremely inefficient and would be a nightmare for events with guests/meets as guests would need to be reinvited for every event and the Meet IDs would change.

It's best for events to be deleted by manually checking the "Delete" column instead of deleting the row, although depending on the conditions for deleting your events I suppose it might be possible to use a formula for Delete column which sets it to TRUE if certain conditions are met - but that would open up another can of worms.

Alternatively, if your rows are somehow being automatically deleted I could add a mechanism to delete events with no title/start as long as they still have an event ID - that way you'd have to modify your row deletion to remove only titles and start date for events to be deleted.

[IMT1111]

Thanks so much for your message and the info.

• After checking the Automatic import/export I can confirm that it still writting in the sheet so it messes up the formulas. As a result the ARRAYFORMULA which I placed in cell C1, shows me the following error: "Array result was not expanded because it would overwrite data in C2." I think the most efficient solution is to separate this Automatic import/export into two separate options, one to automatic import and another to automatic export because as you said, the current option first import the calendar to the sheet, writing information on the sheet and messing the formulas up, and then tries to export what is left in the sheet to the calendar. I think the best thing is to leave the Automatic import of the calendar to Sheet as it was before, and add the new option: Automatic export sheet to calendar but not to merge both options.
• For deleting the events, when the event is deleted on the sheet, only the cells of the columns C, D, E, F, G and N are deleted (Title, Start, End, Start Time, End Time and Location) which means that Event ID, Link and the rest of info remains so the extension can still find the events in the calendar with their ID and link. The idea I have is that the extension would check the rows in which the columns C, D, E, F, G and N are blank but not the Event ID and Link, which means that an event was created in the past but it was deleted in the sheet. In this case, it should also delete the event in the calendar and clear the Event ID and Link cells. What do you think? Is it too difficult to do? The best thing would be for this option to be added to the Automatic export sheet to the calendar.

Thanks so much for everything

Please do not hesitate to contact me if you have any further questions. With best regards,

Israel Mendoza-Tellez

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify Israel Mendoza-Tellez. This message contains confidential information and is intended only for the individual named. You should not disseminate, distribute or copy this email. Please notify Israel Mendoza-Tellez immediately by email if you have received this email by mistake and delete this email from your system. You are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Thanks for your cooperation.

---

Esta comunicación contiene información que es confidencial y también puede contener información privilegiada. Este mensaje ha sido enviado por Israel Mendoza Téllez, única y exclusivamente para ser leído por el destinatario, quedando terminantemente prohibida cualquier distribución, copia, reenvío del mensaje, transcripción, grabación, fotografiado, o mención del contenido de esté mensaje con ninguna persona o medio. Si usted no es el destinatario/s, o aunque lo sea, tenga en cuenta que cualquier distribución, copia o uso de esta comunicación o la información que contiene está estrictamente prohibida. Si usted ha recibido esta comunicación por error por favor notifíquelo por correo electrónico o por teléfono y elimine el mensaje inmediatamente. Tenga en cuenta que pudiera darse el caso de que se emprendan acciones legales por incumplimiento de estas condiciones. Gracias por su colaboracion.

On Tue, 5 Sept 2023 at 09:25, GCalToolkit @.***> wrote:

You wrote "would it be possible when the automatic import/export to run first the Check Sheet vs Calendar". This is exactly what happens: the update boxes are not actually checked, but the event to be processed are those flagged by that option.

Deleted rows are the biggest problem since there is way to detect these, and without the event ID the event can't be deleted from Google calendar anyway. The only solution I can see for this right now is a "hard export" which wipes the entire calendar and performs a full export... but that is extremely inefficient and would be a nightmare for events with guests/meets as guests would need to be reinvited for every event and the Meet IDs would change. It's best for events to be deleted by either manually checking the "Delete" column, although depending on the conditions for deleting your events I suppose it might be possible to use a formula for Delete column which sets it to TRUE if certain conditions are met - but that would open up another can of worms.

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

[GCalToolkit]

Unfortunately it's not possible to split the automatic import/export because add-ons can only have a maximum of one timed trigger, per user, per document.

I've already double checked that the new version doesn't affects formulas, so I think it's possible there's a problem with the ARRAYFORMULA either trying to overwrite non-formula cell data, or returning blank cells. It's very hard to say without being able to see your Sheet and the formula, but it might be worth checking the section entitled "Blank cells challenge in Google Sheets ARRAYFORMULA output" here https://blog.coupler.io/arrayformula-google-sheets/.

Alternatively, you could use the standard formula method for each cell to avoid this issue.

For event deletes: I'll add a check for invalid title and start date with a valid event ID, and if that condition is met delete the event and the event ID. It's probably better to leave the rest of the row data intact for the user to clean up at their own convenience in case they used other custom columns or need to know which events were deleted.

[GCalToolkit]

Update submitted: when using Automatic Import/Export events will be deleted if a row has an event ID but no Title and Start Date, the event ID and HTML link will be removed, and the row's "Delete" cell will be coloured red. The menu option "Check Sheet vs Calendar" will also detect these rows and mark them for deletion.

[IMT1111]

Thanks for your message. But if we split the automatic import/export, as long as we use only one of the options, either import or export per document we would still be having only one trigger.

Ok I'm going to modify the sheets again and try with formulas in every single cell instead of ARRAYFORMULA. I will let you know. Thanks so much! Please do not hesitate to contact me if you have any further questions. With best regards,

Israel Mendoza-Tellez

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify Israel Mendoza-Tellez. This message contains confidential information and is intended only for the individual named. You should not disseminate, distribute or copy this email. Please notify Israel Mendoza-Tellez immediately by email if you have received this email by mistake and delete this email from your system. You are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Thanks for your cooperation.

---

Esta comunicación contiene información que es confidencial y también puede contener información privilegiada. Este mensaje ha sido enviado por Israel Mendoza Téllez, única y exclusivamente para ser leído por el destinatario, quedando terminantemente prohibida cualquier distribución, copia, reenvío del mensaje, transcripción, grabación, fotografiado, o mención del contenido de esté mensaje con ninguna persona o medio. Si usted no es el destinatario/s, o aunque lo sea, tenga en cuenta que cualquier distribución, copia o uso de esta comunicación o la información que contiene está estrictamente prohibida. Si usted ha recibido esta comunicación por error por favor notifíquelo por correo electrónico o por teléfono y elimine el mensaje inmediatamente. Tenga en cuenta que pudiera darse el caso de que se emprendan acciones legales por incumplimiento de estas condiciones. Gracias por su colaboracion.

On Wed, 6 Sept 2023 at 09:43, GCalToolkit @.***> wrote:

It's not possible to split the automatic import/export because add-ons can only have a maximum of one trigger of each type, per user, per document.

I've already double checked that the new version doesn't affects formulas, so I think it's possible there's a problem with the ARRAYFORMULA either trying to overwrite non-formula cell data, or returning blank cells. It's very hard to say without being able to see your Sheet and the formula, but it might be worth checking the section entitled "Blank cells challenge in Google Sheets ARRAYFORMULA output" here https://blog.coupler.io/arrayformula-google-sheets/.

Alternatively, you could use the standard formula method for each cell to avoid this issue.

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

[IMT1111]

Amazing, thanks for that update!!

Please do not hesitate to contact me if you have any further questions. With best regards,

Israel Mendoza-Tellez

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify Israel Mendoza-Tellez. This message contains confidential information and is intended only for the individual named. You should not disseminate, distribute or copy this email. Please notify Israel Mendoza-Tellez immediately by email if you have received this email by mistake and delete this email from your system. You are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Thanks for your cooperation.

---

Esta comunicación contiene información que es confidencial y también puede contener información privilegiada. Este mensaje ha sido enviado por Israel Mendoza Téllez, única y exclusivamente para ser leído por el destinatario, quedando terminantemente prohibida cualquier distribución, copia, reenvío del mensaje, transcripción, grabación, fotografiado, o mención del contenido de esté mensaje con ninguna persona o medio. Si usted no es el destinatario/s, o aunque lo sea, tenga en cuenta que cualquier distribución, copia o uso de esta comunicación o la información que contiene está estrictamente prohibida. Si usted ha recibido esta comunicación por error por favor notifíquelo por correo electrónico o por teléfono y elimine el mensaje inmediatamente. Tenga en cuenta que pudiera darse el caso de que se emprendan acciones legales por incumplimiento de estas condiciones. Gracias por su colaboracion.

On Wed, 6 Sept 2023 at 14:00, GCalToolkit @.***> wrote:

Update submitted: when using Automatic Import/Export events will be deleted if a row has an event ID but no Title and Start Date, the event ID and HTML link will be removed, and the row's "Delete" cell will be coloured red. The menu option "Check Sheet vs Calendar" will also detect these rows and mark them for deletion.

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

[GCalToolkit]

"if we split the automatic import/export, as long as we use only one of the options, either import or export per document we would still be having only one trigger."

I could add an option for each Sheet's "Automatic Import/Export" to choose between Import, Export, or both (and even in which order). I'll look into this over the next few days and let you know how I get on.

Thanks again for your feedback on this, it's thanks to users like yourself that my software keeps improving!

[IMT1111]

Thanks, soon you will have the best software of this type in the market!

I found the following issue:

-

It was a row with an event ID and Link but no Title, Start, Finish etc, I ran Export sheet to calendar and it didn’t delete the event. I ticked the Delete box manually and I ran Export sheet to calendar again and this time it deleted the whole row, whipping up all my formulas of the blank cells, but with formulas (C, D, E, F, G and N). The result of the formulas was nill but the cells had formulas. It should clear only the Event ID and Link, no the whole row, otherwise, it is going to mess everything up. This is what I mean from the beginning, if a user is interested only in Export sheet to calendar and working with formulas, the extension SHOULDN’T edit the columns C, D, E, F, G or N under NO CIRCUMSTANCES, otherwise, it will mess all the automatization up and it won’t be worthy using it. Otherwise in a sheet with many rows, we can't see if in a specific row, the formulas are missing unless we check one by one because visually we can only see when a cell is blank or has some info, but if we see them blank it should be because the result of the formula is nill but it could also be that the extension has wiped up the whole row. Do you understand what I mean?

Many thanks! Please do not hesitate to contact me if you have any further questions. With best regards,

Israel Mendoza-Tellez

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify Israel Mendoza-Tellez. This message contains confidential information and is intended only for the individual named. You should not disseminate, distribute or copy this email. Please notify Israel Mendoza-Tellez immediately by email if you have received this email by mistake and delete this email from your system. You are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Thanks for your cooperation.

---

Esta comunicación contiene información que es confidencial y también puede contener información privilegiada. Este mensaje ha sido enviado por Israel Mendoza Téllez, única y exclusivamente para ser leído por el destinatario, quedando terminantemente prohibida cualquier distribución, copia, reenvío del mensaje, transcripción, grabación, fotografiado, o mención del contenido de esté mensaje con ninguna persona o medio. Si usted no es el destinatario/s, o aunque lo sea, tenga en cuenta que cualquier distribución, copia o uso de esta comunicación o la información que contiene está estrictamente prohibida. Si usted ha recibido esta comunicación por error por favor notifíquelo por correo electrónico o por teléfono y elimine el mensaje inmediatamente. Tenga en cuenta que pudiera darse el caso de que se emprendan acciones legales por incumplimiento de estas condiciones. Gracias por su colaboracion.

On Thu, 7 Sept 2023 at 07:22, GCalToolkit @.***> wrote:

"if we split the automatic import/export, as long as we use only one of the options, either import or export per document we would still be having only one trigger."

I could add an option for each Sheet's "Automatic Import/Export" to choose between Import, Export, or both (and even in which order). I'll look into this over the next few days and let you know how I get on.

Thanks again for your feedback on this, it's thanks to users like yourself that my software keeps improving!

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

[GCalToolkit]

When exporting manually the "Delete" checkbox must be checked (either manually or by using "Check Sheet vs Calendar") to delete a row. If you want to preserve row data and formulas you would also need to enable the option "Keep row data for deleted events" before you export.

When using Automatic Import/Export that event would have been detected by running "Check Sheet vs Calendar" and ONLY the event ID and HTML link would be deleted, just as if you had checked the option to "Keep Row Data...". What I can do is set the default to be "Keep Rows" even when deleting manually.

I'm making progress on an option to either "Import", "Export", "Import ->Export" or "Export -> "Import" so that should be ready soon, although it will take some testing before I update.

[GCalToolkit]

Testing went better than expected... the latest version let's you choose a sync option for each Sheet, and defaults to Import>Export for existing settings. It also defaults to keep all formulas intact unless you sync manually and specify not to keep the deleted rows. There are some other improvements too so let me know how you get on. The biggest problem now is likely to be Google's restrictions - there's no way around those so I do expect problems with large Sheets/Calendars with too many sheets syncing.

[IMT1111]

Sorry I couldn't reply to you before, I have been so busy and with the last update something was messed up and so many events that were on the sheet disappeared from the calendar, and when exporting to the calendar those events were still missing and it was showing me a message saying like it couldn't find those events. I deleted everything and exported again. I'm going to try your last update and I will let you know.

Please do not hesitate to contact me if you have any further questions. With best regards,

Israel Mendoza-Tellez

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify Israel Mendoza-Tellez. This message contains confidential information and is intended only for the individual named. You should not disseminate, distribute or copy this email. Please notify Israel Mendoza-Tellez immediately by email if you have received this email by mistake and delete this email from your system. You are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Thanks for your cooperation.

---

Esta comunicación contiene información que es confidencial y también puede contener información privilegiada. Este mensaje ha sido enviado por Israel Mendoza Téllez, única y exclusivamente para ser leído por el destinatario, quedando terminantemente prohibida cualquier distribución, copia, reenvío del mensaje, transcripción, grabación, fotografiado, o mención del contenido de esté mensaje con ninguna persona o medio. Si usted no es el destinatario/s, o aunque lo sea, tenga en cuenta que cualquier distribución, copia o uso de esta comunicación o la información que contiene está estrictamente prohibida. Si usted ha recibido esta comunicación por error por favor notifíquelo por correo electrónico o por teléfono y elimine el mensaje inmediatamente. Tenga en cuenta que pudiera darse el caso de que se emprendan acciones legales por incumplimiento de estas condiciones. Gracias por su colaboracion.

On Thu, 7 Sept 2023 at 14:33, GCalToolkit @.***> wrote:

When exporting manually the "Delete" checkbox must be checked (either manually or by using "Check Sheet vs Calendar") to delete a row. If you want to preserve row data and formulas you would also need to enable the option "Keep row data for deleted events" before you export.

When using Automatic Import/Export that event would have been detected by running "Check Sheet vs Calendar" and ONLY the event ID and HTML link would be deleted, just as if you had checked the option to "Keep Row Data...". What I can do is set the default to be "Keep Rows" even when deleting manually.

I'm making progress on an option to either "Import", "Export", "Import ->Export" or "Export -> "Import" so that should be ready soon, although it will take some testing before I update.

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

[IMT1111]

Good evening, How are you? I hope you are well. The automatic Export is not happening. I settled it up a few times and when I don't see the events exported I go and check it, and I see like the automatic Export wasn't settled up, I set up again and when I go to check later I see again the same message: You are not currently syncing this Sheet. It is quite strange

[image: image.png]

Many thanks! Please do not hesitate to contact me if you have any further questions. With best regards,

Israel Mendoza-Tellez

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify Israel Mendoza-Tellez. This message contains confidential information and is intended only for the individual named. You should not disseminate, distribute or copy this email. Please notify Israel Mendoza-Tellez immediately by email if you have received this email by mistake and delete this email from your system. You are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Thanks for your cooperation.

---

Esta comunicación contiene información que es confidencial y también puede contener información privilegiada. Este mensaje ha sido enviado por Israel Mendoza Téllez, única y exclusivamente para ser leído por el destinatario, quedando terminantemente prohibida cualquier distribución, copia, reenvío del mensaje, transcripción, grabación, fotografiado, o mención del contenido de esté mensaje con ninguna persona o medio. Si usted no es el destinatario/s, o aunque lo sea, tenga en cuenta que cualquier distribución, copia o uso de esta comunicación o la información que contiene está estrictamente prohibida. Si usted ha recibido esta comunicación por error por favor notifíquelo por correo electrónico o por teléfono y elimine el mensaje inmediatamente. Tenga en cuenta que pudiera darse el caso de que se emprendan acciones legales por incumplimiento de estas condiciones. Gracias por su colaboracion.

On Fri, 8 Sept 2023 at 00:23, GCalToolkit @.***> wrote:

Testing went better than expected... the latest version let's you choose a sync option for each Sheet, and defaults to Import>Export for existing settings. It also defaults to keep all formulas intact unless you sync manually and specify not to keep the deleted rows. There are some other improvements too so let me know how you get on. The biggest problem now is likely to be Google's restrictions - there's no way around those so I do expect problems with large Sheets/Calendars with too many sheets syncing.

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

[GCalToolkit]

When you have set up automatic syncing for a Sheet and refresh the page, close the sidebar etc. and open it again, does it still say the sheet is set to sync? Or does the list empty out only after the time for which syncing was set?

If you visit this page it should show all the triggers that you have set up (or which scripts like Sheets2GCal have set up for you): https://script.google.com/home/triggers

Is a "Timed Trigger" listed there after you set it up in Sheets2GCal? And is there anything listed under "Executions" at https://script.google.com/home/executions ?

[IMT1111]

Yes even if I close the sidebar and open it again, the automatic sync is not longer active. Same if I refresh. Even if I move to another sheet in the same google sheet doc, when I come back to the same sheet the automatic sync is not longer active. I can see some Timed Trigger not not exactly in the moment I set it up

With best regards,

Israel Mendoza-Tellez

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify Israel Mendoza-Tellez. This message contains confidential information and is intended only for the individual named. You should not disseminate, distribute or copy this email. Please notify Israel Mendoza-Tellez immediately by email if you have received this email by mistake and delete this email from your system. You are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Thanks for your cooperation.

---

Esta comunicación contiene información que es confidencial y también puede contener información privilegiada. Este mensaje ha sido enviado por Israel Mendoza Téllez, única y exclusivamente para ser leído por el destinatario, quedando terminantemente prohibida cualquier distribución, copia, reenvío del mensaje, transcripción, grabación, fotografiado, o mención del contenido de esté mensaje con ninguna persona o medio. Si usted no es el destinatario/s, o aunque lo sea, tenga en cuenta que cualquier distribución, copia o uso de esta comunicación o la información que contiene está estrictamente prohibida. Si usted ha recibido esta comunicación por error por favor notifíquelo por correo electrónico o por teléfono y elimine el mensaje inmediatamente. Tenga en cuenta que pudiera darse el caso de que se emprendan acciones legales por incumplimiento de estas condiciones. Gracias por su colaboracion.

On Thu, 14 Sept 2023 at 23:26, GCalToolkit @.***> wrote:

When you have set up automatic syncing for a Sheet and refresh the page, close the sidebar etc. and open it again, does it still say the sheet is set to sync? Or does the list empty out only after the time for which syncing was set?

Even you visit this page it should show all the triggers they you have set up (or which scripts like Sheets2GCal have set up for you): https://script.google.com/home/triggers

Is a "Timed Trigger" listed there after you set it up in Sheets2GCal?

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

[GCalToolkit]

Thanks for that information - when you wrote " I can see some Timed Trigger not exactly in the moment I set it up" did this mean there is already a trigger listed at https://script.google.com/home/triggers? If so, can you click the menu for that trigger and delete it, then try to set it up again in Sheets2GCal?

Also, if you create a new spreadsheet document with a new sheet connected to Google Calendar, does it suffer from the same problem?

[IMT1111]

Good morning, I hope you are well. I created a new spreadshet and it seems to be working fine now thanks to all your updates. Just if I change the name of a calendar in google calendar, it doesn't reflect this change in your extension so it can be a bit confusing sometimes.Thanks so much for all!

Israel Mendoza-Tellez

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify Israel Mendoza-Tellez. This message contains confidential information and is intended only for the individual named. You should not disseminate, distribute or copy this email. Please notify Israel Mendoza-Tellez immediately by email if you have received this email by mistake and delete this email from your system. You are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Thanks for your cooperation.

---

Esta comunicación contiene información que es confidencial y también puede contener información privilegiada. Este mensaje ha sido enviado por Israel Mendoza Téllez, única y exclusivamente para ser leído por el destinatario, quedando terminantemente prohibida cualquier distribución, copia, reenvío del mensaje, transcripción, grabación, fotografiado, o mención del contenido de esté mensaje con ninguna persona o medio. Si usted no es el destinatario/s, o aunque lo sea, tenga en cuenta que cualquier distribución, copia o uso de esta comunicación o la información que contiene está estrictamente prohibida. Si usted ha recibido esta comunicación por error por favor notifíquelo por correo electrónico o por teléfono y elimine el mensaje inmediatamente. Tenga en cuenta que pudiera darse el caso de que se emprendan acciones legales por incumplimiento de estas condiciones. Gracias por su colaboracion.

On Fri, 15 Sept 2023 at 00:11, GCalToolkit @.***> wrote:

Thanks for that information - when you wrote " I can see some Timed Trigger not exactly in the moment I set it up" did this mean there is already a trigger listed at https://script.google.com/home/triggers? If so, can you click the menu for that trigger and delete it, then try to set it up again in Sheets2GCal?

Also, if you create a new spreadsheet document with a new sheet connected to Google Calendar, does it suffer from the same problem?

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

[GCalToolkit]

Hi Israel, I'm glad to hear that's all working - I'll fix the calendar name issue in the next update so it doesn't default to the original calendar name.

[IMT1111]

Great, thank you so much

On Sat, 23 Sept 2023, 12:01 GCalTools, @.***> wrote:

Hi Israel, I'll glad to hear that's all working - I'll fix the calendar name issue in the next update so it doesn't default to the original calendar name.

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

[GCalToolkit]

This update should be active in the next few hours - calendars will now always use their latest display names, and any changes to the calendar names in Google Calendar will be reflected in Sheets2GCal as soon as you reopen the sidebar. Read-only calendars are now marked with **

[IMT1111]

Awesome, thanks for the update!

On Sun, 24 Sept 2023, 12:09 GCalTools, @.***> wrote:

This update should be active in the next few hours - calendars will now always use their latest display names, and any changes to the calendar names in Google Calendar will be reflected in Sheets2GCal as soon as you reopen the sidebar. Read-only calendars are now marked with **

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

[GCalToolkit]

My pleasure - one question if I may... I've been contacted by a user who is having trouble using formulas to pull data from other sheets. Do you do this and do you have any problems with that?

[IMT1111]

Yes this is what i do

On Mon, 25 Sept 2023, 07:47 GCalTools, @.***> wrote:

My pleasure - one question if I may... I've been contacted by a user who is having trouble using formulas to pull data from other sheets. Do you do this and do you have any problems with that?

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

[IMT1111]

It seems yo be working fine now thanks to all the improvements you made.

On Mon, 25 Sept 2023, 07:47 GCalTools, @.***> wrote:

My pleasure - one question if I may... I've been contacted by a user who is having trouble using formulas to pull data from other sheets. Do you do this and do you have any problems with that?

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