Can I authorize a user depending the projects they're assigned?

Wappler General How To
#1

I want users can access (or not) a restricted page, depending a database.

I have 3 tables:

  1. Users:

    image
    image866×84 17.1 KB

  2. Projects:
    image

  3. Assignments:
    image

Can I authorize or unauthorize an user, depending the assignment?

I use this:

image
image904×522 12.9 KB

Sometimes works, sometimes not. So I assume is not an apropiate way to achieve this.