Dropdown list not showing all elements (users)

Need help Database
1

Hi all,

I’m creating a dropdown list which needs to show the users (currently 3) but it’s only showing one. I tried different things but doesn’t seem to work. For me it looks fine:

  • Type of choice = User
  • Choices source = Search of users (no constraints)
  • Option caption = Current option’s name

Anyone that has faced similar issue or who has any clue?

Many thanks!

2

The default privacy rule for Users only allows Users to be accessed by themselves.

So update your Privacy rules accordingly.

3

Thanks for the prompt reply. Where can I find that? I’ve been checking the different tabs in the settings page. Thanks again.

4

On the Data tab > Privacy

5

Thank you for your message.
I have the same problems with him and just fixed based your answer.

2 Likes
6

Thanks that worked. So if I search for all users in the User table, I got all of them.

Now I’m trying to go a bit more complex and I’m back to a single element. I have a table that defines the Friendship between 2 users (user1 and user2). So to find the friends of a user I’m doing a search in the Friendship table returning a user’s list.

The search is as follows Search in Friendship table where user1 = current user and return user2 merged with search in Friendship table where user2 = current user and return user1.

In my head this should work, but somehow it doesn’t :frowning: any clue?

7

Solved, it was a data issue. Thanks!