Show? condition based on a field from another table

Hi everyone, how are you?

I'm getting started with AppSheet and I need your help with a question.

I have two tables, "Clientes" (Clients) and "Projetos" (Projects).

I want to display a field in the "Projetos" table based on the input of information in the "Clientes" table. For example: In the "Clientes" table, I have a field called "TipoCliente" (ClientType), which collects the selected information [Enum], in this case, "Pessoa Física" (Individual) or "Pessoa Jurídica" (Legal Entity). And in the "Projetos" table, I want to display a field "A_DocImovel" if the "TipoCliente" [Clientes] field is selected as "Pessoa Jurídica" (Legal Entity).

Note: I have related the two tables through a field "NomeCliente" (ClientName) existing in both tables.

I tried some codes that I found in the "Show?" condition, but I didn't succeed. Could someone help me? Thank you.

higorgoncalves_0-1704484037235.png

Update: It's returning as true, however, the field is not displayed.

higorgoncalves_0-1704486527704.png

 

 

Solved Solved
0 1 113
1 ACCEPTED SOLUTION

The condition expressed earlier solves the issue; I simply forgot to save the changes.  🤣🤣

View solution in original post

1 REPLY 1

The condition expressed earlier solves the issue; I simply forgot to save the changes.  🤣🤣

Top Labels in this Space