Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Google Apps Script: Make Row Taller on Form Submit

code making Google Forms rows taller

Google Apps Script: Make Row Taller on Form Submit

code making Google Forms rows taller

Code Increasing Row Height

If you use Google Forms (ha “if”, of course you use Google Forms) you may format the spreadsheet of results the way you like it. However, when a new Form submission comes in a row is INSERTED so the formatting you set doesn’t apply. Any easy (no for real) way to fix this is to code a trigger on Form submit that applies the formatting to your newly inserted row.

Step 1: Make a Google Form


Step 2: Create the Spreadsheet

A spreadsheet is NOT automatically created for you when you create the Google Form. Click on the Responses tab and click the green spreadsheet icon to create the spreadsheet. This opens the spreadsheet.

Step 3: Tools Menu

In the spreadsheet go to the Tools menu and choose “Script editor.”

Step 4: Paste This Function

make Taller Script

function makeTaller() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName(‘Form Responses 1’);
var last = sheet.getLastRow();
sheet.setRowHeight(last, 115);

Step 5: Set Trigger

In the Script editor go to the Edit menu. Choose “Current project’s triggers.”
current project trigger

This will allow you to set it up so that when someone submits the form that it runs the code. Have it run your function (I named mine “makeTaller”) from the events “From spreadsheet” and then choose “On form submit.” Hit save. That’s it! Now when someone submits the form your rows are taller!
On form submit

Learn More Coding

Join my Go Slow 6 week online workshop “Coding Google Apps Script for Noobs.” If you know how to copy and paste and are intersted in coding this workshop is for you. A new workshop starts up October 23rd (and new ones are being added all the time.)


Taller Rows

Notice in the sample spreadsheet that the rows (except row 3 which is on purpose to show the contrast) is 115 pixels tall.

5 Easy Steps for Teaching with Digital Tools

Introducing digital tools into your teaching can seem challenging at first. There are many tools out there, and it might feel like there’s a lot to learn. But with easy steps for teaching with digital tools, you can start simply and gradually. There’s no need to dive in all at once – just take it one step at a time. Taking easy steps for teaching with digital tools starts with trying something!

Read More »
Students Prepare to Present

Help Your Students Prepare to Present

Maximize student success in presentations with ‘Speaker Notes by AliceKeeler,’ the ideal Google Slides add-on. Enhance how students prepare to present with easy transfer of speaker notes to Google Docs, promoting effective communication skills. Dive into the world of engaging, technology-aided presentations and empower students to shine in their academic endeavors. Discover the key to transforming student presentations into interactive, skill-building experiences.

Read More »

Infographic 7 Basic Steps for a Google Form

New to using Google Forms? This tool is essential for teachers to not only save time but to be adaptive to student needs. Use Forms to survey students, play games, personalize instruction, and assessment. This infographic on the 7 basic steps for a Google Form will help you get started.

Read More »

Online Workshop: Get Your Add-on Published

How can you make Google Workspace (Docs/Sheets/Slides) even better? You can create custom Add-ons with Google Apps Script. Wondering How to Get Your Google Workspace Add-on Published? Join Alice Keeler, Google Developer Expert, to learn the steps to get your Add-on officially published.

Read More »

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.