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?
i don’t want to make more silly mistakes
thanks in advance
Just delete that cell and it’ll be fine.
like i wrote - i deleted those 40k cells already - but the queries are sent already
anyway - i already got banned anyway for too many queries in a day…
i just realized you are the GESI dev, right? Great work! easy to use so far
just wondering how to make a refresh button in sheets
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
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)
well, at least i found out that when i delete the original query/cell and reenter it - it does fetch it freshly
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.