Solved: Dropdown list limited to the user ID - Page 2

Peter_S1 · 04-11-2021 06:03 PM

Hi,

I have an Enum list dropdown that links to a Company Name column in a Company table. I also have a Users table where it lists all the users and which company they belong to. These tables are referenced by Company ID.

I would like the Enum list of company names to only show company/companies to which the user belongs to. I’m thinking that the reference does not need to be used here. Maybe just the Users table which only allows choices by userid(). Is there an expression that would accomplish this in the Valid If section? Or other way to get this to work?

Aurelien

Hi @Peter_S1

You may want to use a SELECT formula into the “suggested value” area of your column.
Many possibilities exist.

This article may help you:

These posts are solved and may help you as well

Let us know if you are still having trouble developing the SELECT or FILTER formula.

View solution in original post