Ever wondered which formulas come out of the box in the Canvas App Editor? Fear no more, you can easily view per type which formulas are available without even leaving the Editor.
Just a press on the formula icon show up a dropdowlist of all the available types and their according formulas.
When you know you want to use a text value, just click text and all the available functions will show:
You will be able to do this for each known type. Hope this helped you and speeds up your development process!