Re: Filter data in a dropdown field, related to the data from another field
$G.assignment.groups contains all the assignment groups without any filter. This is a Global list and build on startup. So how you gets the full list. Now you need list based on your division so you should use query in select condition of assignmnet.gotup filed like below, select("name","assignment","division", [divisononform])
here assuming you have mentioned division name in each assignment group, so above will select groupname from assignment table where division value in file equals to division value mentioned on form (in field division form on your customized form)
____________________________________ Assign Kudo, if found post useful and mark it accepted if solves the issue.