Referencing another table - for user roles, but use the current user email?

[Tiger1]

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?

[Steve]

Tiger:

i use “ref” to search the “Admin Table” for users

What does this mean?

[Tiger1]

[Tiger1]

[Steve · Accepted 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])
  )
)

[Tiger1]

Man you are good! Worked perfectly!

[Laurene_Haynesw]