In my application, there are three columns for each user in the default Group; Name, Details, and Member Type.
I would like to add additional fields for users so that we can separate them based on their roles and grant them different access.
Is there a way to add additional fields to the user groups? I tried to do some research into this and it seems like Group Types are the way to go but I am unable to figure out how to set it up. Specifically, I want to add something like these fields to the user table.
<Name> <Region> <Country> <Department>
Do I create a Group Type for each new column? How do I add the values for each field so it can be a drop down list?
Thanks.
Discussion posts and replies are publicly visible
You can store these details into one table namely user access and then create a view using this table and the main table which will join the rows with necessary matching values and will reduce the need to create group for each unique combination.