Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I have a working solution, that uses <code>deleteRows()</code>. I'm not sure why that didn't work for you, it would be interesting to see your code. </p> <p>The new Forms product (February 2013) is quite different than the legacy forms - <em>this solution will work on legacy forms only</em>.</p> <p>Anyway, here's what I have, with before &amp; after screenshots. The <code>tidy()</code> function can be called by passing in the number of rows to be removed, or you can call it from a menu as demonstrated here. A more complete version of this script is <a href="https://gist.github.com/mogsdad/5014758" rel="nofollow noreferrer">available as a gist</a>.</p> <pre><code>/** * Standard onOpen provided in script template. */ function onOpen() { var sheet = SpreadsheetApp.getActiveSpreadsheet(); var entries = [{name : "Read Data",functionName : "readRows"}, {name : "Tidy Form Responses", functionName : "tidy"}]; sheet.addMenu("Script Center Menu", entries); }; /** * Prompt user for the number of form response rows to remove, then delete them. * Assumes that the form responses are in the active sheet, that there is one * row of 'headers' followed by responses (in row 2). * * @param {number} thisMany (Optional) The number of rows to remove. If not * specified, user will be prompted for input. */ function tidy(thisMany) { if (tidy.arguments.length == 0) { thisMany = Browser.inputBox("How many responses should be tidied?"); } var sheet = SpreadsheetApp.getActiveSheet(); sheet.deleteRows(2, thisMany); } </code></pre> <h2>Before</h2> <p><img src="https://i.stack.imgur.com/8VFep.png" alt="Spreadsheet with form responses and custom menu"></p> <h2>During</h2> <p><img src="https://i.stack.imgur.com/1qruk.png" alt="Script operation, inputBox"></p> <h2>After</h2> <p><img src="https://i.stack.imgur.com/0ilXZ.png" alt="Spreadsheet with 2 fewer form responses"></p>
    singulars
    1. This table or related slice is empty.
    1. POHow to reset Google Form counter values using google apps script
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMogsdad
    1. USMogsdad
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to reset Google Form counter values using google apps script
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThis is working for legacy forms, you're right, but it seems that it's not the case anymore with the new forms, the counter doesn't appear in the spreadsheet anymore and deleting the 'grey added rows' has no effect (at least in my test)... Anyway, I think the question was about legacy forms so that's out of subject right now. +1 for this clear demo :-) - note : you could improve it a bit by providing the ability to remove last answers as well, not only the first ones (or even better : any answer by choosing the start number)
      singulars
      1. PO
      1. USSerge insas
    2. COThanks, @Serge. I put a more complete version in a gist - it can delete all rows. While I could (or anyone who wants it could) be more selective about where to start deleting, I've made the assumption that the oldest responses are the most expendable. As for the new forms, with responses part of the form instead of a spreadsheet, this won't work. Could be added to [the existing API request](http://code.google.com/p/google-apps-script-issues/issues/detail?id=2383).
      singulars
      1. PO
      1. USMogsdad
    3. COThank @Mogsdad, I've try your code and adjust it a bit, and it works, not only delete the rows but also update the form counter: `//resetInput var shInput = ss.getSheetByName('Input'); LastInput = shInput.getLastRow(); ss.toast('LastInput in row: '+LastInput); //Confirm the last row shInput.deleteRows(2, LastInput-1);`
      singulars
      1. PO
      1. USthangle
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload