Check your version

This video covers a topic in Drupal 7 which may or may not be the version you're using. We're keeping this tutorial online as a courtesy to users of Drupal 7, but we consider it archived.

Managing Results with Webform

Video loading...

  • 0:01
    Webform Basics Managing Results with Webform
  • 0:05
    with Amber Himes
  • 0:08
    In this lesson, we'll view with the Results tab
  • 0:10
    of our Webform, where we can view user submissions,
  • 0:14
    get a basic analysis of our submitted data,
  • 0:17
    view a table of results, download as delimited text
  • 0:22
    or Excel file our results, or clear all results,
  • 0:25
    as you might need to do as you're testing
  • 0:27
    out your form in the beginning.
  • 0:29
    Let's get started.
  • 0:30
    On our Webform, let's click the Results tab.
  • 0:33
    The first thing that we can see is an overview of user submissions.
  • 0:37
    We see the number of results, how many total, a date stamp of when it
  • 0:42
    was submitted, the username and if it's anonymous or not,
  • 0:47
    the IP address, and we can view, edit, or delete these submissions.
  • 0:53
    If I click View on the first one, now I
  • 0:57
    get a little bit more information about the submission.
  • 1:00
    I get the values that they entered for each field.
  • 1:04
    So in this case, the form is called RSVP.
  • 1:08
    It was submitted by anonymous.
  • 1:10
    Here's the date stamp and the IP address.
  • 1:14
    Now, for the Names field, the value entered was testing.
  • 1:19
    The response was happily planning to attend
  • 1:22
    and the number attending, which is two.
  • 1:24
    Now, over here I get a navigation where
  • 1:27
    I can go to the next submission or previous one in this case,
  • 1:31
    since that was the latest one.
  • 1:33
    So using the previous exhibition links here,
  • 1:37
    I can navigate through all of my submissions
  • 1:41
    and see all of my results.
  • 1:43
    Now, using these bread crumbs here, I'll go back to Webform results.
  • 1:48
    Next we can get at basic analysis of our data.
  • 1:51
    If I click on the analysis tab here, I get an overview.
  • 1:55
    So for the names field, it lets me know how many left it blank.
  • 2:03
    Zero names were left blank, which is good
  • 2:06
    since it was a mandatory field.
  • 2:07
    That's what we would expect.
  • 2:09
    We had seven responses and seven responses entered a value.
  • 2:15
    The average submission length in words was 1.86,
  • 2:20
    so that may or may not be interesting or useful to you.
  • 2:25
    For the response field, six were happily planning to attend,
  • 2:29
    and one response said they were not able to make it.
  • 2:33
    And the number attending-- this is very useful because it gives me
  • 2:37
    a sum of all of the numbers entered into that field.
  • 2:42
    So now the fact that I used a number field for number attending
  • 2:46
    is paying off because now I get some math where it's going to sum
  • 2:51
    the total of all of the numbers entered in to the number attending
  • 2:55
    field, and it gives me a total.
  • 2:57
    So that's very useful.
  • 2:59
    We can click on the More Stats.
  • 3:01
    There's a few more statistics that you may find useful, especially
  • 3:05
    in the case of a survey or something like that.
  • 3:09
  • 3:09
    Something that I need to use, but it's there if you need it.
  • 3:13
    Next let's go to the Table tab, and this Table tab
  • 3:17
    is distinguished from this Submissions tab in that this is
  • 3:22
    showing an overview of the fields themselves.
  • 3:25
    So while the submissions tab shows the time of the submission,
  • 3:29
    and the user, and the IP address, the table actually
  • 3:33
    shows that same information, but it also
  • 3:36
    gives the values of my first three fields,
  • 3:39
    so this is a little bit more useful.
  • 3:41
    If you had a form with a lot of fields,
  • 3:43
    this table might get a little unruly, I imagine.
  • 3:47
    Next we can go to the Download tab, and we can choose to download
  • 3:52
    our results as delimited text, and we can choose delimited text
  • 3:56
    format-- comma, tab, semicolon, et cetera--
  • 4:00
    or we can download it as an Excel file.
  • 4:03
    So I'll go ahead and choose delimited text,
  • 4:06
    and I'll keep the tab format.
  • 4:09
    So this additional formatting is available to you
  • 4:11
    if it's appropriate.
  • 4:12
    I'm going to keep the defaults as select keys are
  • 4:16
    full human-readable options instead of the raw options.
  • 4:21
    So for my radio buttons I've got my key values as yes and no
  • 4:26
    and my labels as happily planning to attend or regretfully not
  • 4:31
    able to make it, so I could choose either one of those
  • 4:36
    if I want the long label or if I want the short key.
  • 4:41
    So I'll choose-- actually, I'll choose
  • 4:44
    the full human-readable values, and I'll keep this default
  • 4:49
    as separate options for each one instead of a compact list.
  • 4:55
    That will be fine.
  • 4:56
    And now expanding the included export components.
  • 5:00
    So since all of my submissions are anonymous users,
  • 5:05
    it's not really useful to me to include the submission information.
  • 5:09
    It's kind of irrelevant because they're entering in their name
  • 5:13
    already into the field, so I don't need that data.
  • 5:16
    So I'm going to exclude the submission information,
  • 5:19
    and I'm just going to include the name,
  • 5:22
    response, and the number attending.
  • 5:24
    So this is going to simplify my download a little bit.
  • 5:28
    And the download range options, I'm going to download all.
  • 5:31
    But let's say you already had downloaded this
  • 5:33
    and you wanted to do it again.
  • 5:35
    You could say only new submissions since your last download.
  • 5:39
    Since I haven't downloaded it yet, it's not giving me that option.
  • 5:43
    Or you could say only the latest 10, or 5, or 100, or whatever it is.
  • 5:49
    If you have a large number of submissions,
  • 5:51
    this can be really useful so you're not
  • 5:53
    continuously downloading this massive file.
  • 5:56
    And there's this last range option of all submissions starting from,
  • 6:00
    and you can use the submission ID.
  • 6:02
    So if you know your last submission ID was 597,
  • 6:06
    then you could say I want to start at 598,
  • 6:10
    and you could set an upper limit as well if you wanted to.
  • 6:14
    So those are your download range options.
  • 6:17
    I'm going to say all submissions.
  • 6:19
    I'm just going to include the name, response, and number attending.
  • 6:23
    I'm going to keep this list as separate.
  • 6:26
    I'm going to use the full human-readable options,
  • 6:31
    the values as opposed to the key.
  • 6:33
    And I'm going to choose an export format of delimited text
  • 6:37
    with tab delimited.
  • 6:39
    I'll go ahead and download that and save,
  • 6:44
    and let's take a look at that file.
  • 6:46
    So I've just opened up my downloaded file.
  • 6:49
    I've got a tab delimited text file of my names,
  • 6:53
    response, and number attending fields.
  • 6:56
    And I could import this into another program if I wanted
  • 7:00
    and analyze that data further.
  • 7:03
    All right, returning to our Results tab,
  • 7:06
    the final option is the Clear option.
  • 7:09
    Now if it was the case that you had a bunch of test data,
  • 7:12
    it's really handy-- instead of having
  • 7:14
    to delete those submissions one by one, which we could do here.
  • 7:18
    Delete, delete, delete.
  • 7:19
    That might get a little bit tedious.
  • 7:21
    As I know that these are all test submissions and none of them need
  • 7:27
    to be saved, I'm going to go ahead and click on Clear,
  • 7:30
    and noting that this action cannot be undone,
  • 7:34
    I'm going to clear all results.
  • 7:37
    So now in my submissions, everything is deleted
  • 7:41
    and I can proceed with my testing.
  • 7:43
    So something to be careful of if you're using live data,
  • 7:46
    you probably don't want to clear all of your data until you run
  • 7:49
    a backup, or maybe never at all because that
  • 7:53
    Delete All function cannot be undone.
  • 7:55
    In this lesson we explored the Results tab of our Webform
  • 7:59
    where we could view user submissions and navigate through them,
  • 8:02
    get a basic analysis of our data, view the results as a table,
  • 8:07
    or download the results as a delimited text or Excel file.
  • 8:11
    Finally, we learned how to clear all results.
Loading ...

Managing Results with Webform


In this lesson, we'll explore the Results tab of our webform where we can view user submissions, get a basic analysis of our data, view the results as a table, download the results as a delimited text or Excel file, and clear all results.

Additional resources:
There are no resources for this video. If you believe there should be, please contact us.