Jump to content
  • 0
JoshuaJobin

Using List Data Type in Authentication

Question

I am in need of using a list - string in authentication. 

I would like to have a list field with "roles", and when a datapage loads, I access the values through the authentication fields. It could equate to a comma separated string, then I would just compare to see if the role is contained in the string. 

The List - String datatypes currently do not show up, but is there a way around this? Maybe by using a formula field to create our own string from the List datatype? 

Currently, I have each role as a Yes/No column, but it is getting pretty hectic with many roles. I would like to limit it to a few columns if possible.

 

Has anyone encountered this yet?

Thanks,

Josh

Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

  • 0

What if you add a  new row for each user with new role when you have a Role table. So you have:

Usertable: UserID (Unique)

RoleTable: User_ID, Role

Then you can create a view to get the roles and create your authentication based on this view

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×