If Then Else - Calculate on the "Then"

Ask for Help
1

Hi I need to be able to calculate within the “THEN” part of the statement

Screenshot 2020-05-27 at 14.19.55
Screenshot 2020-05-27 at 14.19.55704×836 28.9 KB

But all I can enter for the THEN section is a column title OR a math statement - not both
Screenshot 2020-05-27 at 14.18.48
Screenshot 2020-05-27 at 14.18.48702×850 27.5 KB

Is there any way I can use a column plus a math statement ?

2

Add a math column in your Glide data, calculate the (Working Fee/2)*(.05) for all cases. Let’s say it’s named “Fee”.

Then add an If > Then > Else stating:

  • If At full bareme? is True then Fee (assign the column).
  • Else 0.
1 Like
3

Thank you for the work arround - Strange that the THEN part of the statement can’t include a calculation !
Mike

2 Likes
4

Thanks - that worked just fine -
and thanks to the Glide team - App No.2 now finished - loving it !

1 Like
5

@Mike_Greene great suggestion! It makes total sense that glide should work the way you originally tried.

2 Likes
6

I know what you feel @Mike_Greene

I have been waiting something like this too:
image

In this way, we could write values to any field directly and have some kind of logic within Data Editor and make it more powerful. My example will be the easiest way to create a reset button and clear other fields/values directly.

Saludos

2 Likes