Data not showing

AppSheet AppSheet Q&A
,
1

So I have a slice that has records when I View Data and has True when I test the expression in the expression assistant but none are showing up in my table view.

3X_b_0_b02b909f0803964877e98e2f32cb38e747ccc620.png
3X_b_0_b02b909f0803964877e98e2f32cb38e747ccc620.png1725×900 57.8 KB

My view is using the right slice.

3X_6_4_64f04c4c992efa80789503de480044f2c2ea1904.png
3X_6_4_64f04c4c992efa80789503de480044f2c2ea1904.png1896×310 22.3 KB

This is the result of hitting View Data in my slice.

3X_0_2_022af713bc964456aca70a3f2a863873cb5e5408.png
3X_0_2_022af713bc964456aca70a3f2a863873cb5e5408.png1470×435 17 KB

This is the results when I hit test on my expression.

This is my expression:
3X_e_8_e82f263a3c18a67dbf3e517dfd9e0049c5cabdd6.png

I’m thinking its something to do with how the Lookup returning a list interacts with IN()? Employees not working is also a virtual column so maybe it’s not loaded before this expression runs?

2

LOOKUP() always returns a singular value. You’ll need to SPLIT() its return if you want it handled as a list.

1 Like
3

Is this an error in the Test of the Expression assistant because it shows Y and N values for the rows in this expression just as expected?

4

As I understand it, Expression Assistant, the servers, and the app all have independent implementations of the expression interpreter, and each have their own quirks.

5

3X_4_3_4308c9e87d63aeb834213c68fbbfdb9886eb42bf.png
3X_4_3_4308c9e87d63aeb834213c68fbbfdb9886eb42bf.png639×115 3.53 KB

Am I just having a brain fart because this is now returning a result just only the first result?

3X_0_a_0afce0a3da59ae02f6e5e7d81d36777f182937e9.png
3X_0_a_0afce0a3da59ae02f6e5e7d81d36777f182937e9.png565×158 8.83 KB

This is the list it’s supposed to return.

6

Now I am getting some extremely strange behavior that will be getting a support ticket. So I have the lookup as a virtual column now to make sure its returning the data correctly but when I save the app, my columns return blank but if I sync a few seconds later they show up.

7

Virtual columns, outside a row being edited in a form or modified by an action, are recomputed by the server during a (background) sync, as I understand it. Hence a delay.

8

But it isn’t just a delay on when I open the app and they stay after. They vanish when I refresh on a different view as well and don’t come back without a refresh on that view where they are displayed.
And they only have this vanishing behavior when I’m looking up this virtual column of a different table. On that table itself the columns appear instantly on sync and are never blank.

9

Do you think turning these virtual columns into real columns filled in by formulas would be a good idea?

10

I try to avoid virtual columns as much as possible.

1 Like