How to limit the length of a single line text?

[Tim_Bourguignon]

Hi there, has anyone found how to limit the length of a single line text? I need my users to enter a few words as a description, but would like to prevent them from entering a roman (say more than 100 chars) in there. Any idea?

[W_Vann_Hall]

There’s no way to set a hard limit on the field in Airtable. Typically in a case like this, I’d use an alert triggered by LEN({Input})>{Limit} — but since you can’t make use of calculated values in a form, this won’t work for you. About the best you can do is to mention the desired length in the form’s field description and hope for the best…

[Simon_Vacher]

Hello ! Thanks for your answer. Can you detail how you trigger an alert please ?
My usecase is pretty much the same. I would like to limit field characters or at least color the line that have a lenght problem.

Thanks in advance !

[nea_lpatil]

@Simon_Vacher

You can

• Show Warning
• or just show shorter text and hide longer text

Check the following base for formulas

Airtable

Airtable: Organize anything you can imagine

Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free.

Neal

[Moe]

If you would like to have a character limit for text fields, we have built a form for Airtable that supports this feature.

miniExtensions

miniExtensions Form to Edit and Create Airtable Records

Send someone a form URL that updates a specific record in Airtable. A form for Airtable that's packed with plenty extra features!