I am making an improvement to our maintenance request app.
In some cases, we require a Root Cause Analysis to accompany a work order.
I've been able to separate out work orders that have an associated RCA and those that do not:
In the detail view for these entries, I'd like a message to appear if the work order has an underlying RCA, something like this:
My crude attempt was a Show column, and I tried the following Show If expression:
AND(View = Open Work Requests_Detail, [Is this request associated with a near miss incident requiring a Root Cause Analysis?]=TRUE)
AppSheet was fine with the expression, but it didnt appear in the detailed view.
I'm not sure if I'm on the right track. I'm open to minor tweaks as well as major overhauls.
Thanks!
-Andrew
User | Count |
---|---|
16 | |
10 | |
9 | |
8 | |
3 |