Need to Center and Word Wrap in Google Sheet for an Intake Form for an Log Sheet

Good morning - 

Have you tried manually updating the formatting of the individual cells highlighted? If the code is just updating the value of the cells and not changing the formatting of those cells, then using a macro to update formatting that is static seems redundant. 

I asked Gemini, it's too early for me to debug,  I hope this works: 
function formatIntakeForm() {
  // Get the spreadsheet and the "INTAKE FORM" sheet
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName("INTAKE FORM");

  // Define the range of cells to format
  var range = sheet.getRangeList([
    'D5:D11', 'F5:F11', 'H5:H11', 'J5:J11',
    'D13:D19', 'F13:F19', 'H13:H19', 'J13:J19',
    'D21:D39', 'F21:F39', 'H21:H39', 'J21:J39'
  ]).getRanges();

  // Loop through each range in the range list
  for (var i = 0; i < range.length; i++) {
    // Apply word wrap and center alignment
    range[i].setWrap(true)
           .setHorizontalAlignment("center")
           .setVerticalAlignment("middle");

The problem is you are using clear() to clear the form data. You should be using clearContent() . Clear wipes out the data and formatting, whereas clear content only removes the data within the cell.

Change those and you will not have to worry about formatting again.

Alice,
Just FYI. Gemini is awful. It is wrong more often than it is right. It has given me deprecated code and code that is non-functional.

Claude AI is awesome. It's never let me down.

FYI
Keith

Yes. Claude is, as far as I've seen, the leader in AI coding.

Michael,
Amen. I don't consider myself anything more than a hobbyist coder with regard to apps script but every time I use Gemini it gives me wrong code. And that's pretty bad when somebody is low on the coding spectrum as I am, can tell that Gemini is just giving bad information. I can't tell you how many times it has written code for me and given me deprecated code or JavaScript that's not supported by apps script. Gemini has infuriated me more times than one and I don't even consult it anymore.

Claude - on the money every time.

I recently asked Claude for best practices with regard to apps script lock service and he gave me a really fantastic lock wrapper - which I put here on the community for review. Works great!.

Cheers
Keith