FAQ

Frequently asked questions about Sprout Forms.

# I am using the available Captchas but I am still getting SPAM!

Spam strategies are always evolving and sometimes the conventions you use on your website will also need to evolve. The default options provided don't depend on third-party services however, often, third-party services have a larger network of data to work with to provide effective spam prevention measures.

To better understand your spam traffic, you can enable Spam tracking and Sprout Forms will log all Failed Captcha error messages as well as capture meta information about each submission such as Remote IP Address, Referrer URL, and User Agent. The Spam Log report provides an overview of all of this information that can be used to analyze the data and detect trends.

# How do I validate an Email Address, Phone Number, or URL?

Install Sprout Fields! Sprout Fields provides you several additional field types to help ensure you're collecting clean and accurate data.

# How do I export my form Entries to CSV?

You can use Sprout Reports to export your Form Entries to CSV.

To export all entries from a particular form, you can create a custom SQL query to target that form. Each form uses a different table in the database.

For example, to export all data for a form with the handle contact

SELECT * FROM craft_sproutformscontent_contact 

You will need to update your query to match your Craft database prefix and your form handle. Here is a generic example template of what this query should be using variables that you will need to update for your use case:

SELECT * FROM {databasePrefix}_sproutformscontent_{formHandle} 

# My form submissions are not working. My submitted form entries never appear in my database. What is broken?

When form submissions never make it to the database, usually something else is blocking them.

Do you have any spam plugins installed? Try disabling them or making their settings less strict.

Are your forms triggering any other events that may be causing errors? Spam filters or email notifications that are failing could affect your form entries from reaching the database.

Check your logs and see if there are any errors:

In your files:

  • craft/storage/runtime/logs/sproutforms.log
  • craft/storage/runtime/logs/craft.log

Or in your Control Panel:

  • /admin/utils/logs

# My form notification emails are not being sent. Or, my form notification emails are sometimes being sent but behaving erratically.

The most frequent issue that causes notification emails to not be sent or behave erratically is the selected Email Protocol. By default, this is usually set to PHP Mail. PHP Mail and Sendmail are often misconfigured on local computers and may be configured in a variety of different ways by hosting providers. They also do not provide much information to help troubleshoot what might be going wrong.

The first step necessary to better troubleshoot why notifications are not behaving as expected is to update your settings to a proper SMTP Protocol. Mandrill or MailGun are good options and MailGun has a free plan which allows you to send up to 10,000 emails a month, if cost is a concern. Once you are sending email via Mandrill and MailGun, they also can provide more information on what is happening to your email after it is being sent.

Another decent option to troubleshoot with is Gmail. While Gmail doesn't provide as much information on how emails are behaving after they are sent, and can sometimes behave in unintuitive ways if you are sending and receiving from the same Gmail address, it is more reliable than PHP Mail and Sendmail and most people have a Gmail account.

# Where can I install example forms after Sprout Forms is installed?

You can install the default example forms in the Control Panel at admin/sproutforms/examples or find a link to install the Example Forms in the Sprout Forms Settings area.