Allow for limiting text entry in a form text box.

jacquedale

When using the document generator I need to be able to limit the amount of text (since the generator does not allow for the cells to adjust as needed).

The settings for a multi-line text box allows you to select how many lines of text- but that function actually doesn't prohibit entry of more than the selected number of text lines.

Andrée Starå

Hi @jacquedale

I hope you're well and safe!

Here's a possible workaround or workarounds

• Add a formula and a so-called helper column that shows a message with the max number, how close they are, or a message that they've exceeded it. (can also be added in another cell in one of the columns already in the sheet)

Would that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

jacquedale

@Andrée Starå would this work for form users as well (meaning will it show a form user that they are maxing out)?

Andrée Starå

@jacquedale

Unfortunately, there's no way to use it in a form.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

jacquedale

Ok, thank you @Andrée Starå . That was specifically what I was submitting my suggestions for. It allows you to choose how many lines you want in a multi-line text box. But the selection does not change anything it is a "non-functioning" function.

Andrée Starå

@jacquedale

Excellent!

Happy to help!

I missed that I was answering an enhancement request.