2017-12-19T19:08:21Z

The Flask Mega-Tutorial Part III: Web Forms

This is the third installment of the Flask Mega-Tutorial series, in which I'm going to tell you how to work with web forms.

For your reference, below is a list of the articles in this series.

Note 1: If you are looking for the legacy version of this tutorial, it's here.

Note 2: If you would like to support my work on this blog, or just don't have patience to wait for weekly articles, I am offering the complete version of this tutorial packaged as an ebook or a set of videos. For more information, visit courses.miguelgrinberg.com.

In Chapter 2 I created a simple template for the home page of the application, and used fake objects as placeholders for things I don't have yet, like users or blog posts. In this chapter I'm going to address one of the many holes I still have in this application, specifically how to accept input from users through web forms.

Web forms are one of the most basic building blocks in any web application. I will be using forms to allow users to submit blog posts, and also for logging in to the application.

Before you proceed with this chapter, make sure you have the microblog application as I left it in the previous chapter installed, and that you can run it without any errors.

The GitHub links for this chapter are: Browse, Zip, Diff.

Introduction to Flask-WTF

To handle the web forms in this application I'm going to use the Flask-WTF extension, which is a thin wrapper around the WTForms package that nicely integrates it with Flask. This is the first Flask extension that I'm presenting to you, but it is not going to be the last. Extensions are a very important part of the Flask ecosystem, as they provide solutions to problems that Flask is intentionally not opinionated about.

Flask extensions are regular Python packages that are installed with pip. You can go ahead and install Flask-WTF in your virtual environment:

(venv) $ pip install flask-wtf

Configuration

So far the application is very simple, and for that reason I did not need to worry about its configuration. But for any applications except the simplest ones, you are going to find that Flask (and possibly also the Flask extensions that you use) offer some amount of freedom in how to do things, and you need to make some decisions, which you pass to the framework as a list of configuration variables.

There are several formats for the application to specify configuration options. The most basic solution is to define your variables as keys in app.config, which uses a dictionary style to work with variables. For example, you could do something like this:

app = Flask(__name__)
app.config['SECRET_KEY'] = 'you-will-never-guess'
# ... add more variables here as needed

While the above syntax is sufficient to create configuration options for Flask, I like to enforce the principle of separation of concerns, so instead of putting my configuration in the same place where I create my application I will use a slightly more elaborate structure that allows me to keep my configuration in a separate file.

A format that I really like because it is very extensible, is to use a class to store configuration variables. To keep things nicely organized, I'm going to create the configuration class in a separate Python module. Below you can see the new configuration class for this application, stored in a config.py module in the top-level directory.

config.py: Secret key configuration

import os

class Config(object):
    SECRET_KEY = os.environ.get('SECRET_KEY') or 'you-will-never-guess'

Pretty simple, right? The configuration settings are defined as class variables inside the Config class. As the application needs more configuration items, they can be added to this class, and later if I find that I need to have more than one configuration set, I can create subclasses of it. But don't worry about this just yet.

The SECRET_KEY configuration variable that I added as the only configuration item is an important part in most Flask applications. Flask and some of its extensions use the value of the secret key as a cryptographic key, useful to generate signatures or tokens. The Flask-WTF extension uses it to protect web forms against a nasty attack called Cross-Site Request Forgery or CSRF (pronounced "seasurf"). As its name implies, the secret key is supposed to be secret, as the strength of the tokens and signatures generated with it depends on no person outside of the trusted maintainers of the application knowing it.

The value of the secret key is set as an expression with two terms, joined by the or operator. The first term looks for the value of an environment variable, also called SECRET_KEY. The second term, is just a hardcoded string. This is a pattern that you will see me repeat often for configuration variables. The idea is that a value sourced from an environment variable is preferred, but if the environment does not define the variable, then the hardcoded string is used instead. When you are developing this application, the security requirements are low, so you can just ignore this setting and let the hardcoded string be used. But when this application is deployed on a production server, I will be setting a unique and difficult to guess value in the environment, so that the server has a secure key that nobody else knows.

Now that I have a config file, I need to tell Flask to read it and apply it. That can be done right after the Flask application instance is created using the app.config.from_object() method:

app/__init__.py: Flask configuration

from flask import Flask
from config import Config

app = Flask(__name__)
app.config.from_object(Config)

from app import routes

