New functions: STARTSWITH() and ENDSWITH()

11 Likes

Really Steve? You’re just gunna hit me with these as I wrote this:

:stuck_out_tongue:

6 Likes

Ask and ye shall receive.

3 Likes

Amazing, i have no use for that yet, but eventually i will. partyparrot (Appsheet)

2 Likes

I’m curious the use cases people can think of for this; I’m… drawing a blank.
Any ideas would be appreciated to get the juices flowing
Turn on the juice and see what shakes loose

The examples in each doc have a use-case: email conditionals. ENDSWITH("@gmail.com", [Email]) is conceptually simpler and more efficient than ("gmail.com" = INDEX(SPLIT([Email], "@"), 2)).

5 Likes

Alrighty, this came handy replacing some janky text based expressions in a little of my secret sauce around triggers and workflows…

I decided to make it a tip and trick:

5 Likes