Chained dereference expressions for LIST TYPE

Is it possible to Chain Dereference LIST TYPE Columns. I have 3 tables

Table1(Parent of Table2)

Table2 (Parent of Table3)

Table3

Is it possible to Dereference the Related Column from Table1 to Table3 i.e something like

[Related Table2][Related Table3][Table3 column]

1 Like

Yes, with [RefColumnInTableA].[RefColumnInTableB].[ColumnInTableC]

2 Likes

@AleksiAlkio looks like he is asking List Ref top to bottom in the reference hierarchy. I tried the example you provided. Do you have any working example ? If this actually works then it would be nice.

This works on 1st level but not on 2nd and 3rd levels

Not working on 2nd level

2 Likes

Thank you for the reply @AleksiAlkio But, all these columns are of LIST type so the dot operator is not working since its a list dereference. I am able to dereference the first level i.e. [Related Table2][Related Table3] but when i try [Related Table2][Related Table3][Table3 column], its throwing error

Thank you @Rifad :blush: i can’t explain any better :smiley:

1 Like

The chained deference has different meaning that is bottom to top hierarchy referencing using dots.

Dereference expressions - AppSheet Help

1 Like

Sorry I was confused.

1 Like

Aaa.. I thought you were meaning the opposite, my mistake. With lists, not possible, unfortunately. Or at least I haven’t found the way to do it directly without SELECT expression :slightly_smiling_face:

3 Likes

Sorry for the confusion. I have also finally used the SELECT expression. It would nice to have such a feature right?

1 Like

@jyothis_m

I think one option can be that you may need an intermediate column in the parent table ( Table 2 in your case)

In table 2 , you could have a VC called say [Table3_Column3_List] with an expression something like [Related Table3][Table3 column]

Then in the grandparent Table 1, the expression could be [Related Table2][Table3_Column3_List]

2 Likes

Yes, I can see the benefit.

1 Like

Good workaround Suvrutt

3 Likes

That’s a great workaround. Thank you :blush: @Suvrutt_Gurjar

3 Likes

Thank you Aleksi and Jyothis. :+1:

1 Like