Sorting of Answers

Jotfrom has been recommended to me to use to create an employee survey. The organization has about 200 employees. We have designed 14 multiple choice questions, and three free form answers. I have seen a demo from a collegue of how I can create the survey which is easy and great.

But, would like to have staff designate where they work ( 4 categories) their length of service ( three categories.

So, I would want to sort all answers so I can group people in Location 1 with say less than 1 year of service etc.

Can this be done with the Jotform platform?

Thank you .

Hi Cynthia,

Thanks for reaching out to Jotform Support.  Sure, you can sort the columns in Jotform Tables by ascending or descending order. Let me show you how:

1. On your My Forms page, click on your form and then click on Submissions.
2. In Jotform Tables, click on the Downward Arrow icon on your column and click on Ascending or Descending.

Additionally, you can use different filters to find specific submissions based on the date, answer selection, and unique information.

1. First, let's look at filtering submissions using the Date filter:

• On your Jotform Tables page, click on All Time in the toolbar at the top of the page. 
• In the window that comes up, choose a predefined date filter, like Today, Last 3 Days, or Previous week.

• Now, click anywhere outside of the window to close it. That will save the filter and also show the results. In the screenshot below, check out the results when I used the Today filter:

• The filter will populate a filter bar on the left side of the page.

2.  Let's see the filtering now using the Custom Dates filter:

• Click on Custom Dates and then choose a date range. 
• It's easy to do. First click on the Start Date and then click on the End Date.

• For the date range I used above, check out the filter it created below:

3. You can also filter your submissions based on Answer Selection. Let me show you how to do that:

• Click on the Filter button and set the filter. Enter the keywords, sentences, or phrases you want to search for, like filtering submissions with the answer "Yes" to a question or "Is this your first time reaching out to us?" This is a single-choice field, but you can use the same method for a dropdown field. 

• Click on Apply Filter to show submissions that have "Yes" as the answer.

Right now, we don't have a feature to filter answers to multiple-choice questions. So you can only filter one answer selection at a time, and that selection will be shown whether there are other selections in that field or not. Check out the results below when I applied a filter for Facebook:

• If each of your forms has a Unique Reference Number, you can filter using either Equals or Includes:

• You can also filter using elements that are text boxes or text areas, like the Name, Email, Short Text, and Long Text elements. Take a look at the screenshot below. As an example, I filtered in the Long Text field for answers that included 'amet'.

• Click on the Apply Filter button to apply the filter and see your submissions. 

You might also want to check out our guide explaining How to Use Different Filters to Easily Manage Your Data in Jotform Tables. 

Give it a try and let us know if you need any help.