Security Asssit User (Groups/Levels)

Adding UserGroup to existing users_update page: I added a static dropdown value = to:<?php $row_WADAusers['UserGroupID'] ?> and added <?php echo $row_WADAusers['UserGroupID']; ?> to update record (users) it does not update the record. I followed same as the userCountry drop down.

I'm also adding UsersGroups, usergroup to the results page, but when i use the tables from the usergroups table whcih has 3 groups it multiplies the entries each user 3 times as each level and if i use the user, groupid it only provides a number not the text value.

as always thanks for your help

in the update record behavior, you should be binding the User Group column to the user Group form element, not to the user group column of the recordset.

to refresh what I'm trying to do:

Added a user group to the user-insert.php, now i want to update the user group from update page and have a column in the results page
Will attach three files

Thanks making big strides and some very little ones.

thanks again, let me know if you need more info

On the update page, dont add the usergroups.UserGroup column to the WADAUsers recordset, but you do need to add the users.UserGroupID column.

create a new recordset that queries the usergroups table to return the UserGroup and UserGroupID columns.

Use that recordset to populate the user group select list, same as you did on the insert page.

In the Dynamic Select list options, in the Select Value Equal to section, click the lightning bolt icon and select the WADAUsers.UserGroupID recordset column.

In the update record behavior, bind the UserGroupID column to the user group select list.

Thanks Jason, that worked perfect the last part I'm working on is the results page I need to add the Users.UsersGroup "name" to the results, I can get the numbers to show by using user.usergroupid, but I need the name to show

Thanks,

you guys have been great

you need to convert the WADAUsers query to a joined query:

SELECT UserID, UserEmail, UserFirstName, UserLastName, users.UserGroupID, usergroups.UserGroup 
FROM users
INNER JOIN usergroups
ON usergroups.UserGroupID = users.UserGroupID

Thanks Jason, I did not see where the software let me make those selections? Just ran into another problem, on the user_update page I have the user group region hidden from all except admin, but when the update is made by anyone that's not an admin it's nulls out the groupid? Do i let the drop down show but make a rule that prevents others from changing or do we need to make a change drop down?

thanks

you need to edit the wadausers recordset to change the query.


using the security assist show region behavior, set the select list to show for admins, for other user levels, replace it with a hidden form element that captures the original user level from the users table.

I tried updating as you requested with no luck, please see attached.

thanks

please provide more details.

what specifically are you having "no luck" with?

what specifically is not working?