Teach me how to display measure_time value from another table(cloud database)

AppSheet AppSheet Q&A
1

[ Goal ] : What I want to do

1 . show measure_time (ex.2023-08-28 14:20:00)

2 . show measure_value (ex.1024)

gidae_0-1693228866492.png
gidae_0-1693228866492.png296×518 12.8 KB

[ Descriptions ]

  • I have two tables on appsheet
    • TARGET
    • tb_nbiot_quality_data_now (cloud database)
  • Both tables have key(CTN & ctn) values ​​in the same format. ( ex. 01240917741)
  • I tried with the vlookup formula, but haven’t found a way yet.

[ DataSet : TARGET ]

gidae_5-1693229034130.png
gidae_5-1693229034130.png1129×371 26.7 KB

The formula I tried here is: LOOKUP([CTN], "tb_nbiot_quality_data_now", "ctn", "meas_dt")

but not work.

gidae_6-1693229113479.png
gidae_6-1693229113479.png1083×313 32 KB

gidae_2-1693228866499.png
gidae_2-1693228866499.png405×154 2.84 KB

[ DataSet : tb_nbiot_quality_data_now (cloud database) ]

gidae_3-1693228866507.png
gidae_3-1693228866507.png1133×309 22.6 KB

gidae_4-1693228866514.png
gidae_4-1693228866514.png648×420 23.3 KB

[ REQUEST ]

Teach me how to display measure_time value from another table(cloud database)

2

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]

LOOKUP() - AppSheet Help

1 Like
3

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

1 Like