Read data from an unreferenced table.

[Gambeta]

Hello, I have a doubt with Show_If.
I need to read the value of a Yes/No field of a master table that tells me whether or not I should show certain fields of the data table.
Two important facts:
1. The master table is not related in any way to the data table.
2. The master table only has one record.
Thanks for your great help.

[Joseph_Seddik · Accepted solution]

Since your master table has only one record, you can use this expression to retrieve the value of your Yes/No column, and since it is a Yes/No value, you can use the expression as is in the Show if field:

ANY(masterTableName[Yes/No columnName])

[Marc_Dillon]

https://help.appsheet.com/en/collections/377977-expressions

[Joseph_Seddik · Accepted solution]

Since your master table has only one record, you can use this expression to retrieve the value of your Yes/No column, and since it is a Yes/No value, you can use the expression as is in the Show if field:

ANY(masterTableName[Yes/No columnName])

[Gambeta]

Perfect solution.
Abusing your knowledge, I would like to know what happens if the master table has more than one record and I want to see the value of a field of a certain row: first, last or row number.
Thank you very much for everything.

[Joseph_Seddik · Accepted solution]

First or last: INDEX()

Others: SELECT()