PROPER() Function

[Austin]

PROPER() function.
Takes in a text returns the text with all first letters capitalized

[Derick_Paula]

2 years and still thsi function is nowhere  to be found...

[hien_nguyen]

Please update this function asap

[Saddam]

It is very important why appsheet still didn't made?

[SkrOYC]

Maybe because important doesn't mean easy nor simple?

[Saddam]

@SkrOYC it is common things. and it is important, easy and simple.

if you want to make an app for users, client or employee register then you will feel emptiness of this function. I highly recommend 

[SkrOYC]

I'm not against it, but there has to be a reason why it hasn't been implemented, and I think it's not easy nor simple.
Maybe it needs more computing than expected, IDK

[Math]

INITIALS(upper([Prénom]))&mid([Prénom],2,99)

[hien_nguyen]

H admin @mroddy  @Mike_Moss , @lizlynch 

Why do some necessary functions such as Proper, Datedif, RegexExtract, and RegexReplace not appear on Appsheet?

[wabrian]

Thank you for bumping this thread. I am filing internal feature requests for the following functions:

Proper (this thread)
RegexExtract   (https://www.googlecloudcommunity.com/gc/Feature-Ideas/REGEX-expressions-and-an-optional-occurrence-p...)
RegexMatch
RegexReplace
DateDif

We will strongly consider developing and supporting them. Thanks to everyone for the suggestions and helping us make AppSheet a better product. Apologies for the mightily late response.

[hien_nguyen]

Hi @wabrian 

I don't undertand why is a very very minor feature but usefully, din't be updated after many year! What are you doing for Appsheet better than day by day?

[Joseph_Seddik]

---

@hien_nguyen wrote:

I don't undertand why is a very very minor feature

---

Compiling a text processor and especially a Regular Expressions interpreter is by no means a "minor feature" per se, without adding another level of complexity by the need to interface them with a low-code interpreter like AppSheet's. The same applies for dateTime calculations. 

The AppSheet platform makes the complex simple for the AppSheet developer. And whenever one finds something simple, one should admire the complex backend engineering that made it that simple. 

[Joseph_Seddik]

@wabrian Thank you!

[hien_nguyen]

---

@Joseph_Seddik wrote:

Compiling a text processor and especially a Regular Expressions interpreter

---

If you find the Proper() function difficult, then you might find all the other features difficult too.