Need some assistance here. I’m creating an apps for my front user to report faulty equipment to maintenance team and both tables are dynamic where users will update accordingly.
I’m currently struck with below.
A Reports[Status] - Update this column with latest Maintenance Q[Work Status] based on Maintenance Q[Date/Time]
B Related Maintenance Q to show the latest entry timestamp
Cant get my head around what formula and how? Max(Select))
I am not sure whether I understand clearly but in one of my apps I had to create something similar I guess.
What about creating new ref_type virtual column where you will be storing the latest row ID string using MAXROW() formula and then use it to retrieve needed values by dereferencing [latest_rowID].[needed_value]?
This is how statuses under different operations are being handled in my app. Thanks to this I have whole history of status change.
Hi @junjie8709 ,
Maybe try to place [Latest_Maint_ID] in Reports table and then [Latest_Maint_ID].[Work Status] dereference expression in Reports [Status] app formula (but make it virtual to always be calculated). However, if you need this [Status] value to be stored in your database, you can create a [Trigger] column to “refresh” the record manually or a kind of automation using actions to make it happen automatically. Hope it helps!
