Skip to main content

How to limit the length of a single line text?

  • February 8, 2019
  • 4 replies
  • 156 views

Forum|alt.badge.img+3

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?

4 replies

Forum|alt.badge.img+5
  • Inspiring
  • 1386 replies
  • February 8, 2019

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…


  • New Participant
  • 1 reply
  • September 3, 2019

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…


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 !


Forum|alt.badge.img+2
  • Participating Frequently
  • 53 replies
  • September 3, 2019

@Simon_Vacher

You can

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

Check the following base for formulas

Neal


Forum|alt.badge.img+15
  • Inspiring
  • 368 replies
  • September 29, 2020

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