FAQ

Frequently asked questions about Sprout Forms.

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

Craft 3

Sprout Forms for Craft 3 comes with Email, Phone, and URL fields.

Craft 2

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?

Craft 3

Sprout Forms for Craft 3 includes a native Sprout Reports integration to create and export reports for Sprout Forms Data Sources without ever needing to install Sprout Reports. Visit the Sprout Forms -> Reports tab in Sprout Forms to create reports and export CSVs.

Craft 2

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 3):

  • storage/runtime/logs/web.log

In your files (Craft 2):

  • 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?

Craft 2

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.