I use Apps Script for a custom function in my Spreadsheet. This fetches an URL with the Amazon Acces Key. The problem is, that i use this function in alot of cells, but Amazon doesnt let me fetch that often. Is there a way, that i can let my function only work after another function is over? To explain it a bit better an example:
The function starts in Cell A2. when this is over the spreadsheet w8 1 sec and then starts the function in cell A3. and so on.
This way the function will ony be active alone. But that should not only work for one Spreadsheet, but every Spreadsheet i use this in.
I tried the sleep function but that doesnt affect multiple active functions.
Ty for your help!
Aucun commentaire:
Enregistrer un commentaire