New functions: STARTSWITH() and ENDSWITH()

[Steve]

help.appsheet.com

STARTSWITH()

Does text begin with fragment?

help.appsheet.com

ENDSWITH()

Does text end with fragment?

[Bahbus]

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

My 2020 retrospective Announcements

To be 100% honest, for every other platform I tried to use that seemed technically more geared for what I wanted, they always failed in a bunch of other places that AppSheet already makes easy. HoneyCode, for example, has super cool custom UI editing capabilities - just drag n drop instead of hardcoded views. But, like, relational lists were impossible. Not difficult, just didn’t exist (at the time, don’t know currently). Dereferencing wasn’t a thing either. AppSheet is so good because its powe…

[Steve]

Ask and ye shall receive.

[Rafael_ANEIC-PY]

Amazing, i have no use for that yet, but eventually i will.

[MultiTech]

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

[Steve]

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)).

[Grant_Stead]

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:

Trigger Workflow With A Simple Action Button Tips & Tricks 💡

*This tip will let you trigger a workflow without having to double back and clear the trigger column. Let’s create an action to trigger a workflow that sends an email. First, every table I create has a hidden trigger column, type text. Second, let’s create a simple data change action for the table that we want to trigger on with the following expression: CONCATENATE("UNIQUE_KEY_WORDS", " - ", NOW()) The key word can be anything you want, but you’ll want it to be unique and descriptive to wha…