Welcome back to another Back to Basics, form fans! So you’ve built that spiffy form of yours (congrats) and now you’re watching all those entries come rolling in (awesome). And rolling in. And rolling in. Sometimes it can feel a little overwhelming to go through all of those submissions and having to wade through the Entry Manager to get the perfect view of the results you’re looking for. If you have 60 results (or even 6 or 600) and you want to get some of them to your friends and colleagues for review, it can be tough to sort through them all to make sure the right data gets to the right place. Fortunately, the Entry Manager’s versatile functionality allows you to filter and export your results so you can make the most of all those form submissions.
The Search Bar
First, let’s look at the Search bar. Much like the legendary Sasquatch, despite its power this feature spends most of its time in hiding. If you click into the bar itself you’re able to search all of your entries for whatever information you’re looking for. But trust us, the search bar is so much more than that.
If you click the magnifying glass icon to the left, the filter options will appear above the entries. You’re able to add filter criteria to limit the Entry Manager display. Most of the time this process is pretty straightforward. Say you wanted to find a list of all Canadian customers with government mailing addresses…You can apply a filter to “Display entries that meet all of the following conditions” add “Country contains Canada” and “Email contains @government.ca” filters to the manager. You’re then able to base filters on any of the fields in your form and use the following conditions:
• Contains • Does not contain • Begins with • Ends with • Is equal to • Is not equal to
There are a few situations where the filter criteria isn’t as simple as the above examples. For example, if you’re filtering by the number of stars provided in a Rating field, you’ll need to use a numeral to represent the number of stars. If you’re sorting by a checkbox option, you’ll need to use the label of the checkbox to successfully filter things. What do we mean exactly? Say the checkbox is labeled, “Yes, I would like to attend your event” and you’d like to find everyone who checked it, you’ll need to say, ‘Yes, I would like to attend your event’ is equal to ‘Yes, I would like to attend your event.’”. If the checkbox is selected then the answer is the same as the label.
Now that you’ve limited your search to only your Canadian customers, you want to export those results so you can email them to that naysayer who said you’d never make it big in Toronto (pfft). You can do this by using the Bulk Actions button, conveniently located to the left of the search bar! On the right side of the entry display the Export and Delete buttons will appear.
The Export button allows you to export all entries that are currently displaying in the Entry Manager. If you have no filters applied, this will export all of your entries, if you do have filters applied, only the specified entries will be exported. You’ll have three different format options, as well: Excel (.xls), text (.txt), and Commas (.csv).
The Delete Button is in the same Bulk Actions window as the export button, but it’s key not to mix these up. It operates under the same rules as the Export button—it will only delete those entries that are visible. Need to get rid of any unpaid entries? Go ahead and use the filter to sort them out and just hit Delete.
There you have it, dear form fans. We hope that overwhelming feeling has disappeared into thin air and don’t be shy—let us know if you have questions below!