Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
numbers that start with zero and webforms
I have a webform that I am trying to create but one of the columns is a number field where the number commonly starts with a 0. My problem is that when you submit a number that starts with a 0, the 0 gets dropped unless the field is formatted as text. In smartsheet, the only way I see to format a field as text is to add an apostrophe before typing in the number. The problem with that is that this is a user form and most users will not type the apostrophe. As a result, we get numbers being submitted that are not correct.
Is there a way to force a column to be text so this will work properly?
Or a way for the form to automatically add the apostrophy without actually placing it by default in the field? I tried using the default value option but many users will type over it or delete it before adding information.