Google-sheets – Reverse (or repopulate) a Google Docs Form

google sheets

I created a Google Docs form that collects (mostly) biographical and contact data from users. Now I would like to reverse the process and repopulate the form with each user's input, one page per user. I guess this is like Word's mail merge.

I see that Google Docs has a scripting language, but is there a simpler way to re-generate these form submissions without learning another scripting language? Cosmetics aren't at all important in this use case, I would just like to provide the user data to another audience without asking them to navigate a spreadsheet.

Best Answer

With some more searching I found that someone wrote Google Sheets add-on that does just this. The add-on is Save as Doc. The output doesn't look exactly like the form, but it generates a Google Doc with page breaks after every row and you can specify the column titles as an level of heading.

For simplicity it is pretty hard to beat.

Related Solutions

Google-sheets – How to reverse text on Google Spreadsheets

You will need to install and use a script to do it.

In your spreadsheet, select Tools → Script Gallery → Insert....
Search for reverse. You should see String.reverse().
Click Install, then Authorize.
Close the Script Gallery.

To use the script, type =REVERSE(A1) where A1 is the cell with the text you want to reverse.

If you are using the new Google Sheets, the Script Gallery is not available. You will need to create your own custom function.

Select Tools → Script editor...
Select Blank project

Replace the code with:

/**
 * Reverses the input text.
 *
 * @param {string} input The text to reverse.
 * @return The input text reversed.
 * @customfunction
 */
function REVERSE(string) {
  if (typeof string != 'string') {
    return null;
  }
  return string.split('').reverse().join('');
}

Save, return to your spreadsheet, and use =REVERSE(A1) as described above.

Google-sheets – Including option descriptions for a Google Docs Spreadsheet form

I'm afraid your only choice is rephrasing so that the right answer is obvious:

What would you like to get the game from?

This affects the way we reimburse you. If you'd like to get the game through Steam, we'll simply gift it to you. If you'd like to get the game through Amazon, we'll try and get you a gift card for the same amount of money. Otherwise, you'll need to send us a scan of the receipt and we'll reimburse you through PayPal and Moneybookers.

( ) Steam
( ) Amazon
( ) Other

Best Answer

Related Solutions

Google-sheets – How to reverse text on Google Spreadsheets

Google-sheets – Including option descriptions for a Google Docs Spreadsheet form

What would you like to get the game from?

Related Topic