This is my situation. How can i create the FI...

references
(Francesco Frosi) #1

This is my situation. How can i create the FILTER? The only result is: JUNE, JUNE. I can’t “reach” the “NAME” in table 1. Thank for the tips

(Tony Fader) #2

@Francesco_Frosi Make your Type column in Table 2 a reference column to Table 1. Then add a virtual column to Table 2 with the formula [Type].[Name]. That makes the name available in Table 2.

help.appsheet.com - References Between Tables References Between Tables help.appsheet.com

(Tony Fader) #3

https://help.appsheet.com/expressions/expression-types/dereferences

(Francesco Frosi) #4

Ok ty @tony. but i can’t see the VIRTUAL COLUMN inside a view (or a slice) for the table 2. Why? I only see the REAL COLUMN of the table…

This issue came from the filter. When i filter over TABLE 2, i want to show the name referenced in table 1, but i can see only real columns.

(Tony Fader) #5

@Francesco_Frosi If you’re using a slice, you need to make sure to include the virtual column in the slice definition. Slices can filter both rows and columns.