Script stopped working in the sheet with multiple users

[Mert Erarslan]

Hello all,

I have tried to find a similar thread which covered the issue but could not find one. Apologies if it's been discussed before.

I have implemented a simple code on the following link which timestamps a cell whenever the cell next to it gets updated into the different sheets.

https://spreadsheetpoint.com/insert-timestamps-in-google-sheets/#:~:text=Keyboard%20Shortcut%20to%20Insert%20TimeStamp,-If%20you%20want&text=Control%20%2B%20Shift%20%2B%20%3A%20(hold,time%20values%20will%20not%20change.

On the first sheet which is only used by me and which is basically a copy of the second one, it is still working without a problem. However on the second sheet with multiple users, it stopped working after a while.

Does anyone have any idea why this might have happened?

Thanks in advance.

Best,

Mert

[Clark Lind]

The only obvious things I would check is make sure the tab name is still the same, and also make sure no new columns have been inserted or anything. If it is running ok on your Tab, but not the other, is the script looking for both Tabs or just one? 

Those are the obvious things that come to mind.

[Mert Erarslan]

Hello,

Thank you for your reply.

I have two separate sheets. One is the copy of the other. The copy is used just by me and the script still works fine on it. The one on the sheet with multiple users stopped working after a while ( a day?). I have deleted the file in apps script and introduced a new one with the exact same code and it started working again only to stop again after a while. I would say it must have some kind of a time expiry condition but the fact that it still works on the copied sheet suggests otherwise.

Thanks for your feedback.

[Clark Lind]

I has the feel of a permissions problem. Does it work for others on the other sheet and then stop? Or does it stop working for you? Are you the owner of the other sheet or just an editor/viewer? Your copy will always run since you are the owner. But others in the other sheet may still need to authorize the script to run. Just some thoughts...

[Amélie Cheatham]

Hi Mert,

I just discovered the same issue here. Have you been able to find a solution by any chance? Thanks!

[Mert Erarslan]

Hello Amelie,

It just stopped/started working again a few times more for no reason, so I figured it wasn't something to do with the authorization. I came to the conclusion that it was maybe something to do with the sheet being too big and having an enormous number of rows/comuns. For that reason we are going manual now.

I am sorry I couldn't be of any help.

Best,

Mert

"Responsible, Respectful, Safe, Productive"

P Please consider the environment before printing this email.

Statement of Confidentiality: The contents of this e-mail message and any attachments are intended solely for the addressee. The information may also be confidential and/or legally privileged. This transmission is sent for the sole purpose of delivery to the intended recipient. If you have received this transmission in error, any use, reproduction, or dissemination of this transmission is strictly prohibited. If you are not the intended recipient, please immediately notify the sender by reply e-mail and delete this message and its attachments, if any.

E-mail is covered by the Electronic Communications Privacy Act, 18 USC SS 2510-2521 and is legally privileged

--
You received this message because you are subscribed to a topic in the Google Groups "Google Apps Script Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-script-community/erKsI-rh0aM/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/b5a7d6bb-df0f-4c0f-a41f-0f2d5aaf0b21n%40googlegroups.com.

[Will Chung]

This happened to me as well. I deployed the linear interpolation formula below in Apps Script and it was working just fine, but then stopped working after a few weeks and now produces the following error: "Error Unknown function: 'linear_interpolation'." I checked that the script was still deployed and it was so I'm not sure why it stopped working.

When I created a copy of the worksheet, which, when doing so, asked to create a copy of the Apps Script that was deployed in the previous sheet, it was working again in the copy of the sheet.

function LINEAR_INTERPOLATION(x, x25, P25, x75, P75) { return P25 + ((P75 - P25) / (x75 - x25)) * (x - x25); }

Anyone else seeing this and any tips on how to prevent or troubleshoot?

[Will Chung]

Update on this -- 

When I actually enter a value in the worksheet that causes the linear interpolation Apps Script to run, it starts working again and the error goes away. How odd. Is anyone else seeing this or can give me any pointers on how to avoid this in the future?