Help with Dynamic Choices in Dropdown

[brunosvanci]

I have two data types:

1. “User”, with fileds like name, email and company_name
2. “Location”, with fields like location_name and company_name

I need to create a “location_name” dropdown but only show options related to the company the user works on (based on the “User” data type relationship).

Right now I am only able to show all locations, without the constraints with the following:

Any tips? Thanks!

[lindsay_knowcode]

In 10 words, in your “Choices source” add a search constraint that uses the User attributes as a filter.

[mikeloc]

You on a word diet, @lindsay_knowcode?

To add a bit more clarity, add a constraint to your Search for Locations where company_name = Current user's company_name. That should do the trick.

Best…
Mike

[brunosvanci]

legend! Thank you!

[lindsay_knowcode]

@mikeloc Yes I should have put in a bit more effort on that one.