Trying to pass a QuerySet as initial data to a formset

Shawn Inman picture Shawn Inman · Jul 17, 2011 · Viewed 17.8k times · Source

I'm trying to build a page for an inventory system that will allow a user to update a quantity of items received.

I want to show a table of all products and let the user enter the quantity received, which I'll post and iterate over to update the database.

Here is my view:

def new_shipment(request):
    list_of_active_products = Product.objects.filter(status=1)
    ShipmentFormSet = formset_factory(ShipmentForm, extra=0)
    formset = ShipmentFormSet(initial=list_of_active_products)
    return render_to_response('inventory/new_shipment.html', {'formset': formset})

Here's my model for the form:

class ShipmentForm(forms.Form):
    sku = forms.IntegerField()
    product_name = forms.CharField(max_length=100)
    quantity = forms.IntegerField()

And here is the form template:

<form method="post" action="">
    <table>
        {% for form in formset %}
    {{ form }}
    {% endfor %}
    </table>    
    <input type="submit" />
</form>

And here is the error I'm getting:

Caught AttributeError while rendering: 'Product' object has no attribute 'get'

Can anyone help me out with this?

Answer

gellej picture gellej · Dec 22, 2012

You can also use the queryset argument. This should work:

formset = ShipmentFormSet(queryset=list_of_active_products)

cf. https://docs.djangoproject.com/en/dev/topics/forms/modelforms/#changing-the-queryset