i just started a new spreadsheet for my trades in google sheets
i installed GESI - and to get item names i used the type-id-list and then i made my first mistake
i added a cell with a GESI query to put out the name for the type-id
and i copied this cell next to all types in the type-list - so around 40k i think
realizing this would take a while i had another great idea - i deleted all the cells \o/
now the next proper query i made is stuck at loading - because it’s probably waiting for those 40k, now invisible, queries that are in line
is there any way to cancel those queries?
deauth GESI?
i don’t want to make more silly mistakes
Could always just delete the sheet and make a new one if you’re really worried. Either way that wont help your ban as that’s account wide so will just need to wait until tomorrow.
Easiest way is to just refresh the sheet, but both ESI and Google cache data so depending on what data you’re fetching it might not help.
thanks - as i had no patience i just created another gmail account
so far so good - BUT i still have problems with updating the sheet/queries
concerning corporation-transactions
when i refresh the whole page it doesn’t refresh the query (i guess that’s google cache?)
when i create a new table and copy the query it does fetch a new one
no idea how to refresh the original
and another weird error - when i create a copy of the whole sheet - that one doesn’t work
for some reason it doesn’t know the GESI functions (but GESI is active and linked in scripteditor)
error: #NAME?