Creating double references Hello all, Is i...

(Olivia Bryanne Zank) #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

(Grant Stead) #2

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

(Olivia Bryanne Zank) #3

thanks - on the spreadsheet or as a virtual column?

(Grant Stead) #4

@Olivia_Bryanne_Zank Either.

(Praveen Seshadri (AppSheet)) #5

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

(Aleksi Alkio) #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.

(Olivia Bryanne Zank) #7

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