On step Enter - Load Tulip Table Record

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?

Hello @BillyJo,

Is there anything specific that requires you to have 2 queries for this use case? I would personally put your 3 conditions into a single query. As for aggregations, you can return “Unique Values” such as the ID of the record.

Kind Regards,
Kevin

1 Like