How to move Google Form entries in a Google Sheet to the top row ... Automagically 🎩 #GTTribe

QUESTION❓ 🙋‍♂️🙋‍♀️ ... Please listen 👉

𝕊𝕒𝕣𝕒𝕙 𝔽𝕣𝕠𝕞𝕙𝕠𝕝𝕕 @sew1080

GoogleTeacherTribe058.mp3

I would like my new entries to show up on top of the Google Sheet ...

by Cary Sampson This is my issue:

At work we currently use google sheets for orders that go on hold. My issue is that I want all new entries to show up top. I've searched throughout the forum and found solutions but for some reason it will not work for me. I can't post my spreadsheet due to business guidelines. I created a "sister sheet" and pasted the scripts that I came across into field A1. At first it said invalid sheet name. So i renamed it from Form Responses to Q4 2014. After that it gave me an error "Parse error" Tried researching it on my own to figure it out but to no avail. Cell A1 is named Timestamp. I need to sorted automatically with each scan to show up top instead of bottom.

Thank you for your time.

I used the information in this post to create the answer!

Here is the link to the Google Forum Post

https://productforums.google.com/forum/?noredirect=true#!topic/docs/V_UVuwX_UFY

ANSWER 💡🔦 ...

Please give it a try! Let Matt and Kasey know why we love to listen to them so much❣

Once you submit ... Refresh / Reload the page and you will see your entry on TOP! ⬇

GOOGLE FORM

GOOGLE SHEET

Google Teacher Tribe Podcast ... Why do you listen? (Responses)

Screenshot of my "Script editor" below ...

Once you have setup your code, go up to "Edit" and set your Current project's triggers to the following ... ⬇

Screenshot of my Project Triggers below

Copy the code below and paste it into your "Script editor"

The code is written by: --Hyde - Top Contributor - Member since 9/17/12

var sheetToSort = "Form Responses 1"; // replace this with "Form Responses" or whichever sheet you want to sort automatically

var columnToSortBy = 1; // column A = 1, B = 2, etc.

var rangeToSort = "A2:B1100";

function onEdit() {

var sheet = SpreadsheetApp.getActiveSheet();

var editedCell = sheet.getActiveCell();

if (editedCell.getColumn() == columnToSortBy && sheet.getName() == sheetToSort) {

sortFormResponsesSheet();

}

}

function sortFormResponsesSheet() {

var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetToSort);

var range = sheet.getRange(rangeToSort);

range.sort( { column : columnToSortBy, ascending: false } );

}

Comment Box Idea for Google Sites ... Maybe a "Padlet?" Take a listen ... 👂🎧➡

GoogleTeacherTribe058 v2.mp3

Google Sites

Report abuse