Virtual column that displays las updated row of child table

I have a table shipments and shipment_stat_reports that has a column “status” and “timestamp” at the time of the report. I want to build a virtual column that displays the last status of the shipment based on the most recent update but I don’t know how. I’ve tried with filter and select but no success

Hi @Rene_Casana
Maybe check out MAx and MAXROW
https://www.appsheet.com/Support?idx=help&p=0&is_v=1&q=MAX

1 Like
2 Likes