Limiting data


I am creating a form which has a requirement for only the last 4 digits of the social security number. Any suggestions on how to limit the character input to only 4 or how can I pre-fill in 000-00 allowing the form user to only be able to input the last 4 digits?


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    I would first update the column name to specifically say "Last 4" or something to indicate that you only want the last 4. Even helper text in the form field.

    To pre-fill with the zeros, you would use something like this:

    =SUBSTITUTE("original form url" + "& insert column name here = 000-00", " ", "%20")

    The output of this formula would be the URL that you share with people to fill out the form.