Variables suddenly start getting posted on new row in Sheets
Seems like every now and again, the variables from a Storyline course switch to the following line in Google Sheets.
Might be related to crossing a batch of 500 API calls though not sure. Calls are also very slow.
Any advice very welcome please,
August 10, 2021, 8:15 am
The speed problem is just how Google works, there's nothing you can do here. This is well-documented online, for example, you can see this thread: https://support.google.com/docs/thread/42793831/script-function-in-sheets-are-very-slow?hl=en where Google's product expert states that "Google Apps Script is pretty fast, but calls to the SpreadsheetApp API are very slow." If speed is a critical issue, I would recommend switching to Data Cloud.
I'll see if I can find anything out about the 500 record threshold.
August 10, 2021, 8:25 am
Ok, thank you very much!
August 13, 2021, 1:38 am