andypresh

Thanks for the reply Abdullah. 🙂

I think you may be misunderstanding which lines of code I have commented out.

You say “If you would comment on the whole code then the entry will not submit in Google Sheet” – I am only commenting out the try/catch block (lines 125 & 184-187), not any of the code which handles the submission. I would not comment the whole code! That would be silly 🙂 but the catch block with return null; just ignores the error instead of logging it… so by removing the try/catch block, the error gets caught further up the chain and logged correctly.

I have tested my version and the form submits correctly, and the entry either appears on the Google Sheet as usual, or the error returned by Google Sheets is logged.

I’m also not sure what you mean by “Due to Quota being exceeded entry was not submitted, therefore it will appear in the next minute.” – I’ve done a lot of testing and I have never seen failed entries appear later. Google don’t say this will happen, instead they recommend an Exponential Backoff strategy, but I’m not worried about this. I suppose it is something you could add to Pro version, if you haven’t already. But it’s a rare error, so for now I can add them to the spreadsheet manually. 🙂

Best wishes
Presh