Table(X) column to show the latest status based on timestamp from table(Y)

Hi, 

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)) 

Appreciate any guidance. Thank you in advance

UX card view for Reports data

View.PNGView2.PNG

Updates, Adds & DeletesUpdates,  Adds & DeletesUpdates, Adds & Deletes

 Updates, Adds & DeletesUpdates,  Adds & DeletesUpdates, Adds & Deletes

 

Solved Solved
0 7 834
1 ACCEPTED SOLUTION

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!

View solution in original post

7 REPLIES 7
Top Labels in this Space