Does anyone experience problems with expressions?

expressions
(Malaka Jayawardene) #1

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.

(Steve Coile) #2

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 Coile) #3

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 Coile) #4

Can you provide more detail on where you’re entering this expression?

(Malaka Jayawardene) #5

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