Does anyone experience problems with expressions?

Iโ€™m finding the simplest of expressions not working. Does anyone have the same issue? When I type in a simple expression like [Specify a Time Period?]=โ€œYesโ€, it says โ€˜Unable to find the column [Specify a Time Period?], which is weird because that column is right there in the same table that Iโ€™m writing the expression for. Any particular reason for this? Or does AppSheet have issues when a column name has โ€˜?โ€™ in it? Would appreciate expertsโ€™ input on this.

0 4 339
4 REPLIES 4

Steve
Platinum 4
Platinum 4

Iโ€™d expect it to work. Perhaps you somehow inserted a question-mark look-alike character? Test by removing the apparent question-mark from the column name and recreate your expression with the new name.

Steve
Platinum 4
Platinum 4

Note, too, you donโ€™t need to compare Yes/No values to Yes or No. Both of the following are exactly equivalent:

[Specify a Time Period?]="Yes"

and:

[Specify a Time Period?]

Steve
Platinum 4
Platinum 4

Can you provide more detail on where youโ€™re entering this expression?

Steve I made another query here. I have put more details in that one. Thank you for your response.

Top Labels in this Space