Can someone please tell me where I'm going wrong?!

[Adriana Lamb]

Backstory: I work at a company with a large fleet of heavy-duty trucks. Of course, when something breaks on one we would need one of our mechanics to look at it, so I created a Google Form for the drivers to request the repair.

I recently learned that I could use App Scripts to make the responses from the Google Form self populate onto a Google Doc template for a service order and I used a tutorial online to create the code. It went almost perfectly but there is ONE stinkin' box that won't autofill no matter what I try. My amateur skills are quite lackluster but I'm hoping my mistake will be glaringly obvious to someone here!

The piece I'm having trouble with is "Unit Number"

I have attached a screenshot of my code. 

I also have screenshots of the auto-filled Google Doc where that damn box won't autofill, the column headers on the Google Sheet, and the question from the Google Form that I will attempt to add in the comments (I'm new here lol).

Please tell me the error of my ways!! TIA!!

[Adriana Lamb]

[Adriana Lamb]

[Adriana Lamb]

[Bennett, Scott]

Just looking quickly here.  But your code is looking for "unitNumber" but you just have "unit" in the document.

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/32a7817c-8ea4-4448-a597-49f4af7a216an%40googlegroups.com.

--

Scott Bennett

[Adriana Lamb]

Whoops sorry, I attached the wrong screenshot! That was from one of the earlier variations I tried...  "unit", "unit #", and "unitNumber" were all tried and not a single one worked!

The correct/newest screenshot is below

[Nahum Sanchez Arce]

Thank you very much, it will help me in my transmission from html to appscript form

--

You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/7ae3adcd-e006-4db6-88e1-b86b5583ea01n%40googlegroups.com.

[CBMServices Web]

Your template says {{Unit}} but your code is looking for {{unitNumber}}.

Change one or the other for them to match.

--

[Adriana Lamb]

Yeah sorry about that, I attached the wrong screenshot! That was from one of the earlier variations I tried...  "unit", "unit #", and "unitNumber" were all tried and not a single one worked!

The correct/newest screenshot is below

[CBMServices Web]

Add this statement in your code just above where you do replacement.

 Logger.log("Unit:" + unitNumber);

If this prints valid value for unit Number, it could be it is getting confused by the fact it is a number and not text.

Add this one line above the replace:

unitNumber = String(unitNumber);

Good luck.