Active Directory App Roles

[jweststrate]

Hello!

I have an enterprise Active Directory (AD) integration configured, and it successfully allows users to access my App. The issue I am having is that the App Roles do not seem to be working. I am on the Google ENTERPRISE Plan.

I have three AD groups as shown here. I've created custom App roles for the first two, then use the standard Admin role for the last.   --Can I use custom roles here?

In the table settings, I have a switch statement to specify who can do what. In this example, the folks who are part of the AD group that I gave the custom "Steward" role should be able to ADD and UPDATE data, however, when they login they have the READ_ONLY role. I can test this by changing the last switch in the example below to ALL_CHANGES, at which point these users can add, edit, delete. So I'm not sure the custom App Roles are working.  We are using the desktop UI if that makes a difference.

Doing a little debugging, when I create a virtual column, it is showing the custom App Role correctly. However, when I try to commit a change, I get this error. It appears to be disregarding the actual users role and default to the default option in the switch statement. I tried using the IFS statement and get the same exact results.

In the following example using the IFS statement, the user is "Admin", but the expression when making the commit shows READ_ONLY, which is incorrect. (same exact result using the SWITCH statement as shown earler.

If I understand this documentation correctly, the custom roles as shown above should work (https://support.google.com/appsheet/answer/10105082?hl=en)

Similar here in this video (https://www.youtube.com/watch?v=T-Er-0HAQQU)

Any guidance would be appreciated.

[AleksiAlkio]

Please send a support ticket as it should work, thanks.

[SkrOYC]

Make sure there are no typos in your groups.

The text at the left should be the exact one from your domain groups, the one at the right is how you will call it inside AppSheet.
Maybe there is an issue with the mapping of the groups to your role

[jweststrate]

I have created a ticket with AppSheet Customer Support and will update this thread as soon as the issue is resolved.

[jweststrate · Accepted solution]

The AppSheet developers were able to identify and fix the issue. As of approx January 28, 2025 I am able to use the AppSheet App Roles with Active Directory Integration.