Django Form ChoiceField with Queryset

Question

I need to get the other users of the firm within the ModelForm to set the main user, I do not know how to get variables inside the form for this?

In the view the variable needed would be:

request.user.profile.firm

This is the form that needs to be created.

class FirmForm(forms.ModelForm):

    primary = forms.ModelChoiceField(
        queryset=User.objects.filter(name=request.user.profile.firm))

    class Meta:
        model = Firm

The Profile Model:

class Profile (models.Model):
    user = models.OneToOneField(
        settings.AUTH_USER_MODEL, on_delete=models.CASCADE)
    firm = models.ForeignKey(
        Firm, on_delete=models.CASCADE, null=True, blank=True)


    def __str__(self):
        return str(self.user.username)

The Firm model

class Firm (models.Model):
    name = models.CharField(max_length=100)

    def __str__(self):
        return str(self.name)

can you be a little clear?? the question is not clear enough — Exprator, Dec 20 '17 at 08:41
I need to get all the other users of the Firm to set the Primary user in the ModelForm. so I need to find a way to query the Users for all of them with the same Firm name. is it possible? — diogenes, Dec 20 '17 at 08:45
please refer this question: https://stackoverflow.com/questions/3532316/django-forms-request-user — Vijesh Venugopal, Dec 20 '17 at 09:13

Exprator · Accepted Answer · 2017-12-20T09:32:31.173

4

primary = forms.ModelChoiceField(
        queryset=User.objects.filter(name=request.user.profile.firm.name))

use this in your model form

in views where you are accessing the Form

FirmForm(request=request)

edited Dec 20 '17 at 09:32

answered Dec 20 '17 at 09:01

Exprator

26,992
6
47
59

it gives me an error inside the form with a request. – diogenes Dec 20 '17 at 09:26
primary = forms.ModelChoiceField (queryset=User.objects.filter(name=request.user.profile.firm.name)) NameError: name 'request' is not defined – diogenes Dec 20 '17 at 09:29
form = FirmForm ( request.POST or None, instance = firm ) – diogenes Dec 20 '17 at 09:35

score 1 · Answer 2 · answered Dec 20 '17 at 09:59

I got this to work. the best I could do. Thanks.

def __init__ ( self,  *args, **kwargs ):
    super ( FirmForm, self ).__init__ ( *args, **kwargs )
    instance = getattr ( self, 'instance', None )
    firm = self.instance
    self.fields [ 'contact' ].queryset = Profile.objects.filter ( firm = firm )

Django Form ChoiceField with Queryset

2 Answers2