Limit Size of Entry on a form

tom55166 · 11/09/18

I tried to search for this but was not able to find it. I have a form that I has one of the entries that I want to collect is nickname....but I can only display 8 characters....

So how do I limit the entry to restrict it to be only 8 characters?

Today I am preloading the field with XXXXXXXX hoping that they will read the instructions and limit it themselves.....thanks. Tom

Paul Newcome · 11/09/18

Unfortunately you cannot limit what is entered on a form. You can however use a checkbox column with

=IF(LEN([Nickname Column Name]@row) > 8, 1)

It will check a box if the characters are more than 8. You can then create an update request to send out if that box becomes checked.

Mike Wilday · 11/09/18

That's a great idea... like a "Thank you for your submission but we noticed that your nickname exceeded the 8 characters. Please update the nickname to match that character limit." Along with that cell's details.

You will have to capture users to do that though or ensure they submit one in their form submission.

IanN · 11/09/18

Hi Tom,

I agree with Mike that this is a great suggestion for a feature. You can submit this to our Product team by clicking on the "Submit Product Enhancement Request" link on the right sidebar. We love hearing input like this from our customers.

This could be something like: "Limit characters during form entry for certain fields" and/or "Data validation to ensure correct data entry".

Thanks!

Ian

Smartsheet Support

tom55166 · 11/10/18

You guys are the best...thank you.

I already use the alerts and update requests...and I will use this as a "work around". Tom

Limit Size of Entry on a form

Comments

Categories