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
    not?
  • 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

Loading...

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.