The submissions table

The submissions table is a very useful tool as an overview of submission information, and to manipulate and extract data. You can add and remove columns, delete or edit submissions and download reports.

Go to Event dashboardSubmissions to access the table

Skip to Accordion tables

 

Entries are displayed in rows. Any with a pink background are incomplete, which means that the submitter has not completed a mandatory question, or has exceeded any set word limits.


 

The table has tools to search, order, filter and download reports.


The controls, from left to right, are:


 


1) The field shown below is a general search bar, for entering any keywords. For example - entering 'data' will return every entry where that word / text string occurs.

2) Click on the arrow to the right of 10 per page to select how many rows you would like to appear in the submissions table view.

3) Pages - from left to right - The first page (greyed out), previous page, select page number, next page, last page

4) Download data on view

A) data from the 'parent' rows. 

B) all the data from 'parent' and 'child' rows, but with the 'child rows' appearing as sub rows.

C) data from 'parent' and 'child' rows, appearing in one row in Excel, as opposed to sub rows.

D) same as (3), but presented by column.

E) Choose the format of your report. 

 

5) Clear all filters

6) Truncate / untruncate text (Untruncated would display all text in responses, truncated would display the first 50 characters (see below). Either choice would be reflected in the spreadsheet exports (above).

7) Expand table to browser window.

8) View deleted - see Deleting/Restoring a submission 
9) Delete submissions - see Deleting/Restoring a submission

10) Click on the arrow below to access the options for column display.

Columns


The options will appear grouped into two tables 

Main table - Submission data, and Submission responses.

Accordion Tables - Author information


Under Submission data, you will find a list of all the data relating to the submitter - eg name, email, last updated etc.


You can toggle each group as below:

Display all fields

Hide all fields

Some fields are selected

 

To choose which fields you would like displayed in the table, click on the down arrow.


When you have made your selection, click on the up arrow


 

Submission responses include all responses to the questions in the submission form.


When you have chosen the fields you would like displayed from the Submission data, Submission responses, and  Accordion Tables click the arrow to hide the selection window.

 

See Accordion tables below for more information on finding author data.

On the top left hand side of the table


1) Check boxes to select - eg, to delete. Choose the top one if you would like to select all rows (or all filtered rows if you have filtered any) in the table on that page, or select individually (first column in table)

2) Click the next icon, the down arrow to reveal more options.
3) Filter the list according to the boxes checked - ie - all those checked will remain in view.

4),5) and 6) See Accordion rows, below.

7) Filter fields - filter by any keyword / text string (For columns that contain numerical data, you can filter by minimum, exact, and maximum. You can also view a range by entering a figure in min, and a figure in max.)

Click on any header to order submissions alphabetically or numerically.

The down arrow will display from A-Z, (or 1-10) Click again to order from Z-A (or 10-1) (up arrow).

 

 

Accordion tables

You will see a column of down arrows in the second column of the table, headed Show authors. These expose the child rows. Click on the top one (red) to reveal all author and affiliation child rows, or select individually (green).

The icon noted with the purple arrow allows you to hide the empty rows when filtering in the accordion rows.

Each review will appear in 'child' rows. 


 

When you reveal any accordion rows, an additional icon will appear. This will allow you to truncate or untruncate the list of authors on display.



Each author will appear in 'child' rows. These can be filtered and ordered in the same way as the 'parent' rows.



If you would like to search the accordion rows - eg, if you want to find a list of all presenters:

1) Ensure the relevant accordion rows are on display.


2: Enter the search term in the relevant column. You can then select Hide empty rows if required.