Jump to content

Contact Form Submission Adding Apostrophe Before Date in Google Sheets

Recommended Posts

I have a contact form linked to a Google Spreasheet for project inquiries on my site.  Recently in the Google Sheet I noticed apostrophes were being added before the date and time stamp of the inquiry, preventing Google Sheets from recognizing it as a date and complicating some other functions in my spreadsheet.

This only started a few months ago and seems to be added by Squarespace during the data writing process and I cannot find a way to disable the apostrophe and have the timestamps automatically show up in a date format.

Any input would be appreciated, thanks in advance.

Screen Shot 2020-09-11 at 11.49.01 AM.png

Link to comment
  • 4 weeks later...
  • Replies 3
  • Views 905
  • Created
  • Last Reply

I found that if you select the column and just slightly change the formatting (example: numbers from “1” to “1.00”) it will remove the apostrophe. You can then also change the formatting again, back to your original format I (i.e. back to “1” - but not via Edit > Undo formatting) and the apostrophe will still be removed. Not ideal, but a faster work around compared to manually removing. 

SS Support said it’s a known issue they’re currently working on/have prioritized 

Link to comment

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Squarespace Webinars

Free online sessions where you’ll learn the basics and refine your Squarespace skills.

Hire a Designer

Stand out online with the help of an experienced designer or developer.