Hi
I am trying to make an app for my organization property control and inspection
I make two table 1. Property table 2. Inspection
The Inspection table has id ref. To the Property table and content a Status column of each inspection
How can i put a virtual column in the Property table to select and display the latest update status from the [Related Inspection column] at the end of the property table
Thank you very very much
Solved! Go to Solution.
Try:
ANY(
ORDERBY(
[Related Inspections],
[_ROWNUMBER],
TRUE
)
)
This works just great!!!
Thank you very much
May i ask further step
Can i set an automation that give me an alarm or warning when the last update is over 365 days old?
Very kind of you
There is a problem after this expression is in use
The UX chart type aggregate donuchart can only display 1 item โฆin the inline data view
Dont know what to do now
Is there any other way around ? I ld try to solve the chart problem
I have no practical experience with charts, so I have no guidance to offer.
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |