CODEWITHSUNDEEP
google-apps-scriptgoogle-sheetsgoogle-forms
LisaO79
LisaO79

Reputation: 1

Cell format (setWrap) when Form submitted

I've set up a form to send results to a spreadsheet. Most the results are paragraph text. As each new row is added the default is no wrapping despite what formatting may have been applied to the column.

Is there a way to run a script to change the format of the new cells to wrap as each new entry is submitted. Not sure how this should be written.. should it be onedit, onformsubmit...and will setwrap work. Does anyone have an example of this? complete newbie.

Upvotes: 0

Views: 2688

Answers (1)

Dave
Dave

Reputation: 11

function onFormSubmit(e) { e.range.setWrap(true); }

Add a trigger to run on form submit

Upvotes: 1

Related Questions