I have an application with multiple users. On one of the app’s pages, I have a dropdown menu attached to locations on a map. The user can choose a location and the data related to that location will appear. I would like for the dropdown list to only show that user’s location, and not all locations. How do I do it?
I have set up an option set hoping I could do it that way but I can’t figure it out.
I have tried the privacy options and it didn’t work.
The logic just isn’t logicing for me.
Your explanation of the problem is brief so I may be misunderstanding.
First I assume each user has several locations? Otherwise why the dropdown menu?
If there are multiple locations associated with a user then in your database you need either or both of
In User, a field that holds a list of their locations (eg MyLocations)
or
In location, a field that lists the associated users (eg LocationUsers)
In the first case the dropdown would simply show Current User:MyLocations
In the second the dropdown would show Locations:Filtered - LocationUsers contains Current User
Your question doesn’t provide all the details about how your app is set up, but based on what you’ve shared, here’s a suggestion:
If users are assigned to specific locations, you can use conditional logic or an additional dropdown to filter items related only to the user’s assigned location.
Here’s how you can approach it:
Set up a field in your Location database that links each location to a specific user (e.g., Assigned User or Owner).
In your dropdown’s data source, apply a constraint like this: Assigned User = Current User
If you need a more dynamic solution, you can use another dropdown to filter locations first, and then populate related items in subsequent fields. For example:
Dropdown 1: User’s location (filtered by Current User)
Dropdown 2: Items related to the selected location
If this doesn’t address your exact issue, feel free to provide more details about your app’s structure—I’d be happy to help you troubleshoot further!
About Us:
I’m from If-dev, a Bubble agency helping businesses build and optimize apps. If you’d like more in-depth support or are looking for someone to help streamline your app development, reach out anytime:
Email: 
LinkedIn: 
Website: