This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Users have been calling for a simple TITLE CASE / PROPER function since 2016.
And I know, there is @Bill.Frenchโs wonderful script - Field Tweaker - that allows you to reformat a field as either UPPER, LOWER, or TITLE CASE.
However, the script doesnโt work when the field is a computed field, as it is in my case.
The fields I need text formatting control over are computed from different sources. I need versions of those fields that are UPPER CASE - which is easily achieved via the UPPER() function - but I also need TITLE CASE versions (for reasons I donโt want to bore anyone with).
Again, if there was a standard PROPER() function in Airtable, this would be a piece of cake.
I am sure I am not alone with this request.
I ended up working around the issue you are encountering with the calculated field by creating an automation that would take my calculated field & re-enter it in another field as plain text - I then use Field Tweaker to Proper Case my entries. The problem with this is that I am then waiting for the script to be applied across 10,000+ lines, rather then the formula tackling it from the start.
Apologies in advance if any of this doesnโt make sense, Iโve been playing with scripting, automations, and formulas for the past 6 hours.
Iโm not sure exactly what your need is for Title Case, but I was determined to fix my issue regarding Title Case using a formula.
One of my bases is an ATS where people fill out an application/pre-screening questionnaire that has separate fields for First Name and Last Name. I was using a CONCANTENATE formula to have a Full Name field, but sometimes applicantโs input their names in all caps or all lower case.
I used UPPER to capitalize and LEFT to grab the first letter of the word in the First Name field. I then used LOWER to uncapitalize and MID to start with the second letter of the word in the First Name field. The 20 is probably more characters than I will ever have in that field, but I set it to pull apply to the next 20 letters just in case. Then I used โ& " " &โ to add a space and then followed the exact same formula to edit the First Name fields and applied it to the Last Name fields.
Depending on your use case, youโll probably need to edit other fields or formulas, or add/change some parameters, but I hope this is helpful!