The way I'm importing the Config class may seem confusing at first, but if you look at how the Flask class (uppercase "F") is imported from the flask package (lowercase "f") you'll notice that I'm doing the same with the configuration. The lowercase "config" is the name of the Python module config.py, and obviously the one with the uppercase "C" is the actual class.

As I mentioned above, the configuration items can be accessed with a dictionary syntax from app.config. Here you can see a quick session with the Python interpreter where I check what is the value of the secret key:

>>> from microblog import app
>>> app.config['SECRET_KEY']
'you-will-never-guess'

User Login Form

The Flask-WTF extension uses Python classes to represent web forms. A form class simply defines the fields of the form as class variables.

Once again having separation of concerns in mind, I'm going to use a new app/forms.py module to store my web form classes. To begin, let's define a user login form, which asks the user to enter a username and a password. The form will also include a "remember me" check box, and a submit button:

app/forms.py: Login form

from flask_wtf import FlaskForm
from wtforms import StringField, PasswordField, BooleanField, SubmitField
from wtforms.validators import DataRequired

class LoginForm(FlaskForm):
    username = StringField('Username', validators=[DataRequired()])
    password = PasswordField('Password', validators=[DataRequired()])
    remember_me = BooleanField('Remember Me')
    submit = SubmitField('Sign In')

Most Flask extensions use a flask_<name> naming convention for their top-level import symbol. In this case, Flask-WTF has all its symbols under flask_wtf. This is where the FlaskForm base class is imported from at the top of app/forms.py.

The four classes that represent the field types that I'm using for this form are imported directly from the WTForms package, since the Flask-WTF extension does not provide customized versions. For each field, an object is created as a class variable in the LoginForm class. Each field is given a description or label as a first argument.

The optional validators argument that you see in some of the fields is used to attach validation behaviors to fields. The DataRequired validator simply checks that the field is not submitted empty. There are many more validators available, some of which will be used in other forms.

Form Templates

The next step is to add the form to an HTML template so that it can be rendered on a web page. The good news is that the fields that are defined in the LoginForm class know how to render themselves as HTML, so this task is fairly simple. Below you can see the login template, which I'm going to store in file app/templates/login.html:

app/templates/login.html: Login form template

{% extends "base.html" %}

{% block content %}
    <h1>Sign In</h1>
    <form action="" method="post" novalidate>
        {{ form.hidden_tag() }}
        <p>
            {{ form.username.label }}<br>
            {{ form.username(size=32) }}
        </p>
        <p>
            {{ form.password.label }}<br>
            {{ form.password(size=32) }}
        </p>
        <p>{{ form.remember_me() }} {{ form.remember_me.label }}</p>
        <p>{{ form.submit() }}</p>
    </form>
{% endblock %}

For this template I'm reusing one more time the base.html template as shown in Chapter 2, through the extends template inheritance statement. I will actually do this with all the templates, to ensure a consistent layout that includes a top navigation bar across all the pages of the application.

This template expects a form object instantiated from the LoginForm class to be given as an argument, which you can see referenced as form. This argument will be sent by the login view function, which I still haven't written.

The HTML <form> element is used as a container for the web form. The action attribute of the form is used to tell the browser the URL that should be used when submitting the information the user entered in the form. When the action is set to an empty string the form is submitted to the URL that is currently in the address bar, which is the URL that rendered the form on the page. The method attribute specifies the HTTP request method that should be used when submitting the form to the server. The default is to send it with a GET request, but in almost all cases, using a POST request makes for a better user experience because requests of this type can submit the form data in the body of the request, while GET requests add the form fields to the URL, cluttering the browser address bar. The novalidate attribute is used to tell the web browser to not apply validation to the fields in this form, which effectively leaves this task to the Flask application running in the server. Using novalidate is entirely optional, but for this first form it is important that you set it because this will allow you to test server-side validation later in this chapter.

The form.hidden_tag() template argument generates a hidden field that includes a token that is used to protect the form against CSRF attacks. All you need to do to have the form protected is include this hidden field and have the SECRET_KEY variable defined in the Flask configuration. If you take care of these two things, Flask-WTF does the rest for you.

If you've written HTML web forms in the past, you may have found it odd that there are no HTML fields in this template. This is because the fields from the form object know how to render themselves as HTML. All I needed to do was to include {{ form.<field_name>.label }} where I wanted the field label, and {{ form.<field_name>() }} where I wanted the field. For fields that require additional HTML attributes, those can be passed as arguments. The username and password fields in this template take the size as an argument that will be added to the <input> HTML element as an attribute. This is how you can also attach CSS classes or IDs to form fields.

