How to add a drop down with values(pre defined) in flask app models?

Question

I am new to flask and I want to add drop down list to a form which has pre defined values(not taking from the DB). I created a model as follows.

class DeliveryDetails(Model):

    _tablename_ = 'deliverydetails'
    id = Column(Integer, primary_key=True)
    customer_name = Column(String(250), nullable=False)
    delivery_type = Column(String(250), nullable=False)

And view as follows.

class DeliveryDetailsView(ModelView, DeleteMixin):
    datamodel = SQLAInterface(models.DeliveryDetails)
    list_columns = ['customer_name','delivery_type']
    search_columns = ['customer_name','delivery_type']
    edit_columns = ['customer_name','delivery_type']
    add_columns = edit_columns
    label_columns = {
        'customer_name': _("Customer Name"),
        'delivery_type': _("Delivery Type") }

I want to show Air, Land, Sea as Delivery Types in a drop down list. please let me know is it possible to do as I mentioned?

Nabin · Accepted Answer · 2017-09-05 06:22:47Z

5

You can use WTF forms. In your WTF form use the following field:

dropdown_list = ['Air', 'Land', 'Sea'] # You can get this from your model
seqSimilarity = SelectField('Delivery Types', choices=dropdown_list, default=1)

Alternatively:

If you are using jinja template and want to do this without WTF form, then you can pass the dropdown_list as an argument in render_template(). Finally simply loop through the list and create the select in HTML.

In view file:

@app.route("/url_you_want")
def view_method():
    dropdown_list = ['Air', 'Land', 'Sea']
    return render_template('your_template.html', dropdown_list=dropdown_list)

Then in your_template.html

<select>
{% for each in dropdown_list %}
  <option value="{{each}}">{{each}}</option>
{% endfor %}
</select>

edited Sep 5, 2017 at 6:22

answered Sep 5, 2017 at 5:40

Nabin

11.8k8 gold badges70 silver badges103 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Manura Omal Over a year ago

is there a way to do it without wtf forms?

Nabin Over a year ago

Are you using jinja template?

Manura Omal Over a year ago

assume that the dropdown list values in a table, then how to do it?

Nabin Over a year ago

In a table? Database table? html table?

Manura Omal Over a year ago

data base table. lets say delivery types were stored in a table call delivery_types

|

Collectives™ on Stack Overflow

How to add a drop down with values(pre defined) in flask app models?

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related