Hi all ,
Thanks to @cmarchan and @ken1 suggesting privacy rules as a possible source of my app misbehaving, I have found a way to move forward Both were correct in their suspicion that privacy rules could be causing the anamoly. I will be marking @cmarchan post as a solution because my request was a workaround and he helped me find it.
However, I want to highlight the fact that my conclusion is that while a problem in privacy was a key source of the error, that error was caused by a bug in Bubble that needs to be addressed as in different circumstances it might have gone undetected and could have seriously impacted the security of my app. .
I will be attaching this post to my updated bug report. The core issue was not a user error in the privacy rules, it was a combination of bugs. The reason that I did not consider privacy as a possible cause in the first place is bug number 2. It could also allow the error to go undetected under the right circumstances.
1.) Bubble is currently did not identifying input boxes that used the deleted field (User’s user_Type) as having an error.
2.) More concerning still, Bubble is continuing to use the deleted field in the privacy rules for users that had values in the deleted field user_Type.
This last point was highlighted by the fact that what on the surface looks like two identical users in terms of the roles (userTypes) they have in their list of userType are treated differently in terms of being redirected based on the uncorrected privacy rule (the one with the deleted privacy rule).
In the table of test users below, user 1 and user 4 have identical userTypes in their list of user types but are treated very differently before any corrections to the privacy rule that uses the deprecated single value user_Type field. I cannot show the redirect in a snapshot but the I embedded text that displays what the users name, email and userTypes should be. As you can see, user 1 and user 4 get very different results in terms of the text fields added and the banners that they are allowed to see.
Table of Users
User 1 and User 2 have identical permissions. but this fact is not reflected in the systems decision to show them menu items nor to even print out their userType information.
Menu When statement
editor view of debugging text added to navigation page
User 1
User 2
If anyone disagrees with my assessment of the bugs, please let me know.
Another shout out to @cmarchan and @ken1 for helping me figure out how this bug was affecting my app and by doing so allowing me to move forward.
If anyone believes that I might be mistaken in my conclusion that this is a bug, please suggest an alternate explanation.
Cheers,
Kevin