# Form Table View

With table view, the [<mark style="color:purple;">**form**</mark> ](https://docs.senpiper.com/form-builder)submissions and their details can be viewed in a tabular format. The status, priority, submitter details, submission date, the assignee of the task, and the fields of the form are displayed as columns of the table.&#x20;

### Accessing and customizing the table view

1. &#x20; To access the table view for form details, first click on the required form from the [<mark style="color:purple;">**Actions**</mark> ](https://docs.senpiper.com/getting-started/web-workspace#2.-actions-pane)pane and then in the [<mark style="color:purple;">**tab bar**</mark>](https://docs.senpiper.com/getting-started/web-workspace#1.-tab-bar) of the **Group Details** screen, click <img src="https://4216568905-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Mc6E3BSGr4i8kVdH38k%2Fuploads%2FTBuysrrc22owi5RYrBaV%2Fimage.png?alt=media&#x26;token=f2cb40e8-9c94-4e7d-b0a0-b33a3a89df12" alt="" data-size="line">.

<figure><img src="https://4216568905-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Mc6E3BSGr4i8kVdH38k%2Fuploads%2FwuueDWVGIcaEN87mGhfM%2Fform%20table.png?alt=media&#x26;token=c730818b-14e7-4e35-b6c8-ffb6d37d48ca" alt=""><figcaption><p><em>Form Answer Table</em></p></figcaption></figure>

The form submissions are displayed in a tabular format.&#x20;

The following columns are the metadata that is autogenerated by the system:

* Action
* Submitted By
* Submitted On
* Current Assignee

The rest of the columns are the various fields present in the form.

2\.    To view an individual form submission, under the **Action** column, click **Details** in the respective row of the table.

<figure><img src="https://4216568905-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Mc6E3BSGr4i8kVdH38k%2Fuploads%2FQIZ3gM1LrkntZTNVRoYQ%2Fform%20table%20%E2%80%93%201.png?alt=media&#x26;token=2f28b0d5-f5f9-4996-b3de-75cc61317b32" alt=""><figcaption><p><em>Action for a form submisison</em></p></figcaption></figure>

The selected form submission details are displayed.

<figure><img src="https://4216568905-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Mc6E3BSGr4i8kVdH38k%2Fuploads%2F3EVm07a8r6uaTztdMjM8%2Fimage.png?alt=media&#x26;token=1858641e-7b1b-491c-aba2-2429a45f098c" alt=""><figcaption><p><em>Form Answer Submission</em></p></figcaption></figure>

3\.    To customize the table view, you have two options:

a. **Column filter:** You can select which columns (fields) you want to display in the table.

* At the top right of the table view, click <img src="https://4216568905-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Mc6E3BSGr4i8kVdH38k%2Fuploads%2F7CaTeosfXgeot9kPtSkc%2Fimage.png?alt=media&#x26;token=1691cb4d-9c00-49d9-a1ba-1cf7fe600dc4" alt="" data-size="line">.

<figure><img src="https://4216568905-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Mc6E3BSGr4i8kVdH38k%2Fuploads%2FKReAaBApOLhUulSkQDwe%2Fform%20table%20%E2%80%93%202.png?alt=media&#x26;token=ed4d4965-947d-4f65-b61e-f9ca837e3c75" alt=""><figcaption></figcaption></figure>

The column filter options are displayed.

<figure><img src="https://4216568905-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Mc6E3BSGr4i8kVdH38k%2Fuploads%2FMPL4MiJsnW3gF9FrAAr6%2Fcolumn%20filfer.png?alt=media&#x26;token=6fe798cd-523f-4e9e-ac1b-0eefce79802d" alt=""><figcaption><p><em>Column Filter</em></p></figcaption></figure>

* Select the fields that you want in the table view of the form.&#x20;

  The rest of the fields will be discarded from the table view accordingly.

b. **Conditional filter:** You can set a condition based on which the table columns will be displayed.

* At the top right of the table view, click <img src="https://4216568905-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Mc6E3BSGr4i8kVdH38k%2Fuploads%2FV0VhmR4PDIXIKOanWDIb%2Fimage.png?alt=media&#x26;token=daf76d33-ba3c-46ff-aed5-1ff7271267ac" alt="" data-size="line">.

<figure><img src="https://4216568905-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Mc6E3BSGr4i8kVdH38k%2Fuploads%2FSYHy85PIliPCa6GB8HW8%2Ffiltering.png?alt=media&#x26;token=68867c28-5b7c-48eb-9e13-f54ceb94a1a4" alt=""><figcaption><p><em>Filter form submissions</em></p></figcaption></figure>

The **Choose Filter** screen is displayed.

<figure><img src="https://4216568905-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Mc6E3BSGr4i8kVdH38k%2Fuploads%2FLtZEVzTl3sT8mmXBSdb2%2Ffilter.png?alt=media&#x26;token=a8126fe5-64f5-47bb-98be-455e89e8d486" alt=""><figcaption><p><em>Apply filter</em></p></figcaption></figure>

* Select the fields and add the required conditions using operators and field values.

  In the above image, a condition is added stating that only the values for the field Web Task Name that starts with 'a' should be displayed in the table view. Thus, only the Web Task Names starting with 'a' and their corresponding fields are displayed in the table.

### Other options

* At the top right of the table view, there are more options for the form data.

<figure><img src="https://4216568905-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Mc6E3BSGr4i8kVdH38k%2Fuploads%2FsjCLll6iRqaJGuSczQBh%2Foptions.png?alt=media&#x26;token=2b01667d-a430-40c9-a903-6b50b817aacb" alt=""><figcaption><p><em>Form answer table properties</em></p></figcaption></figure>

| Icon                                                                                                                                                                                                                    | Description                                                                                                                                                                                                                                                                                    |
| ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| ![](https://4216568905-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Mc6E3BSGr4i8kVdH38k%2Fuploads%2FRtMRlVG2WwHFIYJn9zAj%2Fimage.png?alt=media\&token=a930141d-0cf2-4dd6-ae2e-efccae603373)     | <p>Upload data entries to the form in bulk</p><p><em>This is done in 3 steps:</em></p><ol><li><em>Download the excel template</em></li><li><em>Fill the excel template with the required data entries that you want to upload</em></li><li><em>Upload the filled excel template</em></li></ol> |
| ![](https://4216568905-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Mc6E3BSGr4i8kVdH38k%2Fuploads%2F3Ss6Hz4aWJ72fw8Z4YlE%2Fdownload.png?alt=media\&token=168c12a1-b8b4-4fe9-ac0c-b06fc036d680)  | <p>Download data in excel format</p><p><em>You can customize the excel file and download data as per the name of the user, specific fields, or a specified date range.</em></p>                                                                                                                |
| ![](https://4216568905-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Mc6E3BSGr4i8kVdH38k%2Fuploads%2FBWOp2YAqjsbunpklASuw%2Frefresh.png?alt=media\&token=487522f0-5feb-4e41-8c90-d46f11e232c8)   | Refresh the data in the table                                                                                                                                                                                                                                                                  |
| ![](https://4216568905-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Mc6E3BSGr4i8kVdH38k%2Fuploads%2FQ4Mny8Lbab96a35ElAuf%2Fadd%20new.png?alt=media\&token=74e8d8e8-69c2-40ee-8a5f-df9b455bbf05) | Add a data entry to the form as a new form submission                                                                                                                                                                                                                                          |
