What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Zip code's leading 0s are being truncatedAsked by Shebu Mathew on June 13, 2013 at 07:09 AM
Is there a way to keep the leading 0s of a zip code when integrating with google spreadsheet.
For example: in jotform my zip code is entered as 08872. When the form is submitted which is integrated with google spreadsheet it shows up as 8872 versus 08872. Is there a way that the 0 can be preserved?
Hi, change the data type of the column to Plain Text in the Google spreadsheet.
1. Open your spreadsheet and select the column that has the post codes.
2. Select Format from the menu bar, then select number, then select plain text.
Hope this will solve your problem.
I tried that and it still not adding the leading 0.
That should only work for new upcoming submissions. Have you tried to send test entry to see the changes? If not, please try that and let us know the results.
I have moved your inquiry to a new thread: http://www.jotform.com/answers/453035
Your inquiry will be address there.