Creating double references Hello all, Is i...

AppSheet AppSheet Q&A
1

Creating double references

Hello all,

Is it possible to make a reference to reference? I.e. I have three tables that are linked. The first table is the item, then there is a detail table under that, which again becomes the item table for another layer of detail. Is it possible to reference the first table from the third one? there are unique IDs at each layer

EX: Client > order > specific items in the order

I’d like to create a slice that shows clients with items not yet delivered and has a “related undelivered items by client ID” field. The orders are delivered concurrently and piecemeal but it’s still necessary to have the order layer there, since they denote specific contracts

thank you

2

The best thing to do is to create a helper column on the middle table.

3

thanks - on the spreadsheet or as a virtual column?

4

@Olivia_Bryanne_Zank Either.

5

You’d add a virtual column to the middle table that provides the next level of de-reference

6

I would say people are using normally a virtual column, but sometimes a normal column is a good choice as well. It depends what is your target.

7

great thanks! created helper columns and then de-references, works perfect