Forum Discussion

JimHarrison's avatar
JimHarrison
Qrew Champion
3 days ago
Solved

expose the User ID in a report

Jim! ToText(UserToId( [QB Username]))

Is anyone using a QB Formula field to display the user id to users in a report? The User Id looks like this "51817980.d2k9" (I changed this to something madeup, apologies if its your id.)

I have the admin console connected table and can sync the used id value to any app I want, which is my backup plan. Before I make that change I am checking to see if there is something I missed.

Use case:
We have users added to an App via a default role in a Group provisioned via SCIM. Some users may need to have an elevated Role other than the default Role. Currently the elevation is indicated by app data managers checking a box on a record. The check box indicates these users require an elevated role change.

When users requiring access to the elevated role are indicated, someone has to compare the record in the table and the role in the users table and align or normalize the values ~ that someone also has to be knowledgeable about the process.

I have found several Give Feedback where we have asked for the Role and linked them all together in hopes of clarity. If this is something you want too open Give Feedback and search for Role.