Problems with the syncronization #28
Comments
|
I'll look into this today and let you know what I find ASAP. Thanks for letting me know! |
|
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
<#28 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/BCDRFFWHILJKRI32WU6F5VLXW4MMJANCNFSM6AAAAAA34SNPIQ>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
|
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
<#28 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/BCDRFFWHILJKRI32WU6F5VLXW4MMJANCNFSM6AAAAAA34SNPIQ>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
|
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. |
|
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? |
|
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
<#28 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/BCDRFFT6U37UEKLEQR6MK2DXXIZ4LANCNFSM6AAAAAA34SNPIQ>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
|
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 ? |
|
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
<#28 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/BCDRFFRVTTXP7YZJEH4ADQDXXJLWLANCNFSM6AAAAAA34SNPIQ>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
|
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
<#28 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/BCDRFFRVTTXP7YZJEH4ADQDXXJLWLANCNFSM6AAAAAA34SNPIQ>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
|
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
<#28 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/BCDRFFTEFXWKVDVQEIPFJNDXXBU67ANCNFSM6AAAAAA34SNPIQ>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
|
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. |
|
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
<#28 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/BCDRFFWCSOGQBJZN77IQD53XX4EWTANCNFSM6AAAAAA34SNPIQ>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
|
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. |
|
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
<#28 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/BCDRFFQ3KLEMZRL35OOYIDLXX5HQXANCNFSM6AAAAAA34SNPIQ>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
|
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. |
|
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
<#28 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/BCDRFFQ6U6WQMAYGZN5QJG3XX5MSXANCNFSM6AAAAAA34SNPIQ>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
|
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! |
|
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
<#28 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/BCDRFFXJIIG74VX7X36TOGTXYZJFXANCNFSM6AAAAAA34SNPIQ>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
|
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. |
|
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
<#28 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/BCDRFFRA4SOMN7CWG3O7JWDXY3OYZANCNFSM6AAAAAA34SNPIQ>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
|
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. |
|
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. |
|
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
<#28 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/BCDRFFWTXHIIWIPHUREQFILXZAZSXANCNFSM6AAAAAA34SNPIQ>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
|
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
<#28 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/BCDRFFQEYUE266HEBY574NLXZBXWJANCNFSM6AAAAAA34SNPIQ>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
|
"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 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! |
|
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
<#28 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/BCDRFFXCCVM6AMANFPMRDYDXZFR3DANCNFSM6AAAAAA34SNPIQ>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
|
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. |
|
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. |
|
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
<#28 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/BCDRFFWU6AN3VB6VNQRXNFDXZHEKPANCNFSM6AAAAAA34SNPIQ>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
|
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
<#28 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/BCDRFFVP7KMXKPM2SPAOJ5TXZJJPVANCNFSM6AAAAAA34SNPIQ>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
|
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): 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 ? |
|
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
<#28 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/BCDRFFVLD7EYLAFCYC4FUI3X2OAAXANCNFSM6AAAAAA34SNPIQ>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
|
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? Also, if you create a new spreadsheet document with a new sheet connected to Google Calendar, does it suffer from the same problem? |
|
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
<#28 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/BCDRFFVQHY2GDQJSDBEAI7LX2OFJHANCNFSM6AAAAAA34SNPIQ>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
|
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. |
|
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
<#28 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/BCDRFFRFQPJAB73UFPYBZ5DX326PNANCNFSM6AAAAAA34SNPIQ>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
|
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 ** |
|
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
<#28 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/BCDRFFUZ7NTNHDTTMKJD5DLX4AIGBANCNFSM6AAAAAA34SNPIQ>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
|
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? |
|
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
<#28 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/BCDRFFUKY5GBP46A4PIO6ALX4ESGRANCNFSM6AAAAAA34SNPIQ>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
|
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
<#28 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/BCDRFFUKY5GBP46A4PIO6ALX4ESGRANCNFSM6AAAAAA34SNPIQ>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
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
The text was updated successfully, but these errors were encountered: