Hello, I have this issue in formsnap, with the date it writes into a google sheet. I adds a ’ in front of the date '06/12/2424, messing up when I search in the entries. Why does it do that, and how do I prevent it from doing so? Actually it seems it does so with all numbers!
Hi @Kent
The issue occurs because Google Sheets adds a leading apostrophe to treat the value as text. You can fix this by selecting the column in Google Sheets and setting the format to “Automatic” or a specific format like “Date” or “Number” to ensure proper recognition. Also check your FormSnap settings to make sure the fields are sent in the correct format, such as date or number, instead of plain text. Hope that helps. 🤞
2 Likes
Thank you for your advice. It’s a bit strange what’s happening. I can’t stop it from adding the apostrophe. I have set the locale in FormSnap to Danish, and I also set the locale in the Google Sheet to Danish. I’ve formatted the column as dates, etc., but no matter what I do, it still adds the apostrophe. I have no clue how to stop this behavior. It is really frustrating because it affects the search function, causing new entries to not appear when searching for a particular date. Only those that I’ve reformatted as dates are shown.
Hi @Kent
It’s weird. The issue might arise because FormSnap and Google Sheets handle date formats differently, even if both are set to Danish. When FormSnap sends data, it might interpret or encode it as plain text rather than as a proper date. This causes Google Sheets to treat the input as text, adding an apostrophe to preserve the exact format. Even though you set the locale to Danish in both FormSnap and Google Sheets, their internal handling of dates may not align perfectly, especially if the formats are not explicitly standardized (e.g., DD-MM-YYYY). You have to ensure that FormSnap is configured to send the date in a universal format like YYYY-MM-DD and that Google Sheets’ region is set to Denmark, with the column explicitly formatted as a date (with the same pattern DD-MM-YYYY for example ; it has to match perfectly to avoid some issue). 🤞🍀🧲 because I’m surprised with this issue persistence.
1 Like