Limit Size of Entry on a form

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

Find more posts tagged with

Forms

Services

Comments

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.

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.

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

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

Sign in to join the conversation!

Quick Links

Trending discussions

SUmmary in Report Widget
How can i create a Report widget that only shows a status with "red status" from my main data source? Do i need to create a separate data source on just my "red status"
Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…