What does True or False actually mean? How do you use it "Only if this condition is true"

AppSheet AppSheet Q&A
, , ,
1

Hey guys,

I am looking at setting an action going but as a newbie I cannot grasp what this concept means and the documentation all assumes that you already understand true or false.

Creating the ACTION

Under BEHAVIOUR it says “Only if this condition is true” = TRUE

And if I click on TRUE it gives me the option to click on my data fields.

So for example I will click on NAME

and it changes to =[NAME]true.

But then I click save on the APP. And it crashes and the error says

The availability condition ‘=[NAME]true’ of data action ‘ACTION ONE’ must return true or false

But I don’t know what it is asking me to do.

The scenario where I assumed this would work is, if the name field is filled in, then the action will run itself. I assumed NAME true would mean that if the name field is filled in, it would be classed as true. Otherwise, what does it mean?

2

For this condition will be

ISNOTBLANK([Name]) which checks that the name field is not blank, which means it is filled in.

In another example, a condition of [Name]=“Jupiter” will return TRUE if the name field contains “Jupiter” in the particular row being checked.

Basically the expression has to evaluate to a TRUE or FALSE value.

Edit: added some description and corrected a typo in the expression.

2 Likes
3

Thank you!

2 Likes