Hello,
I'm new to Apps Script and seeking assistance. I aim to trigger a function, onSubmit, to POST the results of a Google Form to an external API. As far as my understanding goes, FormApp retrieves all responses (FormApp.getResponses()). My concern is whether the following approach would still function efficiently if there are millions of responses:
const formResponses = form.getResponses();
const latestResponse = formResponses[formResponses.length-1];
Additionally, I'm curious if onSubmit will still be triggered if the Google Sheet linked to the Form reaches its limit.
Thank you.
--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/d882a284-e7f0-4f20-8af3-5590793e8531n%40googlegroups.com.