I have script that works fine as editor add-on but when I am testing as workspace add-on (as a stand alone appscript) the functions takes too long to run, it does what actually planned, but gives error at the end (run time error).
Planning to keep record of made invoice. i would like to get the range values from Invoicing sheet and paste it as a row without a gap between cells to last available row into Broker Invoice and get new invoice number. this script works only when you are in specific sheet to avoid unintended copies. My question is : does always google add-ons works to slow or there is another way to do this function logics, and how to get rid of the run time error?