Dear All,
I would like to use a column from another table in expression
I have a table "Alarms_SP". IN this table, I have following columns:
Zone1_temp, type Number
Zone1 Warning, type number
Zone1 High, type number
Zone1_TCN_Fault, type text
I am using following expression for the column "Zone1_TCN_Fault:
IFS(
([Zone 1 Temp] < [Zone1_Warning]), "Zone 1 temp OK",
AND (([Zone 1 Temp] >[Zone1_Warning] ) , ([Zone 1 Temp] <[Zone1_High] )), "Zone 1 temp warning",
([Zone 1 Temp] >[Zone1_High] ), "T1 over heat!",
)
However, in this expression, instead of "zone1_temp", I would like to use a column "Zone1_TCN1_MVChan1" from another table "signals"
I have tried [signals].[Zone1_TCN1_MVChan1] in the expression but that does not work
Please advice how to solve this issue?
Thanking you in advance
https://support.google.com/appsheet/answer/10108207?sjid=2392921709354553841-AP
You typically use a select statement or Lookup statement to get a value from another table. Or if you have a reference field to that table you can use a dereference expression.
Thanks TeeSee1, I tried but could not manage to get the value.
What I would like to do is get the column "Zone1_TCN1_MVChan1" (which is part of another table) in "zone1_temp" which is part of present table.
Which column should be defined as Ref column ?
THanks
How are the two tables, Alarm=SP and signals, related?
When you say you want to use "Zone1_TCN1_MVChan1", how do you identify the row you want (assuming signals have multiple rows )?
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |