[ Goal ] : What I want to do
1 . show measure_time (ex.2023-08-28 14:20:00)
2 . show measure_value (ex.1024)
[ Descriptions ]
[ DataSet : TARGET ]
The formula I tried here is: LOOKUP([CTN], "tb_nbiot_quality_data_now", "ctn", "meas_dt")
but not work.
[ DataSet : tb_nbiot_quality_data_now (cloud database) ]
[ REQUEST ]
Teach me how to display measure_time value from another table(cloud database)
Solved! Go to Solution.
@gidae wrote:
The formula I tried here is: LOOKUP([CTN], "tb_nbiot_quality_data_now", "ctn", "meas_dt")
I believe you need to try
LOOKUP([_THISROW].[CTN], "tb_nbiot_quality_data_now", "ctn", "meas_dt")
Please take a look at the "Troubleshoot" section in the help article below to understand the need for the use of [_THISROW]
@gidae wrote:
The formula I tried here is: LOOKUP([CTN], "tb_nbiot_quality_data_now", "ctn", "meas_dt")
I believe you need to try
LOOKUP([_THISROW].[CTN], "tb_nbiot_quality_data_now", "ctn", "meas_dt")
Please take a look at the "Troubleshoot" section in the help article below to understand the need for the use of [_THISROW]
Also if you are displaying many values from one table into records of other table on a continuous basis, please consider referencing relationship between two tables instead of pulling values through LOOKUP() or SELECT() etc.
References between tables - AppSheet Help
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
16 |