New functions: STARTSWITH() and ENDSWITH()

AppSheet Tips & Tricks
1

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

[My 2020 retrospective](https://community.appsheet.com/t/my-2020-retrospective/36705/8) 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…

3X_9_f_9f1a38e3e1d529de61070e8e7a3ff05a807d4e7a.gif

6 Likes
2

Ask and ye shall receive.

3 Likes
3

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

2 Likes
4

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

3X_2_c_2c0bad16fe039654588d8efe36a9311a8f3e6d77.gif

5

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
6

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](https://community.appsheet.com/t/trigger-workflow-with-a-simple-action-button/36847) 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…

5 Likes