Dropdown to select registered users

kyle4 · 2021-01-18T16:57:47.318Z

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.

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.

Screen Shot 2021-01-18 at 11.52.51 AM2743×1231 300 KB

Screen Shot 2021-01-18 at 11.53.01 AM2695×558 46.3 KB

boston85719 · 2021-01-18T17:48:16.633Z

do search users

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

kyle4 · 2021-01-18T18:10:17.365Z

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?

Screen Shot 2021-01-18 at 1.08.05 PM1653×1105 85.1 KB

Screen Shot 2021-01-18 at 1.11.38 PM2087×1254 226 KB

Screen Shot 2021-01-18 at 1.12.57 PM2750×662 78.4 KB

dylanwares · 2021-01-18T18:13:12.524Z

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

adamhholmes · 2021-01-18T18:13:17.463Z

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.

kyle4 · 2021-01-18T18:16:12.275Z

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.

Screen Shot 2021-01-18 at 1.15.14 PM1887×1204 209 KB

nolanlord · 2025-01-12T21:31:26.159Z

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.

image526×580 24.3 KB