Form Views

The final step before you can see this form in the browser is to code a new view function in the application that renders the template from the previous section.

So let's write a new view function mapped to the /login URL that creates a form, and passes it to the template for rendering. This view function can also go in the app/routes.py module with the previous one:

app/routes.py: Login view function

from flask import render_template
from app import app
from app.forms import LoginForm

# ...

@app.route('/login')
def login():
    form = LoginForm()
    return render_template('login.html', title='Sign In', form=form)

What I did here is import the LoginForm class from forms.py, instantiated an object from it, and sent it down to the template. The form=form syntax may look odd, but is simply passing the form object created in the line above (and shown on the right side) to the template with the name form (shown on the left). This is all that is required to get form fields rendered.

To make it easy to access the login form, the base template can include a link to it in the navigation bar:

app/templates/base.html: Login link in navigation bar

<div>
    Microblog:
    <a href="/index">Home</a>
    <a href="/login">Login</a>
</div>

At this point you can run the application and see the form in your web browser. With the application running, type http://localhost:5000/ in the browser's address bar, and then click on the "Login" link in the top navigation bar to see the new login form. Pretty cool, right?

Login Form

Receiving Form Data

If you try to press the submit button the browser is going to display a "Method Not Allowed" error. This is because the login view function from the previous section does one half of the job so far. It can display the form on a web page, but it has no logic to process data submitted by the user yet. This is another area where Flask-WTF makes the job really easy. Here is an updated version of the view function that accepts and validates the data submitted by the user:

app/routes.py: Receiving login credentials

from flask import render_template, flash, redirect

@app.route('/login', methods=['GET', 'POST'])
def login():
    form = LoginForm()
    if form.validate_on_submit():
        flash('Login requested for user {}, remember_me={}'.format(
            form.username.data, form.remember_me.data))
        return redirect('/index')
    return render_template('login.html', title='Sign In', form=form)

The first new thing in this version is the methods argument in the route decorator. This tells Flask that this view function accepts GET and POST requests, overriding the default, which is to accept only GET requests. The HTTP protocol states that GET requests are those that return information to the client (the web browser in this case). All the requests in the application so far are of this type. POST requests are typically used when the browser submits form data to the server (in reality GET requests can also be used for this purpose, but it is not a recommended practice). The "Method Not Allowed" error that the browser showed you before, appears because the browser tried to send a POST request and the application was not configured to accept it. By providing the methods argument, you are telling Flask which request methods should be accepted.

The form.validate_on_submit() method does all the form processing work. When the browser sends the GET request to receive the web page with the form, this method is going to return False, so in that case the function skips the if statement and goes directly to render the template in the last line of the function.

When the browser sends the POST request as a result of the user pressing the submit button, form.validate_on_submit() is going to gather all the data, run all the validators attached to fields, and if everything is all right it will return True, indicating that the data is valid and can be processed by the application. But if at least one field fails validation, then the function will return False, and that will cause the form to be rendered back to the user, like in the GET request case. Later I'm going to add an error message when validation fails.

When form.validate_on_submit() returns True, the login view function calls two new functions, imported from Flask. The flash() function is a useful way to show a message to the user. A lot of applications use this technique to let the user know if some action has been successful or not. In this case, I'm going to use this mechanism as a temporary solution, because I don't have all the infrastructure necessary to log users in for real yet. The best I can do for now is show a message that confirms that the application received the credentials.

The second new function used in the login view function is redirect(). This function instructs the client web browser to automatically navigate to a different page, given as an argument. This view function uses it to redirect the user to the index page of the application.

When you call the flash() function, Flask stores the message, but flashed messages will not magically appear in web pages. The templates of the application need to render these flashed messages in a way that works for the site layout. I'm going to add these messages to the base template, so that all the templates inherit this functionality. This is the updated base template:

app/templates/base.html: Flashed messages in base template

<html>
    <head>
        {% if title %}
        <title>{{ title }} - microblog</title>
        {% else %}
        <title>microblog</title>
        {% endif %}
    </head>
    <body>
        <div>
            Microblog:
            <a href="/index">Home</a>
            <a href="/login">Login</a>
        </div>
        <hr>
        {% with messages = get_flashed_messages() %}
        {% if messages %}
        <ul>
            {% for message in messages %}
            <li>{{ message }}</li>
            {% endfor %}
        </ul>
        {% endif %}
        {% endwith %}
        {% block content %}{% endblock %}
    </body>
