Skip to main content

Hello! First time user of Airtable, so bear with me😀


I have a Long text field that I am trying to limit the number of characters entered into it. From reading the the posts, it looks like that is not possible, correct?


In another members post they suggested using LEN and COUNT, but I’m not sure how to implement it. From what I’ve figured out so far is that I would need to create another field (a formula field) to count the number of characters (including spaces) from another field in the same record. So, let’s say my long text field was named Product Description. What would be the formula entered (in the new formula field) to do a count of characters? Also, would the character count show in the new field and change as I’m typing in the product description field?


Or if there’s another way…


Thanks!


Sue

Well, that was pretty simple. I just needed to add LEN(Description) to the formula. Thought it was going to be some complex formula and started there and it worked.


Problem is, that field does not show in Form View because I guess the software doesn’t allow formula cells to show in form view. I don’t really care for the Expanded view because:


It doesn’t let you add new records as you move along (you have to go back to grid view) and I hate the distracting sidebar of revisions. Is there anyway to toggle revisions off?


Any other work arounds to get that result to show in form view?

Hi @SUSAN_SHELDON


You can turn Revision History display off for any base - this leaves the side bar clear for comments only which make commenting much more usable as well. Here’s a link to the support article about this:


Hi @SUSAN_SHELDON


You can turn Revision History display off for any base - this leaves the side bar clear for comments only which make commenting much more usable as well. Here’s a link to the support article about this:




Thanks @Julian_Kirkness. I did figure that out from another search. Was hoping to hide that sidebar totally as it’s just empty since I’m the only one using the database. My preference would be to be able to see the formula columns in Form View, so I could just keep tabbing through and adding new records.

If you would like to enforce a character limit in your form, we have built a third-party form for Airtable that supports this feature for single line and long text fields.


2025 Update:

You can’t set this up with Airtable’s legacy form views, but you can set this up with Airtable’s new forms.

You can get to the new forms by clicking on “Forms” at the top of the screen, and the new forms will allow you to set a character limit for both long text fields and single line text fields.

Alternatively, you can also do this with Fillout’s advanced forms for Airtable, which also offers hundreds of additional form features that you can’t get in Airtable — such as creating new linked records with a form, updating Airtable records with a form, or generating PDF files with a form submission.

Hope this helps!

If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Reply


Terms & Conditions