Create a Query - Customize Your Interactive Spreadsheet

Create a Query / Customize Your Interactive Spreadsheet

Customizing the view on the table component is a very powerful feature that allows you to change which columns are being displayed, and gives you access to more fields, that you can easily filter/display.

For submissions, customizing the view allows you to add any field in the submission as a column. Assume you're viewing submissions from a call you just created, then customizing the view allows you to add any field from any section as a column, and each row would then display the value of that field in the particular submission.

Please note, it is recommended to have the VIEW button as the last displayed column.

  1. Open the desired call

  2. Select SUBMISSIONS from the menu bar

mceclip0.png

  1. Select CUSTOMIZE VIEW

  2. Scroll down a tad then select ADD RESULT FIELDthis will create a new field to select from

  3. Select Choose Field to populate into the table

mceclip1.png

  1. To move the field select the ellipses then drag and drop on the desired order

mceclip2.png

  1. To remove a field simply select the x in the row

  2. By selecting ADD FILTER CRITERIUM you will be able to select a field then populate the filter options, please note you can filter in the table as well

  3. Once you have completed the necessary changes select APPLY to save

mceclip3.png