Title Case Function? This there any Title Ca...

AppSheet AppSheet Q&A
1

Title Case Function?

This there any Title Case function that can covert the First Letter of each work in a string to upper case, as might be applied in a name like:

john citizen

becoming

John Citizen

?

Ideally it might be part of a set of formatting functions like Microsoft Word offers:

https://support.office.com/en-us/article/change-the-capitalization-or-case-of-text-1d86cf80-fbef-4380-8d6f-59a6b77db749

https://word.tips.net/T000249_Changing_Text_Case.html

(A Sentance Case and even an Toggle Case might be handy too.)

So far I have only found this Appsheet resource:

https://help.appsheet.com/expressions/expression-types/text-expressions

Thank you for your clarifications.

2

Hi @Colin,

As per my understanding, the title case and sentence case functions are currently unavailable.

As an alternative, in case you are looking for converting a string such as two or three word text into title case, irrespective of what case user types in,

you may wish to construct an expression using other

existing AppSheet functions. You can deploy that expression in an event action that converts the two

or three word text into title case on record save command.

3

Can you build a function that works for text of any length? I can’t think of how to build it.

By the way I can only find UPPER() so it will make it 2x (or more) the computational complexity for any text that is computed.

E.g. getting initial value in Titlecase from email for first name:

CONCATENATE(
	UPPER(
		INITIALS(
			INDEX(SPLIT(USEREMAIL(), "."), 1)
  	    )
	)
, 
	RIGHT(
  	INDEX(SPLIT(USEREMAIL(), "."), 1), 
    LEN(INDEX(SPLIT(USEREMAIL(), "."), 1))-1
  )
)
1 Like
4

elco:

Can you build a function that works for text of any length?

I believe by this you mean a sentence with any number of words to be converted to title case.

elco:

I can’t think of how to build it.

I think you are correct. Since there is not yet inherent availability of iteration in an expression in AppSheet, as per my understanding it will not be easily possible in AppSheet.

BTW, your expression to get the name in title case out of an email address is good one.

2 Likes
5

In case useful to others - to convert a word in lowercase to sentence case (where the first letter of the first word is capitalized and the rest remain lowercase), you can create an expression using a combination of text functions. Not the full answer… but may help.

CONCATENATE(UPPER(LEFT([YourColumn], 1)), LOWER(MID([YourColumn], 2, LEN([YourColumn]) - 1)))
2 Likes