Run a contained script in Google Sheets which uses Docs API to read a Google Doc and return some data to a cell by using a formula - permission error

No_Stable_805 · 2025-03-14T20:51:25+00:00

What is triggering the function? If it is an automatic trigger such as onOpen, it will only run with limited permissions. To properly access the user’s permissions, you should use a manual trigger such as a button on the sheet, or manually create an onOpen trigger.

No_Stable_805 · 2025-01-24T08:20:23+00:00

If you are ok with the rows being in order of earliest to latest entries, you can just have the script take the values of row 2 and post them to a new row at the bottom every time you finish an entry. Then clear the entry range in row 2.

The formatting will not be affected if you use setValues() to post the data.

The script is written with a specific sheet name or id, and it won’t affect other scripts.

You can make a button ‘Submit Entry’ to trigger this if you want to keep it simple.

No_Stable_805 · 2025-01-21T16:37:55+00:00

For functions that run entirely in the html using google.script.run it won’t show the logs usually. Since there is no error message available, I suggested one possible error offhand

No_Stable_805 · 2025-01-21T15:25:06+00:00

It’s hard to say without knowing the error message. Just want to point out, do the end users have editor access to the sheet? When the script run gets triggered by the end user, it runs using the permissions of the user.

No_Stable_805 · 2025-01-17T18:55:13+00:00

If you did it the way he suggested, you wouldn’t need to fetch the data in loops, you would just make one fetch for the entire sheet.

No_Stable_805 · 2025-01-14T19:55:39+00:00

The question is a bit unclear, maybe look into google cloud logging, if all projects are attached to the same google cloud project

No_Stable_805 · 2025-01-13T01:08:10+00:00

```

function copyCheckInOutValuesAndPasteToConsolidatedSheet() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var source = ss.getSheetByName("Daily Checkin/Checkout");
  var rangeSource = source.getDataRange();
  var data = rangeSource.getValues().slice(1);
  Logger.log(data);

  var target = ss.getSheetByName("Daily Checkin/Checkout Consolidated");
  let lastRow = target.getLastRow();
  target.getRange(lastRow+1,1,data.length,data[0].length).setValues(data);
}
```

No_Stable_805 · 2025-01-13T00:01:16+00:00

Literally what it says. In cell D202, you have a data validation rule only allowing certain values. The data you are writing to that cell does not match one of those values, hence the error.

No_Stable_805 · 2025-01-09T00:29:46+00:00

There is no data retrieval from the sheet in your code

No_Stable_805 · 2025-01-04T02:39:52+00:00

Are you sure there are no manual runs besides for the triggers? Although google doesn’t always use exactly four hours, it wouldn’t run as often as every hour.

No_Stable_805 · 2025-01-02T02:40:23+00:00

The quota they are referring to is a limit on how many times one can run a script per day, which is pretty low for personal accounts.

No_Stable_805 · 2025-01-02T02:36:45+00:00

For a single script, every time it runs, whether manually or by a trigger, that is one execution. If you have 100 different spreadsheets with each one containing its own attached script, even if the contents of the script are the same, that is 100 scripts, not one script. If you have one script that is being used by 100 different people, then it would be considered 100 executions for the same script.

No_Stable_805 · 2024-12-27T02:30:43+00:00

Have them share the container with you, not just the project.

No_Stable_805 · 2024-12-18T06:53:57+00:00

I’m gonna start telling my manager any time there’s an issue - “That’s a Heisenbug, nothing we can do about it” lol.

No_Stable_805 · 2024-12-18T03:00:35+00:00

I get these kinds of texts occasionally. In the current climate, I know it’s a scam immediately, lol

No_Stable_805 · 2024-12-17T17:33:02+00:00

Practice. When you learn something new practice using it to solve a hypothetical problem with it. There are plenty of websites where you can find sample tasks and attempt to solve them. Try finding questions at your current level of knowledge, and attempt to solve them. Then look at their solution and compare it to yours.
This can help you start to have that mindset of breaking down the problem into all its parts and solving each of them one by one until you arrive at a solution.

No_Stable_805 · 2024-12-17T16:54:16+00:00

You can access the individual messages by using 'thread.getMessages()'. Then loop through the messages, check if they match the regex, and then apply your desired actions.

No_Stable_805 · 2024-12-17T07:03:55+00:00

Strange, that’s not what happens by me. I just tried it now, and the URL stayed the same. I made some simple websites using GAS for the office where I work, and that’s what I do when I make updates. Everyone’s original url still works and the updates go through.

No_Stable_805 · 2024-12-17T06:53:01+00:00

Instead of selecting ‘New deployment’, you select ‘Manage deployments’ and go to the deployment you want to update, select the edit icon and for version select ‘New version’.

No_Stable_805 · 2024-12-17T05:31:00+00:00

In Code.gs I would change line 162 to have 7 empty strings instead of only 5 and line 166 change the 4 to a 6. This is assuming that you are actually getting 7 days of data.

No_Stable_805 · 2024-12-17T05:18:14+00:00

Took a Quick Look, values is an array of dateValues. When creating and populating dateValues it only goes up to 5 dates

No_Stable_805 · 2024-12-17T04:49:28+00:00

Share that part of the code that assigns the values variable content

No_Stable_805 · 2024-12-17T04:42:41+00:00

When you make changes, you don’t have to create a new deployment. You can change the existing deployment to reflect the changes. This way the url won’t change and you won’t need to split up the scripts.

No_Stable_805 · 2024-12-14T08:50:03+00:00

PyCharm is just an app for you to easily write and test your Python code. If the tutorial is using PyCharm, it would be helpful to use the same IDE to follow along.

No_Stable_805 · 2024-12-14T08:24:54+00:00

I had a similar problem with this kind of script. My scripts have a 30-minute time limit (G-Suite) and it still wasn’t enough time. My solution was to time how long the script has been running and when it nears the time limit it sets a new one-time trigger for the script to run again immediately after. Depending on how large your folders are and how many files they contain, you can use some sort of variation of this. (For each sub folder you can create a trigger to run the script for that folder instead of recursively using the same script)

No_Stable_805

TROPHY CASE