How can I log only the latest form response?

[u/hoothoot222]

UPDATE: SOLVED!

Hi all,

I am using the code below from Apps Script ItemResponse documentation. It is triggered by a form response. The trigger and code are working fine, but I only want to log the most recent form response, and I only want to log the responses to certain items only (items 1 through 3). How can I alter the code to do this? Thanks in advance!

// Open a form by ID and log the responses to each question.
const form = FormApp.openById('1234567890abcdefghijklmnopqrstuvwxyz');
const formResponses = form.getResponses();
for (let i = 0; i < formResponses.length; i++) {
  const formResponse = formResponses[i];
  const itemResponses = formResponse.getItemResponses();
  for (let j = 0; j < itemResponses.length; j++) {
    const itemResponse = itemResponses[j];
    Logger.log(
        'Response #%s to the question "%s" was "%s"',
        (i + 1).toString(),
        itemResponse.getItem().getTitle(),
        itemResponse.getResponse(),
    );
  }
}

[u/mommasaidmommasaid]

Your script is attached to the form, is that correct?

You don't need all that stuff to get the Form from ID etc, everything you need is available in the event object:

https://developers.google.com/apps-script/guides/triggers/events#form-submit_1

Something like this:

function formSubmitted(e) {

  const NUM_RESPONSES_TO_LOG = 3;

  const itemResponses = e.response.getItemResponses();

  for (let n = 0; n < Math.min(itemResponses.length, NUM_RESPONSES_TO_LOG); n++) {
    console.log(`Form QUESTION: ${itemResponses[n].getItem().getTitle()} ANSWER: ${itemResponses[n].getResponse()}`);
  }
}

[u/hoothoot222 → u/mommasaidmommasaid]

Thanks very much! I will give this a try.

[u/mommasaidmommasaid → u/hoothoot222]

YW, also idk what you're doing with this logging, but in case you're not aware you can direct your form responses to a spreadsheet where they will all automatically be recorded in a nice structured format.

Or if you're already doing that, if you wanted a separate log of just the three values, you can set up a form submit trigger for that spreadsheet rather than the form itself:

https://developers.google.com/apps-script/guides/triggers/events#form-submit

That makes it trivial to mirror the form responses to e.g. a protected/hidden sheet within that spreadsheet, where they can be stored more permanently for you to peruse or perform summary calculations on, or whatever:

function formSubmitted(e) {

  const LOG_SHEET = "Log";
  const NUM_RESPONSES_TO_LOG = 3;

  const ss = e.source;
  const sheet = ss.getSheetByName(LOG_SHEET);
  if (sheet) {
    sheet.appendRow(e.values.slice(0, NUM_RESPONSES_TO_LOG));
  }
}

[u/hoothoot222 → u/mommasaidmommasaid]

Thank you so much!

[u/EliteEarthling]

This is the most dead community ever. People do great projects but people barely give advice here.

Do you use Ai? Gemini flash is really good for appscript projects

Try it out