Bind a column's value to a record

[Eduardo_dos_San]

I have two tables: “table 1” and “table trouble log”.

Table 1 shows all the machines I have in my stock

In the Trouble log table, I’ll tell you whether it’s in trouble or not.

What I want ?

I want the problem column (in table 1) to be filled with value yes ​​if status from table trouble is set to active and when its set to disabled, the value does change to no.

veja o template do que eu quero

[Steve]

The simple approach would be to add a virtual column to Table 1 that looks up the machine’s status in the trouble log and displays the desired message accordingly.

help.appsheet.com

Virtual Columns

Check out how you can use virtual columns to add more information to your app.

[Eduardo_dos_San]

@Steve,

I got what I wanted, create this chart.
I created the virtual column and used the formula:

lookup ([_ thisrow]. [machine], view, machine, availability)

It looks like this:

but how do I make it available [blank] and “Disponivel” in one only as “Disponivel”?

it’s possible ?

[gregdiana1]

Just make them the same colour ?

Or make all blanks available. What you are saying is regardless of whether it is blank or available it must be available?

Need to see the columns in question.

[Eduardo_dos_San]

Hi @Gregory_Diana

the solution I found:

I put an IF() in the formula

Thank you so much for helping my friend.

[gregdiana1]