Formatting error with new FormEmailer Script

[W Wesley]

Hi All,

 

Has anyone else experienced a formatting error with cells that hold dates and times when using the new (re-written) FormEmailer script? My form has a few questions that use the built in Google calendar for selecting a date and time. The Form response sheet stores the answers correctly in their cells but when the answers are emailed using the new script the formatting is messed up. For instance: cell H5 has 5:00AM in it. When it's sent out it reads 12/30/1899 5:00:00. I want whats in the cell to be transferred in the email. The old FormEmailer Script would transfer exactly what was in each cell to the email. Any help would be apprecitaed!!!

Copy of FormEmailer script Attached

Thanks for your Help!!

W

[Henrique Abreu]

The old one did not really do that :-)

But you can use a custom formatting on the placeholder, please look here: https://sites.google.com/site/formemailer/formatting

Henrique G. Abreu

--
You received this message because you are subscribed to the Google Groups "FormEmailer" group.
To unsubscribe from this group and stop receiving emails from it, send an email to formemailer...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/formemailer/02346af4-74b6-4a3a-9f19-0cd0e91d8aa3%40googlegroups.com.