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.
Cant get my head around what formula and how? Max(Select))
Appreciate any guidance. Thank you in advance
UX card view for Reports data
Updates, Adds & DeletesUpdates, Adds & Deletes
Updates, Adds & DeletesUpdates, Adds & Deletes
Solved! Go to 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!
User | Count |
---|---|
24 | |
13 | |
4 | |
3 | |
3 |