I’m playing around with Training Checks when opening up an app. I’m storing all of my training records in a table for multiple operations and multiple people. When I step into an app (the first step in any app), I want to query the table to ensure the person logged-in is qualified for this specific operation.
This means I need to match “Logged-In User” from App Info, along with App Name (Current App name matches training record names), Then return the value from the “Qualified” field in the record. These 2 queries will (should) always filter down to 1 record.
I have both queries defined on the table in the back end. They work when I run them back to back and give me the record I’m looking for.
How do I accomplish this when stepping into the app?
Aggregations do not work because they are math related and this is essentially field matching for the first 2 then returning a third for a boolean logic check.
Any thoughts/ideas?