Dropdown to select registered users

I am struggling with what has to be something simple…I have registered users for my app, and now I want to make it so they can display in a drop-down and we can select one of the users. I cannot for the life of me figure out how to do this. :frowning:

Can something please tell me? I feel like I’m close but I am drowning in options and can’t get it right.

I create a drop-down, select dynamic choices, type of choices “user”, then I get stuck because I can get the right option for choices source. I just want to tell it to find the registered users in my “user” database.

do search users

that is what you put into the choices source…you search your database for users

That’s what I thought but my dropdown is blank when I do this. I checked the DB and both my development and live databases have entries that should display when I test this out.

Here are some more screenshots, maybe I’m missing something you can see?

I think your users are being displayed but you haven’t set an options caption so it’s just displaying as blank text

Your ‘do a search for users’ will find all the Users in your database, but it won’t tell your dropdown menu what data you want to display about those users in the dropdown.

For that you need to select an ‘Option Caption’ to choose which field from your user datatype you want to display.

Bingo that was it! Thanks, @adamhholmes!

Posting a screenshot of the setting for this thread so future questions like this will be answered via this thread.

3 Likes

Hi Adam,

I tried doing this, but my dropdown is still displaying blanks. I’m trying to display the current user’s clients by their username. In my database, the data type ‘Clients’ is a list of users.