Filtered Lookups to User Table User Group Field
I would like the ability to have filtered lookups on the User Group field (on a Form) as we can do for other parent/child join fields.
There many types of User Groups that we can create, and the current lookup will display them all.
There are times when we may only want to display a certain type.
Example: Geographic Region groups
In this example, we would not want to see other group types, such as Support Teams or Departments, such as, Development, QA, Operations, etc.
Hey John, there's a pretty good workaround for this.
Create a table called Groups. A record would be the name of the group, the group field, and more info if you need (i.e: "Type" dropdown containing "Geographic Regions", "Departments", "Support Team", etc.
Create views for this new table (i.e "Geographic Region Groups")
Whenever you need a filtered group field, just create a relationship field to this table. Apply a filter to the relationship field on the form to the view you created
Justin Mauldin commented
Thanks for always coming up with great ideas to improve the product and the new features that we release.
We have now logged this idea with our Product Team to be added in future releases and updates to the system. As always, we will be sure to follow up with you directly when/if it is implemented into the system.