</html>

Here I'm using a with construct to assign the result of calling get_flashed_messages() to a messages variable, all in the context of the template. The get_flashed_messages() function comes from Flask, and returns a list of all the messages that have been registered with flash() previously. The conditional that follows checks if messages has some content, and in that case, a <ul> element is rendered with each message as a <li> list item. This style of rendering does not look great, but the topic of styling the web application will come later.

An interesting property of these flashed messages is that once they are requested once through the get_flashed_messages function they are removed from the message list, so they appear only once after the flash() function is called.

This is a great time to try the application one more time and test how the form works. Make sure you try submitting the form with the username or password fields empty, to see how the DataRequired validator halts the submission process.

Improving Field Validation

The validators that are attached to form fields prevent invalid data from being accepted into the application. The way the application deals with invalid form input is by re-displaying the form, to let the user make the necessary corrections.

If you tried to submit invalid data, I'm sure you noticed that while the validation mechanisms work well, there is no indication given to the user that something is wrong with the form, the user simply gets the form back. The next task is to improve the user experience by adding a meaningful error message next to each field that failed validation.

In fact, the form validators generate these descriptive error messages already, so all that is missing is some additional logic in the template to render them.

Here is the login template with added field validation messages in the username and password fields:

app/templates/login.html: Validation errors in login form template

{% extends "base.html" %}

{% block content %}
    <h1>Sign In</h1>
    <form action="" method="post" novalidate>
        {{ form.hidden_tag() }}
        <p>
            {{ form.username.label }}<br>
            {{ form.username(size=32) }}<br>
            {% for error in form.username.errors %}
            <span style="color: red;">[{{ error }}]</span>
            {% endfor %}
        </p>
        <p>
            {{ form.password.label }}<br>
            {{ form.password(size=32) }}<br>
            {% for error in form.password.errors %}
            <span style="color: red;">[{{ error }}]</span>
            {% endfor %}
        </p>
        <p>{{ form.remember_me() }} {{ form.remember_me.label }}</p>
        <p>{{ form.submit() }}</p>
    </form>
{% endblock %}

The only change I've made is to add for loops right after the username and password fields that render the error messages added by the validators in red color. As a general rule, any fields that have validators attached will have error messages added under form.<field_name>.errors. This is going to be a list, because fields can have multiple validators attached and more than one may be providing error messages to display to the user.

If you try to submit the form with an empty username or password, you will now get a nice error message in red.

Form validation

Generating Links

The login form is fairly complete now, but before closing this chapter I wanted to discuss the proper way to include links in templates and redirects. So far you have seen a few instances in which links are defined. For example, this is the current navigation bar in the base template:

    <div>
        Microblog:
        <a href="/index">Home</a>
        <a href="/login">Login</a>
    </div>

The login view function also defines a link that is passed to the redirect() function:

@app.route('/login', methods=['GET', 'POST'])
def login():
    form = LoginForm()
    if form.validate_on_submit():
        # ...
        return redirect('/index')
    # ...

One problem with writing links directly in templates and source files is that if one day you decide to reorganize your links, then you are going to have to search and replace these links in your entire application.

To have better control over these links, Flask provides a function called url_for(), which generates URLs using its internal mapping of URLs to view functions. For example, url_for('login') returns /login, and url_for('index') return '/index. The argument to url_for() is the endpoint name, which is the name of the view function.

You may ask why is it better to use the function names instead of URLs. The fact is that URLs are much more likely to change than view function names, which are completely internal. A secondary reason is that as you will learn later, some URLs have dynamic components in them, so generating those URLs by hand would require concatenating multiple elements, which is tedious and error prone. The url_for() is also able to generate these complex URLs.

So from now on, I'm going to use url_for() every time I need to generate an application URL. The navigation bar in the base template then becomes:

app/templates/base.html: Use url\_for() function for links

    <div>
        Microblog:
        <a href="{{ url_for('index') }}">Home</a>
        <a href="{{ url_for('login') }}">Login</a>
    </div>

And here is the updated login() view function:

app/routes.py: Use url\_for() function for links

from flask import render_template, flash, redirect, url_for

# ...

@app.route('/login', methods=['GET', 'POST'])
def login():
    form = LoginForm()
    if form.validate_on_submit():
        # ...
        return redirect(url_for('index'))
    # ...

