Google Sheets Line Height issue after form submission

Question

I need my row height in google sheets to stay at 40. The issue I am having is every time a user submits a form and a new entry is created, the line height goes back to the original formatting. I creating a macro and thought there may be a way to run it through conditional formatting but I do not see any other option where I can dynamically run the macro.

I linked a video describing the issue I am having and why I need to have the line height to be consistent. https://www.icloud.com/iclouddrive/006rfY-aq5Y_ERggwTG-q2XrA#lineheight

Answer 1

Perhaps you can do it with a script, as guided in Google Apps Script: Make Row Taller on Form Submit

Basically, in the Spreadsheet you're going to go to Extensions > Apps Script. And in the the code box paste the foollowing code:

function makeTaller() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Form Responses 1");
var last = sheet.getLastRow();
sheet.setRowHeight(last, 40);
}

And click on Save Project: Once it's saved you go to Triggers, click on Add Trigger, set Select event source: From Spreadsheet and Select event type: On form Submit, then save it: It will ask you for authorization (basically you are authorizing this script - you just created - access to the sheet), you might need to click Advanced and then allow.

Once this is done, the sheet rows will be resized to 40 on each form submit: