Sign in to submit new ideas and vote
Get Started

Length and/or Character validation within a Form

13»

Comments

  • Please consider having the ability to apply character limits to data fields within the sheet itself, forms, and Dynamic View capabilities. This would assist with the quality of the data being provided. We have multiple examples that would apply.

    Ten characters in a field (alpha or numeri or a combination alpha numeric).

    The ability to apply hyphens or other characters within the data field character limitation/format style. Similar to the auto-numbering feature where you can have prefixes with hyphens/dashes, special characters.


  • SoS | Dan Palenchar
    SoS | Dan Palenchar ✭✭✭✭✭✭
    edited 07/15/24

    @Megan_ClavieParker & @Anais,

    There's unfortunately not a perfect solution for this but you can implement these strategies:

    • Use restricted dropdown lists when reasonable to do so,
    • Use an Update Request to send the submitter a form to update their information when errors are made
    • For phone numbers there is a built in validation option

    School of Sheets (Smartsheet Partner)

    If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!