New! Add real-time validation to fields on your form

124»

Answers

  • mdcatlett
    mdcatlett ✭✭✭✭

    Great going. I am also looking for the 'next step' - character/digit limits, custom pattern recognition, etc.

  • I've found that using the Number Only validation is problematic because it drops the leading zero when entered by the user. For a common example, the zip code for New Haven, CT gets typed in the form as 06511 but then the entry is saved as 6511 in the sheet. There are more examples than I can think of where admins want to restrict the form field to only contain numbers but a zero may be the first digit of a value.

    1. Is this issue in the queue to be remedied some time in the near future?
    2. Please don't @ me about using a hidden helper field with formulas to correct my zip codes.
  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭

    @Matt RasmussenThe postal service should never have created any zip codes starting with a leading zero in the first place. What poor planning! But that's par for the course with USPS. I stopped using number only validation on zip code fields for this very reason.

    Regards,

    Jeff Reisman,IT Business Analyst & Project Coordinator,Mitsubishi Electric Trane US

    链接:Smartsheet Functions Help Pages链接:Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!