Hi Everybody!
Can you tell me, is it possible to set a constraint/filter on a repeating using a field in a connected data type
I have a list of users with each users having their profile data stored in a separate data type. Inside the profile data type, I have a location field.
I am trying to have a repeating group of users and filter it using a location field in the users connected profile data location field.
Any assistance would be much appreciated!
Thanks!
I don’t think it is possible
What you could do is make sure you have your users data be related to the user data type…then show the repeating group with data source of the profile data, which you would definitely be able to filter based on location.
When showing that repeating group, you can show the current cell’s user information.
I don’t know how this is all set up, but if you have all of the user information on the user data type such as name, image etc. except for the location, then you would reference in the repeating group the current cells ’ user : name etc.
What is the database structure and what is the reason to have the separate profile data type instead of just putting it all onto the user data type?
How are the User and Profile data types connected? Does the User type have a Profile field or vice versa? Or both?
Seems doable, but performance will be affected by the amount and structure of the data.
Okay, thanks @boston85719
It’s my first app, so it may not be set up most efficiently.
But its a recruitment site with candidates and employers.
I have a list of users with just the name email etc… and a field employer vs candidate.
Then in the profile data type is where I have stored all the candidate details.
I think my best bet, as you say, would be to have a repeating group with the data sources being the profiles
Hello, the user type has a profile field
database structure is hard to get in the beginning
Don’t be afraid to make changes to the database as you are building and find a need
I think in your situation make sure you have a related table in the profile data type to the user data type it belongs to…then as I mentioned before use the profile data type as the repeating group and just visually show the users information.
It’s doable via nested search. In the search panel, do a search for profile, and the profile being searched is based on a search itself.
In the “Search for Users” box, you’ll enter “Profile is in Search for Profiles”. The “Search for Profiles” then brings up a separate search box where you can set the location to match your filtering input.
Note that nested searches are a little slower. If the profile data for the user isn’t too data heavy, may be easier just to have everything under User vs. creating a connected entry.
