Hi Form-Friends! We all know how important it can to be to break down your data and get more specific insights from your forms. Our filtering tool in the Report Builder enables you to visualize how a specific group of respondents answered fields in your form. Additionally, it makes it easy for you to grab data lists and export to Google Sheets, Excel or CSV files.
Filtering data can come in handy for many different Wufoo use-cases, but a couple of more common ones that that come to mind for me are:
To get started with filters, you’ll want to head over to the Report Manager by clicking the Reports tab at the top of your account. From there you can click to create New Report! in the top right.
Once you’re inside the builder. you can name and give your report a description in the Report Settings tab at the top. if you’d like to be able to grab easy exports from your report at any time, you’ll want to tick that box next to Allow User to Export Data as well.
Here’s where we get to the fun part. Once you’ve named your report click on the Select Data tab in yellow at the top. Here’s what the default looks like:
From the second drop-down, select the form that you want to filter. From the first drop-down, click on Selected Entries. This will expand out and allow you to create filters galore.
Say you want to gain insight about how newer customers feel about your product. You could generate a filer that reads something like “Use Selected Entries from Customer Satisfaction Survey that match all of the following conditions: How long have you used our Product/Service is equal to Less than a month”.
When setting up your filter you’re able to use any of the fields in your form design with the following conditions:
• Contains • Does not contain • Begins with • Ends with • Is equal to • Is not equal to
Don’t forget that when entering your answer option into the filter you’ll always want to type out exactly what you have listed on the form design or else the filter won’t work or come out the way you want it to.
There are also a couple of situations that may not be as intuitive when setting up your filter:
1) If you’d like to use multiple conditions in your filter, you can definitely do so! To add another condition just click that green + button next to the first condition on the right.
Keep in mind, though, that our filters can’t get too complex. You can set them up so that the filter applies to every condition by selecting “ALL” in the third drop down (as if AND appeared between each of the conditions) and you can also choose to set them up so that the filter applies to Any condition (as if OR appeared between any of the conditions). Having said that, we don’t have a way to combine these two attributes. In other words you couldn’t create a filter that reads something like this. “If field 1 equals 1 AND field 2 equals 2 OR if field 3 equals 3.”
2) If you’re filtering by number of stars provided in a rating field, you’ll need to use a numeral to represent the stars
3) If you’re filtering by a checkbox option, you’ll need to use the label of the checkbox to filter. For example: the filter should appear something like “Bachelor’s degree is equal to Bachelor’s degree. In other words, it can be a bit redundant because the label will appear the same as the answer option.
Note: your filters will not apply to number widgets.
Once you’ve created a filter, you can go ahead and move onto the Add Widgets tab to select the widgets of your choice. You can then define the field for each of the widgets that you add in the final Widget Settings tab at the top. After saving your form, you’ll have a beautiful filtered set of data to take a look at. You can check out my example here.
Keep in mind—If you don’t need the visualizations that the report builder’s charts and graphs offer, then it may be worth simply filtering your results in the Entry Manager and exporting the data to list form from there. Our friend Zachary walks us through that here.
That’s all there is to it, friends! Of course, if you do have questions let us know below.
Back again for another installment in our CSS Tips ‘n Tricks how-to series! In the last CSS tutorial we changed the images on our form with the :hover selector, and today we’re going to focus on a few other really simple tricks to make your form look that much nicer using CSS.
First, we’ll go through the Error messages. If your users are filling out your form and they do something wrong like forget to fill out a required field, then we’ll throw them an error that tells them that they’ve run into errors and shows them where those errors are. While it’s not possible to change what the error messages actually say, you can change how they look. If we go back to our lovely form that we’ve been building so far and forget to fill out the required field, we’ll get an error that looks like this:
There’s absolutely nothing wrong with that. It definitely draws attention to the errors that have been made and where they have been made. What if you want to change it around a bit though? Custom CSS would be the way to go. If you inspect the element of that page and view the error messages, you can find the selectors needed.
We’re going to change the Top message so there’s no border and it’s a tad bit smaller. To do that, we’ll see that the top error message uses the ID: “errorLi”, so we’ll need to use #errorLi in the CSS rule. Since I’m a big fan of rounded corners, we’ll also put a rounded corner on the border around the word “highlighted.” That will be done with form li.error. In addition, we’re going to put a border around the highlighted field and change the colour. This will change the colour of the background around “highlighted” as well to keep things consistent. Sounds like a lot, but there’s not much CSS needed.
Here it is:
Not too much going on here. We’ve wiped our hands of the border and taken out the padding for good measure. If you notice we’ve also added !important to the background colour of the error message. This is because the original also uses !important and would override our CSS if we didn’t add that in there.
Now, I don’t want a logo in my form, but if I choose not to have one the charcoal header is still there in place. I’d like it to all be the same colour of my background, which is white. Sticking with some simple background-color changes, I can do that by targeting the Logo with #logo a.
That will just change the background colour of your logo to white. This is also nifty if you have a smaller logo in your form and you want to erase that charcoal background that takes up the rest of the header.
Finally, I want to center the title of my form. It’s all well and good over in the left like it is right now, but I think it would be a bit cooler if it was centered. This is some of the easiest CSS you can use, but centering things makes everything look fantastic. The title will use the ID: “header”, so we’ll want to use #header.
Now let’s have a look at what those changes have done to our form:
Lovely jubbily. We’ve still hit an error for not filling out that field, but that border at the top of the page has been removed, the colors have changed as well as the nice rounding of the borders in the bottom error. There’s no charcoal at the top of the page and the title of the form is centered to make everything look wonderful. This form is really coming along!
If you’d like to take a moment to get to know Dave, please read this post by our SurveyMonkey family. We appreciate your kind words and continued support during this difficult time.
There are so many ways that you can get your form out there for people to see. We can even create a Facebook post with a link to your form all there for you so you don’t have to do it yourself. Pretty nifty stuff, but what if you want to embed the form onto your Facebook page? You could try grabbing our embed code and chucking that in a post, but you’d soon find out that Facebook isn’t really cool with that and it won’t work. You have to take a different approach, which happens to be pretty easy to do. Let’s go through how to embed your form into your Facebook page.
Install the Static HTML: iframe tabs app: Don’t worry, you won’t get a static shock or frizzy hair when you do this. Just head over to this link and you’ll be able to install the Static HTML: iframe tabs app. It’ll look a bit like this:
You can choose the page that you’d like to embed your form on and that will add the app to the specific page. We’ll come back to that in a jiffy.
Copy the embed code of your form: Not sure how to that? No problem. Just click the Forms tab at the top of your page and then click the Share tab on your form. That will take you the Share section. Scroll down about halfway and you’ll see the embed code. It’ll look a bit like this:
Paste that code into the Static HTML app: Almost there. All you have to do now is go to your Facebook page. Once you’re there, you’ll see an app that says Welcome.
If you give that a click you’ll open the app. Paste in that code that you just copied and click the Save & Publish tab at the top of the page. It will look a bit like this:
Now if you view your page, your form will be there ready to fill out. Pretty simple stuff that will allow you to embed your form directly into your Facebook page.
Enjoy it and as always, let us know if you have questions below!
Even more questions? Fear not. Check out our comprehensive Guides page—-wisdom will be yours.
About a year ago, Magi Metrics built a Microsoft Excel plugin that made it super easy to import your Wufoo data into Excel. “It’s amazing!”, we heard you say. But amongst the celebrations, there were howls of dissent. “It doesn’t work on Mac!” “What about Google Sheets?”
Well, we heard you! And we’re proud to announce, yep, a Google Sheets version. It works on Windows, on Mac and anything with an internet connection.
To Use This Integration
Head on over to Magi Metrics and hit the Signup button to get a 7 day free trial.
Choose Wufoo and then enter your Wufoo username and password.
Click Magi Metrics for Google Sheets to visit the Google Sheets add-on store.
Once installed, Magi Metrics will appear in all your Google Sheets documents under Add-ons > Magi Metrics > Start.
Here’s a peek.
And that’s all there is to it. Just select the Wufoo form you want from the list and hit Insert data. The next time you do it, you can just press Refresh to get the latest results from your Wufoo forms.
If you’d like some help, just contact us or visit our Support section. Happy downloading!
Milo Spencer-Harper is the founder of Magi Metrics
Ready to integrate with Wufoo? Click here to get started.
So you already know that Wufoo is well, pretty darn great at making it easy to collect information online buuuut, that’s just part of the Big Picture. Once you’ve got all those shiny new entries, you probably want to do something with the data, right? Whether you’re looking to build up your email marketing list, collect some new sales leads, or just export the entries into an online spreadsheet for later, Zapier is the way to go.
It’s no secret we’re big fans of Zapier here at Wufoo (and vice versa), but for users not in the know, here’s a quick rundown. Zapier connects a ton of apps together, allowing you to integrate the services you use without a single line of custom code. By automating these connections, Zapier helps you save the time and money that you would have to spend to build the integration yourself, or to hire a developer.
Wufoo + Zapier is such a dynamic duo that we recently co-hosted a webinar to help spread the word. Here are just a few things we covered: - Why you might want to automate a connection between Wufoo and your email marketing, project managment systems, or chat programs - Creating new integrations with Google Spreadsheets, Emma, and Trello - Setting up a Zapier trigger to automate a new integration - How to use filters in Zapier for advanced logic like our Rule Builder
If you have any suggestions or requests for future guides on using Wufoo and Zapier together, let us know in the Comments below!
Don’t forget to check out our comprehensive and handy Guides page to help you do even more awesome things with your forms.
If you’re using Wufoo to run your business, you’re already familiar with how much time Wufoo saves you, how easy it is to set up, and how you can use Wufoo to sell digital and real products by accepting payments online. What you might not be familiar with is how you can use Wufoo to receive feedback from your customers to help you improve your business, get more customers, and ultimately increase your sales. If anything, you’ll gain real insight on how your customers perceive you and your business and what you can do to make your business better and easier to use.
Customer Satisfaction Survey
We’ll start off with the most general and basic of all the customer feedback forms, the Customer Satisfaction Survey. Using our form template, you’ll get the basics of a great customer satisfaction form and from there you can customize it to fit your specific product or service.
Best Times To Use This Form:
- Right after someone has placed a complete purchase through your form. You can even place a link on the confirmation page of your form.
- If you’re using an email service like MailChimp or Campaign Monitor to communicate to your customers, you can reach out to your customer base periodically to get a read on your customer’s base level of satisfaction. Do it a couple of times and you’ll get an idea if you’re improving your service!
Consumer Demographic Survey
The Consumer Demographic Survey is best used when you’re looking to get an idea of who your customers are. This survey lets you figure out the demographics of your customer base. With that information, you’ll be able to tailor your messaging or even product offerings to better match who your customers really are.
Best Times To Use This Form:
- Planning to change your products or services? Use this form to figure out who your customer base is.
- Need to know the demographics of your customer base? Update your email marketing or advertisements to better suit your current customers? This form’s for you.
- Use the negation in your results to find business opportunities. Find out who your customers aren’t and you’ll be able to find a new segment of users to go after to make them your customers.
Market Research Survey
The Market Research Survey is the next logical step to take once you’ve determined your customer satisfaction and their demographics. With the information gleaned from those two forms, you’ve probably got a good idea of what new products or services you want to get into. Now is the best time to use this form to get some more information about the new product line or service to make sure it’s a success out of the gate.
Best Times To Use This Form:
- If you’re in the process of offering a new product or service and want to get an idea of what you should charge for it.
- You are thinking about offering a new product or service and want to know if it’s worthwhile to spend the time developing it.
Customer Service Survey
The Customer Service Survey is pretty self-explanatory. As you know, we work very hard to offer top notch customer service and support and we use a similar survey once a customer has received an answer from us. It’s a really, really invaluable tool to get an idea of how effective our customer support is, what is working, and more importantly, what isn’t working. We use the results from this survey to keep an eye on our customer support efficacy and make sure it’s top notch.
Best Times To Use This Form:
- After a customer contacts you for some help, you should send them this survey to get their immediate feelings about the level of support.
- If you’re looking to offer awesome customer support and create loyal customers. Like Wufoo. Just saying.
Net Promoter ® Score Survey
The granddaddy of them all, the Net Promoter ® Score Survey. It’s so official, we needed to circle-r it. Basically, the survey asks one question and your customer gives a score between 0-10. 9-10’s are your loyal enthusiasts (you want these), 7-8’s are satisfied customers (good but could be swayed to competitors), and 0-6’s are your detractors (basically unhappy customers).
Do some math based off the answers and you have your NPS® score which is an indication of how loyal your customers are. It’s not an end all be all tool but coupled with the above forms and surveys, it becomes another data point for you to determine how satisfied and happy your customers are.
Best Times To Use This Form:
- When a customer cancels a product or service, it’s useful to use this form to get a quick idea of their general happiness.
- Use NPS when you feel your customers don’t have a lot of time to answer a survey but you want to receive some feedback.
Armed with these five customer feedback and satisfaction form templates you’ll be able to start getting insightful and useful feedback and notes from your customers. And if you use that information to make your products or services better, you’ll soon find that happy customers usually means more customers!
Have some tips you’d like to share about obtaining customer feedback? Share below and let us know!
Hey there, Form Builders! Let’s take a look at one of Wufoo’s existing features that we’d love to show off here on the blog—our amazing Allow Other option. This setting is available on the multiple choice field.
So what’s so special about this Allow Other business anyhow? Well, no matter how much we wish it were, it’s not always possible to anticipate every option that your users may want. That’s where the Allow Other option comes in. Rather than creating a set of rules and adding new fields, you can have Wufoo add a text field as an option for your multiple choice field. It keeps all of your data in one place and makes setup a snap.
Let’s take a look at the form we whipped together just for kicks. We’ve created a multiple choice field to find out people’s preferences for a new Wufoo dinosaur, but we knew ahead of time that we wouldn’t be able to name ALL of their preferences.
Click the Allow Other button to add a fourth option: Other. If someone clicks that option, they can enter whatever information they’d like in that text box.
The best part—when you review your data, information entered into that text box will appear right with the other choices. Trust us, it makes reviewing things incredibly easy.
It’s important to note that you shouldn’t use this Allow Other setting when you’re collecting payments. You can assign payments to a multiple choice field through the Payment Settings, but the Other field that’s added here is a text field, so it can’t be used to process custom payment amounts.
If you want to set up a form to allow for other payment options (for example, options for $5, $10, $15, and Other), you’ll need to use field rules.
Create a multiple choice field with the prices and an Other option at the bottom
Add a Price field underneath
Create a Field Rule in the Rule Builder that says if “Select a Choice is Other Show Amount”. This will display that amount field when someone selects Other
Assign prices in the Payment Settings
That’s all there is to it, form fans. We hope this helps you get the most out of just one of our many, many sweet features. Happy Form Building, everyone.
Don’t forget to check out our comprehensive Guides page for even more tips and tricks. See you next time!
We gave out a shout and you listened. Featuring your fine work in forms has been a goal of ours recently and with a little tweet help, we’ve gotten to learn even more about the many different (and cool!) ways you guys use Wufoo.
Without further ado, let us introduce you to Amy Ballinger, owner of Moksha Yoga Hamilton in Ontario, Canada. Amy’s business goal is centered around de-stressing, strengthening and calming the minds and bodies of her clients. And you know what, we can relate. Our forms are designed to do the same for our customer base as well—with less sweat on our ends though.
The floor’s all yours, Amy.
Having the right systems in place
As the owner of a yoga studio that is part of a collective of hot yoga studios called Moksha Yoga in Canada and Modo Yoga in the United States, I used to think that owning a studio meant that you could do yoga all day. Now I know that creating a space for people to let go of their stress means that the behind-the-scenes things need to run really smoothly. Over the four years that this studio has been open, Moksha Yoga Hamilton has developed into a space that welcomes more than 200 people every day, a vibrant community of people all working to reduce stress and create more peace in their lives. The studio space, and all the admin and operations work it takes to run it, need to run smoothly and with ease to create the sense of peace and relaxation people get the minute that they walk through our doors.
I’m a big believer that being organized for your staff and having systems in place for them to use reduces work stress while also fulfilling the needs of the studio. When people can follow a clear list of steps or a checklist, they know exactly what they need to do and how to do it, and this allows for them to be a lot more peaceful and present with our clients. They are never scrambling around or feeling panicked trying to figure out what to do.
Streamlining operations, setting expectations
I use Wufoo mainly to streamline the studio’s operations, set expectations, provide access to more detailed information, collect orders and gather feedback. Pretty much anything I can turn into a Wufoo form, I do. I would say that I am known for my Wufoo obsession! A few examples for you:
Checklists: Step-by-step lists of things that need to be done (ie. what to do when you open the studio in the morning: turn off the alarm, adjust the heat settings, fold the towels in the dryer, etc, etc)
Feedback: We use feedback forms that we have created in Wufoo to give clients the opportunity to give feedback about their experience in the studio, Teachers to give feedback to one another on how to improve their classes, and front desk staff to give feedback about their shift (ie. if they had any issues with the cash out, the highlight of their shift, any questions, etc). Not only that, all of my other forms (like checklists) include space for people to share their feedback, ideas for improvement, any challenges encountered, etc. This is helpful for me to continuously improve the way we do things and to address any difficulties.
Reports: We use the forms as incidents reports to keep track of notable situations at the studio or things that require client follow-up.
Manuals/Guidelines: This is a big one for me and where my love for Wufoo really deepened. I learned how to make hyperlinks in forms and I use them to connect to specific notes in Google docs or Evernote with more information.
For example, I can have something in a form that says ‘adjust the heat settings’ as a hyperlink, and if the person isn’t sure how to do this, they can click and the step-by-step instructions of how exactly to adjust the heat pops up. This way I can streamline the Wufoo form (so that it isn’t information overload), but any time the person using the form needs more info, it’s right there without them having to search. This is also great to link to troubleshooting steps.
Inventory: We use Wufoo forms for things like cleaning supply checklists to run through and make note of anything we need more of. Then I can access the email from my phone when I’m out picking up more supplies.
Order Forms: My latest addition to my roster of forms was a food order form for an event we did with a local juice bar. I took advantage of the awesome reporting features and created not only a form for people to fill out to submit their food order, but a report that tracked the exact total of each item that the juice bar needed to make. I provided them with direct access to the reports with the totals for each day and they delivered the food. It worked really well.
Forms as rite of passage
EVERYONE uses Wufoo here. Haha…But seriously. Everyone. From every teacher, desk staff, volunteer cleaner to client. It’s almost like a rite of passage to Savasana at MYH. I’m a big believer that good systems lead to a relaxed environment. I used to worry that things like systems and checklists would make the studio seem ‘corporate’, but now I realize that that is what makes the studio feel so good. Staff and teachers have the ability to be really calm, present and engaged with clients when they’re not feeling frantic over figuring out what to do and how to do it. Having information and clear steps at their fingertips also helps to ensure that everything gets done that the studio needs to look, feel and operate at its best.
Don’t forget to Zapify!
I’m appreciative that this business exists, that it’s affordable and that it has the same fun and silly vibe that we have at the studio. It shows me that offering a great service doesn’t necessarily mean that it’s dry and corporate, or come at the cost of the vibe. I mean, how can anything be super ‘corporate’ when the profile avatars look like they do and when you go to login and it says “RAWRR”. Even the bottom of this form says “Zapify!!” when it could just say “submit”. Man, I love you guys.
Amy—we feel the love too, right back at ya. And namaste, everyone.
For more information on Moksha Yoga Hamilton, please visit their super chill site here.
We’re here to make your lives easier and the more we get to learn about all of the different ways that Wufoo can be used, the more we get to do just that.
So we want you to have your blog moment in the sun. Have an awesome use case of your own you’d like to share with our readers? Fill out our form here and we’ll reach out.
Now back to our regular programming. Let’s put our school pants on, shall we? Please welcome Mike Richwalsky, Executive Director of John Carroll University. JCU is a private, coed, Jesuit Catholic university in Ohio. Mike’s here to share how JCU uses Wufoo on their campus.
Take it away, Mike!
I first came across Wufoo at my previous institution and fell in love with the features and their awesome support. I’m now at John Carroll University and we use Wufoo for just about every area on campus. From fundraising, to event registration, to surveys…you name it, we do it.
Here’s an example of just one of our forms in action.
One of the biggest advantages for us is how easy the form-building system is to use. Because of the simplicity, we’ve given accounts to our campus users and basically sent them off on their own to build, build, build their own forms. Our employees have also used the Wufoo embed feature where they can copy/paste their forms directly into their websites. This ability cuts down on the amount of forms that need to be made and reduces our own support calls. Great stuff!
The API is awesome and we’re in there quite a lot. And, in the spirit of customer feedback, we offer this suggestion up for you Wufoo wizards—we have a LOT of forms that we create and sometimes the initial loading/searching abilities can take a little time to catch up.
For you readers out there looking for ways to utilize Wufoo on their campus, let me know in the Comments below. Pretty much every department from JCU’s Athletics, Admissions, Academics, (on a roll with the A’s), Marketing and Student Life has a Wufoo form in action. We’re 3+ years in and counting and would love to hear about how you use forms on your campus.