350 comments

  • #326 Miguel Grinberg said 2019-11-25T22:49:47Z

    @Chi-Hui: Really the question that I have is why your forms stay up for so long that the tokens expire. That is not the idea. in any case, all you need to do to renew the token is refresh the page. Add an auto-refresh if you don't want to do it manually.

  • #327 robinson said 2019-11-30T08:42:13Z

    awesome tutorial,followed all the steps, failed to flask run. an error saids could not import microblog. i have totally no idea about what is wrong.

  • #328 Miguel Grinberg said 2019-12-01T00:10:25Z

    @robinson: go back to chapter 1 and review the comments on that post to see some possible reasons for this problem. You can also download the code from GitHub and compare it against yours to find the mistake.

  • #329 Gary said 2019-12-10T03:42:29Z

    I keep getting "GET /login/ HTTP/1.1" 404 when I click on the Login link. I followed the tutorial exactly, and can't figure out why this is not working.

  • #330 AM said 2019-12-10T20:36:31Z

    Hi Miguel Great tutorial. Got an issue: Not sure why this is happening ? Copied your code directly and there are no duplicate instances of index() function. Any ideas ? C:\projects\microblog\venv\Scripts\python.exe C:/projects/microblog/app/routes.py Traceback (most recent call last): File "C:/projects/microblog/app/routes.py", line 11, in <module> @login_required File "C:\projects\microblog\venv\lib\site-packages\flask\app.py", line 1314, in decorator self.add_url_rule(rule, endpoint, f, **options) File "C:\projects\microblog\venv\lib\site-packages\flask\app.py", line 98, in wrapper_func return f(self, *args, **kwargs) File "C:\projects\microblog\venv\lib\site-packages\flask\app.py", line 1283, in add_url_rule "existing endpoint function: %s" % endpoint AssertionError: View function mapping is overwriting an existing endpoint function: index

  • #331 Miguel Grinberg said 2019-12-11T10:46:56Z

    @Gary: your link has a trailing slash. It should be "/login", but you have "/login/" in your template.

  • #332 Miguel Grinberg said 2019-12-11T10:52:29Z

    @AM: you have two routes where the function name is index().

  • #333 Daniel said 2019-12-18T02:45:31Z

    Thank you so much for your mega tutorial I enjoy but I have a question regarding the form and different select how can implemented a SelectField example to store a program or gender of user thank you for share your knowledge.😀

  • #334 Miguel Grinberg said 2019-12-18T10:25:13Z

    @Daniel: select fields work in a fairly similar way to text fields. The only difference is that you have to set the "choices" attribute to the contents you want to appear in the dropdown.

  • #335 Ace said 2019-12-24T04:01:00Z

    I am getting page not found after adding form views.

  • #336 Miguel Grinberg said 2019-12-24T11:00:29Z

    @Ace: I'm providing the full source code that you can use to compare against your version and find the mistake. Use the links provided at the top of this article.

  • #337 apk14 said 2019-12-29T06:46:03Z

    Hey! Great tutorial. I am facing an issue. After using the url_for(), an error is raised saying 'Could not build url for endpoint 'index'. Did you mean 'login' instead?'. Before using url_for(), only the method written first in the routes.py file was getting. I mean if I defiine login() first only that will be called on both index and login link and similar result if I defined index() first. Also, the post method was not getting accepted even after providing the methods argument in the routes.py file.

  • #338 Miguel Grinberg said 2019-12-29T16:53:48Z

    @apk14: the error means that you don't have any view function with the name "index()". Did you use a different name for the main view function? That's the name you need to use in the url_for() function.

  • #339 apk14 said 2019-12-29T17:19:29Z

    Thanks! I was defining the index() login() both under the @app.route('/login', methods=['GET', 'POST']), as a result the application was running only the one defined first. Also the post method was not getting accepted for the same reason. It's working now!

  • #340 Dava Mx said 2020-01-03T16:44:28Z

    Everything was workign fine until I added your url_for() function. I am assuming this is a module version mismatch? File t\app\routes.py", line 31, in login return redirect(url_for('index')) NameError: name 'url_for' is not defined

  • #341 Miguel Grinberg said 2020-01-03T23:27:36Z

    @Dava: did you import url_for at the top of app/routes.py?

  • #342 Piyush said 2020-01-06T18:37:25Z

    Hi @Miguel Grinber, I created my config.py file under microblog dir. But when I'm importing config file from app/__init__.py it's giving error: from config import Config ModuleNotFoundError: No module named 'config'

  • #343 Miguel Grinberg said 2020-01-06T22:37:58Z

    @Piyush: Your current directory must be microblog when you start the application. If you start from another directory, then config.py will not be found and you will get this error.

  • #344 Jian Wang said 2020-01-13T11:09:53Z

    Hi, Miguel, I have learned a lot from your flask book and now I'm trying to develop a software, however faced one problem but can't find a solution from any where, The software I'm working on is generetating checklists for user to select and submit. The checklists are pre-defined in database and the number of checklists are variable depends on the objects, so which will be populated from database. for each checklist, there shall be a selectable field and a textarea filed for user to select and input data then submit in together. How i'm suppose to develop such feature? Thanks and best regards,

  • #345 Miguel Grinberg said 2020-01-13T19:37:53Z

    @Jian: what part of this project do you have problems with? With this tutorial you should know how to represent booleans and text fields in the database, and you also know how to implement one-to-many relationships. That I think should be enough to implement your project, unless I'm missing something.

  • #346 Jian Wang said 2020-01-14T07:48:18Z

    Dear Miguel, What I want is to implement a Form such as: class InputRecordForm(FlaskForm): id = IntegerField('Record ID') result = SelectField('Result', coerce=str) particular = TextAreaField('Particular') The form field shall repeat in each row of a table, where for each row of the table some column made up of records from a database table. and some column is the item of the a.m. form and pre-populated with data from the database table if the relevant record not None, the row number of the table is not fixed since they are records from database. When fill-in or update the data of the form field for each row and finally submit, the software shall record all inputed data. My problem is I did not know how to make this form field repeatable in each row of a table and then get the input data via a for loop in the view when form submitted. (in a word: What I need it not only update 1 database table record a time but batch records with 1 submit.) BR,

  • #347 Miguel Grinberg said 2020-01-14T11:46:53Z

    @Jian: okay, I think I understand now. Take a look at the FieldList field type in WTForms: https://wtforms.readthedocs.io/en/stable/fields.html#wtforms.fields.FieldList

  • #348 William said 2020-01-14T14:07:07Z

    Thank you so much. I am following the tutorial from Liberia, West Africa. Here in Liberia, not many people have the opportunity to study application development.

  • #349 Jian Wang said 2020-01-15T07:33:15Z

    @Miguel, Sorry to bother you again. I indead read about the FieldList section. here is what I'm doing: #forms.py class InputRecordForm(FlaskForm): id = IntegerField('Record ID') result = SelectField('Result', coerce=str) particular = TextAreaField('Particular') class InputGirdTableForm(FlaskForm): girdtbrecords = FieldList(FormField(InputRecordForm)) # templates/iclass/survey.html {% block page_content %} <form method="post"> <table class="table table-sm text-center"> <tr> <thead class="thead-light"> <th>ID</th> <th>Code</th> <th>Question</th> <th>Result</th> <th>Particular</th> </thead> </tr> {% for checklist in checklists %} <tr> <tbody> <td>{{ checklist.id }}</td> <td>{{ checklist.checklist_poll.code }}</td> <td>{{ checklist.checklist_poll.question }}</td> <td>{{ form.girdtbrecords.result }}</td> <td>{{ form.girdtbrecords.particular }}</td> </tbody> </tr> {% endfor %} </table> </form> {% endblock %} # views.py @iclass.route('/surveys/<int:id>', methods=['GET', 'POST']) @login_required def survey(id): form = InputGirdTableForm() survey_job = SurveyJob.query.filter_by(id=id).first() ship = survey_job.survey_request.ship checklists = Checklist.query.filter_by(ship=ship, active=True).all() if form.validate_on_submit(): for checklist in checklists: record = form.girdtbrecords.data.pop([0]) checklist.result = record['result'] checklist.particular = record['particular'] db.session.add(checklist) db.session.commit() #***************************** #***************************** return render_template('iclass/survey.html', form=form, survey_job=survey_job, checklists=checklists) above may works for submiting data to database, however I did not know how to populate data from database when need to updating them.

  • #350 Miguel Grinberg said 2020-01-15T08:20:52Z

    @Jian; the data is submitted exactly in the way you get it when a form is submitted. I honestly don't remember the exact format, but just inspect form.girdtbrecords.entries a submitted form to figure out how the data needs to be formatted when going in the other direction.

Leave a Comment