Google Sheets – Why do I get the error: too many simultaneous invocations in a simple trigger once a day?

I searched and still can not find anything directly related to the error message I'm receiving. The script has not changed and it used to run fine, but now, more or less, last week is failing more and more. There are only 3 triggers in this file onOpen, onEdit (e) and the installed trigger that calls the percentChange function once a day in the morning. It's super simple, it takes 2 named ranges, one is a column of percentages and the other contains the length of that data and then copies the percentages into another column so we can track the daily percentage difference.

Here is the code:

percentChange () {function
var ss = SpreadsheetApp.getActiveSpreadsheet (). getSheetByName (& # 39; Overview Status & # 39;);

var calcPercentRangeObject = ss.getRange (& # 39; calcPerc & # 39;);
var calcPercentRow = calcPercentRangeObject.getRow () + 2;
var calcPercentColumn = calcPercentRangeObject.getColumn ();

var dataRangeObject = ss.getRange (& # 39; numCabs & # 39;);
var dataRow = dataRangeObject.getRow () + 2;
var dataColumn = dataRangeObject.getColumn ();
var dataLength = dataRangeObject.getValue ();
var currentPercent = ss.getRange (calcPercentRow, calcPercentColumn, dataLength, 1) .getValues ​​();

ss.getRange (dataRow, dataColumn, dataLength, 1) .setValues ​​(currentPercent);


Should I add a delay? That seems to be a "janky" solution …

Last failure

Faults and previous terminations.

Another question: why does this code take more than 10 seconds to run from the trigger, but it usually takes less than a second to run from the script editor?

api – Is it wrong to leave the Azure secret keys as simple text in my source code if I do not release the code, only the exe?

Yes, anyone can easily find the key.

The simplest method would be to use .net development tools (available for free download from Microsoft) that contain a decompiler. Point the decompiler to the program and look for strings, not many will be seen as keys …

If that fails because you were a smart cookie and you encrypted the key. They could still search for real calls using a proxy dll or http requests. Somewhere you have to deliver the key in plain text … Then you can trace it to the encrypted key, and the key and the decryption algorithm.

Making it safe

Do not pass your subscription …

Option 1: Require the user to have their own subscription and request their password instead.

Option 2: Implement a broker server in your own host / cloud. Re-write your application to make requests against this API, use the account / service control you want. Once you have verified (in the broker) that the user is legitimate, the broker makes the request for Azure itself and returns the results to his client.

Why this simple simple makefile will not work?

I have two files: C Main

int main (void)
returns 0;

Y testmake.make

all: test.exe

test.exe: main.o
gcc -o test.exe main.o

main.o: main.c
gcc -c main.c

rm main.o test.exe

I am invoking to do so … make -f testmake.make all

And I am receiving this error:

make -f testmake.make all
gcc -c main.c
process_begin: CreateProcess ((null), gcc -c main.c, ...) failed.
make (e = 2): The system can not find the specified file.

do: *** [main.o] Error 2
"make -f testmake.make all" ended with the exit code 2. The compilation might be incomplete.

How to save the simple wav fileCaptcha in java

I need to save the file to play the Simplecaptcha voice file in IOS and I have managed to save the file in the folder I want.
But I tried to play the wav file in the folder (double click), it was not played again.
please help

public static void saveAudio (final request from HttpServletRequest, final response from HttpServletResponse, final sample shows) {

                String fileName = request.getParameter ("fileName");
try {

ByteArrayOutputStream final baos = new ByteArrayOutputStream (1024);
AudioSystem.write (sample.getAudioInputStream (), AudioFileFormat.Type.WAVE, baos);

byte audioData[] = baos.toByteArray ();

AudioFormat af = new AudioFormat (16000.0F, 16, 1, true, false); // default configuration of simplecaptcha
ByteArrayInputStream bais = new ByteArrayInputStream (audioData);
AudioInputStream ais = new AudioInputStream (bais, af, audioData.length);
AudioSystem.write (ais, AudioFileFormat.Type.WAVE, new file ("/ audio /" + fileName + ".wav"));

} capture (IOException e) {
System.out.println (e);


html5 – Should simple games require instructions?

Are you a test player who has trouble discovering controls or using them?

If you have trouble discovering them, you can add a notice explaining them. So that it is not intrusive for players who do not need it, you can make it appear if the player is left without doing anything.

Which brings me to the next thing: probably all of your game needs are a practice / creative / free mode, where players feel free to experiment with the controls without any pressure. That will get them used to the controls in case the trobule uses them and does not discover them.

While a game can do well without instructions or tutorials, it could help you reach more people (because not everyone is familiar with experimentation without an example or guidance).

In general, I would say that you should let the player configure the controls. However, I admit that that does not make sense for all the games and input devices. That said, consider if you need sensitivity options.

There is also an argument to allow a simpler control scheme that allows players struggling to win the game (a kind of assistance mode, you can let the player know that it is not the intended way to play, but you can allow it). to enjoy the game anyway if they have problems). And this can be implemented without loss of depth if full controls are required to obtain higher scores.

Python – Simple registry rotation script

I have created a simple script that implements the registry rotation. I am not a Python programmer, although this language seems extremely useful for this type of task. I would like my code to be as idiomatic as possible, so what can I change / improve in my script for this?

of os import listdir
from os.path import getetsize, there is
from shutil import copyfile
from argparse import ArgumentParser

SIZE_5MB = 5e6

LogRotator class (object):
def __init __ (auto, prefix, suffix):
auto.prefix = prefix
self.suffix = suffix

def __str __ (self):
he came back  "{}[x]. {} ". format (self.suffix, self.prefix)

def __touch (auto, file_name):
open (file_name, & # 39; w & # 39;). close ()

def rotate (self):
files = ["{}{}.{}".format(self.prefix, x + 1, self.suffix) for x in range(MAX_LOG_FILES_COUNT)]

        [self.__touch(f) for f in files if not exists(f)]




        current_log = "{}. {}". format (self.prefix, self.suffix)
if (getsize (current_log) <SIZE_5MB):
he came back

files.insert (0, current_log)

for i in range (len (files) - 1, 0, -1):
Copy file (files[i-1]records[i])

auto .__ touch (files[0])

yes __name__ == & # 39; __ main __ & # 39;
parser = ArgumentParser (description = "Rotate log files")
parser.add_argument ("- prefix", help = "prefix of the log file")
parser.add_argument ("- suffix", help = "record file suffix")

args = parser.parse_args ()

logRotator = LogRotator (args.prefix, args.suffix)
logRotator.rotate ()

Simple chat web application idea


The idea is to get a fully functional chat application that uses no more than a text file on a server, AJAX and localStorage.

This is my idea:

Simple chat application

Https connection
Server: text file.

Ajax to update the text file.

When sending, execute a function.


  • Cancel the contents of the text file.
  • Pull the content of the text file on the web page.
  • Store the content in localStorage.

Would this work?


Classification forum images – Simple translucent (FREE)

To download simply check the attached file below or visit the mrdangem blog.

I hope you like it! Please post your comments here or share my blog. It really means a lot to me.


Entities: How do I obtain a list of simple text labels from a multiple-valued entity reference field in Drupal 8?

I have a module that is making custom RSS feeds for me.

In a content type, I have my labels stored in the reference field of the "field_tags" entity.

My objective is to obtain the names of all the labels and, finally, to place them in a matrix, so that they can enter an RSS field without marks.

When I'm pulling the data, I get it with this:

foreach ($ this-> dbh-> selectVideos (self :: RPP) as $ nid) {
$ node = $ this-> entityMgr-> getStorage (& # 39; node & # 39;) -> load ($ nid);

if (! empty ($ node)) {
$ data-> nodes[] = [
      'title'    => $this->filterTxt($node->title->value),
      'body'     => $this->filterTxt($node->get('field_paragraph')->value),
      'body2'     => $this->filterTxt($node->get('field_paragraph')->value),
      'created'  => date('D, d M Y H:i:s', $node->created->value) . ' GMT',
      'guid'     => $node->id(),
      'img'      => $this->getImgUrl($node, self::IMG_FIELD),
      'keywords' => $this->filterTxt($node->get('field_tags')->value),
      'video'    => $node->get('field_vid_url')->getString(),
returns $ this-> render ($ data, & # 39; nameoffeed & # 39;);


The problem is that & # 39; field_tags & # 39; it is an entity reference field, so it is blank.

I had partial success with this:

                if ($ node-> hasField (& # 39; field_tags & # 39;)) {
$ entity_ref = $ node-> get (& # 39; field_tags & # 39;);
if ($ entity_ref-> count ()> 0) {
$ tagoutput = entity_view ($ entity_ref-> entity, & # 39; default & # 39;);

Then configuring & # 39; keywords & # 39; to equal $ tagoutput. This captures the first label, which is not very good, since I need it all, and then, along with it, comes an entire html design enclosure that does not work for an RSS feed.

I am confused about what is the correct way to get a proper list of tag names. On D6, I had this list as plain text, which was not very good because I could not click on one of the views on the page and move to a list of all the pages with that label, but at least the tags worked. It feeds easily.

Any ideas?

Errors: Does Mathematica 12 have gotten worse when solving simple equations?

Mathematica used to be able to easily solve an equation like this:

Reduce[Log[Sqrt[k p]/Log in[k]]== 0, p]

(I can easily do it myself, at least I can find the solution p = log (k) ^ 2 / k.)

Now in Mathematica 12, I get Reduce :: nsmet: this system can not be resolved with the methods available to Reduce.

I thought it could be a problem with the assumptions, so I tried to take both k Y P They were big enough, but it did not help.

Is there any way to make Mathematica 12 produce useful results in the previous problem?