Exception: Failed to retrieve form data. Please wait and try again-CodePudding

This

can anyone please help me out? I'm loosing customers due to this bug :(

CodePudding user response：

Assuming that the issue is intermittent, you could retry the problematic call with exponential backoff. Replace this line:

const respondentEmail = e.response.getRespondentEmail();

...with:

let respondentEmail; try { respondentEmail = exponentialBackoff_(() => e.response.getRespondentEmail()); } catch (error) { console.log(error.message); respondentEmail = ''; }

Here's a simple exponentialBackoff_() implementation:

/** * Calls a closure, retries on failure, and returns the value it gives. * * Usage: * const respondentEmail = exponentialBackoff_(() => e.response.getRespondentEmail()); * * @see https://en.wikipedia.org/wiki/Exponential_backoff * @param {Function} action The closure to call. * @param {Number} maxNumTries Optional. The number of times to retry. Defaults to 5. * @return {Object} The closure return value. */ function exponentialBackoff_(action, maxNumTries = 5) { // version 1.0, written by --Hyde, 29 December 2022 // - see https://stackoverflow.com/a/74952372/13045193 for (let tryNumber = 1; tryNumber <= maxNumTries; tryNumber ) { try { return action(); } catch (error) { if (tryNumber >= maxNumTries) { throw error; } Utilities.sleep(2 ** (tryNumber - 1) * 1000); } } }

CodePudding user response：

I found an answer on this website. It' written in Japanese, but it provides a script section as a workaround.

Script

const noText = ''; function getDataFromForm(e) { let formResponse; let timestamp; let question1; let question2; let question3; let question4; try { formResponse = e.response; } catch(e) { Logger.log(e); formResponse = null; } if (formResponse !== null) { timestamp = formResponse.getTimestamp(); [ question1, question2, question3, question4 ] = getObjectFromFormData(formResponse.getItemResponses()); } else { [ timestamp, question1, question2, question3, question4 ] = getDataFromSpreadsheet(); } Logger.log(timestamp); Logger.log(question1); Logger.log(question2); Logger.log(question3); Logger.log(question4); } function getObjectFromFormData(itemResponses) { const response = []; for (itemResponse of itemResponses) { const item = itemResponse.getResponse(); if (item === null || item === noText) continue; response.push(itemResponse.getResponse()); } return response; } function getDataFromSpreadsheet() { const spreadsheetIdKey = 'SPREADSHEET_ID'; const spreadsheetId = PropertiesService.getScriptProperties().getProperty(spreadsheetIdKey); const spreadsheet = SpreadsheetApp.openById(spreadsheetId); const sheetName = 'フォームの回答 1'; const sheet = spreadsheet.getSheetByName(sheetName); const firstRow = sheet.getLastRow(); const firstColumn = 1; const numberOfRows = 1; const numberOfColumns = sheet.getLastColumn(); const range = sheet.getRange(firstRow, firstColumn, numberOfRows, numberOfColumns); const valueTable = range.getValues(); const imageFileRowNumber = 4; const imageFileUrlPrefix = 'https://drive.google.com/open?id='; const response = []; for (valueRows of valueTable) { for (let i = 0; i < valueRows.length; i ) { if (valueRows[i] === noText) continue; if (i === imageFileRowNumber) { response.push(valueRows[i].replaceAll(imageFileUrlPrefix, noText)); continue; } response.push(valueRows[i]); } } return response; }

Detail

He puts try-catch around e.response cause it causes the error. When the error happens it takes data from spreadsheet which connects to the form. Even if e.response shows the error, the spreadsheet connects to the form can get data.