I'm very confused about the different behavio...

(COMACEP AEP) #1

I’m very confused about the different behavior from one App I have build some weeks ago, and another one I’m building now. Could be a bug? The problem happens with tables that result from a query function. The view for that table in the old App display all the rows. The new one do not display the first row (the one that have the formula). See the pictures below:

(Aleksi Alkio) #2

Both are read_only tables / read_only fields?

(COMACEP AEP) #3

@Aleksi_Alkio Yes, both are read_only.

(Aleksi Alkio) #4

Do you still have an issue with this one?

(COMACEP AEP) #5

Yes. I tested it again with same result.

(Aleksi Alkio) #6

What is your account ID and the app name. I can quickly check the reason if it’s okay for you.

(COMACEP AEP) #7

@Aleksi_Alkio Yes. I will make an example for you with name fields in English.

(COMACEP AEP) #8

Well, well, well, when I’m building the example in English to send to you I found that the problem is not with AppSheet. At least, reveal why AppSheet build the things differently in some cases.

This: =QUERY(Customers!A2:D;“select B, C where D = ‘Y’”) gives the same result of this =QUERY(Customers!A2:D;“select B, C where D <> ‘N’”) right? (if all D rows have one of these values Y or N)

So, in the example I have build, I got this:

ID

Result William Hudson hudson@nostromo.com Ellen Ripley

ripley@auriga.com Maria de Lourdes maria_lurdes35@hotmail.com

Where is the problem? Well, if I change the range from A2:D to A:D the difference comes up:

First query gives this: ID

Result William Hudson hudson@nostromo.com Ellen Ripley

ripley@auriga.com Maria de Lourdes maria_lurdes35@hotmail.com

The second one gives this: ID

Result Name

Email William Hudson hudson@nostromo.com Ellen Ripley

ripley@auriga.com Maria de Lourdes maria_lurdes35@hotmail.com

Thank you for your help, because lead me to understand what’s happen.

(Aleksi Alkio) #9

I believe it would be better to use the expression like… QUERY(Customers!A2:D;“select B, C where D = ‘TRUE’”)

(COMACEP AEP) #10

Ya, you are right. I rarely use “True”/“False” because I can’t use it in my own language (must be “S”/“N” instead of “Y”/“N”). So, normally, I use Text/Enum field types.