Don't Drop the Leading Zero in Form Submission

I have a simple form to capture the last 4 of a SS#. I restrict the text/number field to numbers only on the form, but the leading zero gets dropped. Answer from Support was to remove restriction of numbers only, which defeats the purpose of this feature. Please vote to have Smartsheet include logic that will not drop a leading zero in a form field restricted to numbers only.

Sign in to vote!

Find more posts tagged with

Forms

Idea Submitted

Product Development

Enhancement Request

Comments

jpaul

yes please!! we have a form to capture expenses and part of it is for the last 4 digits of a card number. dropping the leading zeros is skewing our data!

Heather C

We need this desperately, for our drilling permits. Our forms have many fields that require 24 hour time format, as most of our work is done in the morning at say 0600, we need the leading zeros. In our forms the field is a required field and must be number only as we have happy faces that have ended up in our data at times. If the field is required and you type in 0600 an error message pops ups and says 'This field can only contain numbers', at this point our crew cannot submit the form unless they drop the zero which they will not understand as technically they are still numbers.

Frank_A

Yes - Really would like this to be fixed please.

Quick Links

Trending ideas

Attachments in Cells
I rely heavily on Smartsheet’s Document Generation. However, this workflow is currently dependent on having photos stored inside cells, since row attachments alone cannot be used directly in document generation.. If Smartsheet allowed attachments to be displayed as thumbnails in cells (as a reference), document generation…
Form Upgrade to Pull In Data from Another Smartsheet Source
It would be extremely helpful if there was a way to have data pull into a form from another Smartsheet source based on selections made within the form. Example: On the form there is a dropdown to select a client property number. The property Name, Address, and any additional property information are then pulled into the…
WorkApp Analytics
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…