Reports that query labels of keys

[Ms_Margo]

Hi All - i think i have logic-ed myself into a swirl and might be confusing super basic concepts…

I am trying to make a PDF report that queries the label of a key.

Table 1:
Key: Item_ID
Label: Item_name (examples: Internal, External, Inside, Outside)

Table 2:
Key: Event_ID
Label: Event_Name
Items: Item_ID (enumlist reference)

I want to run a report on Table 2, but limit the output where the label of Table 1 contains Internal .

Anyone have any guides that could help?

Thanks!

[Marc_Dillon]

You can do a de-reference inside of a SELECT/FILTER.

help.appsheet.com

Dereference Expressions

Use a dereference expression to get a column value from the referenced row.

help.appsheet.com

SELECT()

Gather column values from row in table or slice

help.appsheet.com

FILTER()

Select rows of table or slice

Something like :

<<START: FILTER( Table , [ref-col].[label] = "X" )>>