Implement "Lets" formula for more named values (aka variables)

Suggestion Box
1

Hi! I think it’ll be create if there’s a “lets” formula so that there can be more a more named value.

1 Like
2

There are already two methods for creating variables.

One, that I use personally, is to create a table and store the variables in there.

The other, which I have not personally used, is to use a named formula on the canvas.

2 Likes
3

Yup Piet is right! There’s also Let() now that’s the same as WithName() but shorter :slight_smile:

2 Likes
4

Thanks @Piet_Strydom and @Rickard_Abraham.

I came across WithName( ) in the documentation, it has the same description as let ( ). Now that @Rickard_Abraham mentioned it, its confirmed they’re the same.

I used to use the same method as @Pierre-Alain_Schutz to hold ‘intermediate’ values in columns before using them in the ‘final’ column where the final calculation is made. But I discovered “lets” in excel where its syntax is Lets(name, value, [name, value, .......], expression), essentially it can hold arbitary number of variables direction in function.

This can make the table and the formula very clean and well documented.

1 Like
5

Another new formula, I can’t keep up…

2 Likes
6

Haha yeah it’s a lot, but rather have too much than too little!

2 Likes
7

I left out the canvas control topic, with its setcontrolvalue() and resetcontrolvalue() action formulas…