I want to be able to check if the current user (by their login email) is an admin. If so, then they have certain rites.
I have two tables:
Message Table
Admin Table
In the โMessage Tableโ i use โrefโ to search the โAdmin Tableโ for users. That works, however - i want the current user (by email) to auto fill the rest - NOT a drop down menu.
Soโฆ If I am an Admin and i am in the app. I want to be able to go to the form. The form will auto populate my credentials, then i can complete the message.
Currently - it gives me a drop down menu as i have that โrefโ Type.
Thoughts?
Solved! Go to Solution.
Ah, okay. You want the Message tableโs User column value auto-populated with a Ref to the current userโs Admin table row. To do so, set the Message tableโs User column Initial value expression to something like this:
ANY(
FILTER(
"Admin",
(USEREMAIL() = [user email])
)
)
What does this mean?
Ah, okay. You want the Message tableโs User column value auto-populated with a Ref to the current userโs Admin table row. To do so, set the Message tableโs User column Initial value expression to something like this:
ANY(
FILTER(
"Admin",
(USEREMAIL() = [user email])
)
)
Man you are good! Worked perfectly!
User | Count |
---|---|
38 | |
34 | |
27 | |
23 | |
17 |