What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Hand written forms

    Asked by joe2037 on February 23, 2017 at 07:14 AM

    is there an import option that would import into the database as well as Kickoff the workflow of auto response and e-mail workflow? There are people that we are getting hand written petitions from. I can put these into an excel doc but I want the workflow emails to Kickoff upon import just as they would if the petition was signed digitally if it can be done. If not, what are your recommendations?

    Page URL:
    Http://supportclifton.com

  • Profile Image

    Answered by KadeJM on February 23, 2017 at 10:41 AM

    Do you mean that you want to send emails after your form has received submissions to be sent to an excel document? Pardon, but I am not sure if I am understanding you correctly about your import kickoff workflow so please feel free to correct me if needed.

    Based on your explained scenario you can export your submissions to an excel report or use our google spreadsheet integration as they are received from your form.

    Additionally, you can also send emails after your form is submitted to you which would technically be at the same time since this is the default function for it when the form is sent. But, you can even send emails based on conditions.

  • Profile Image

    Answered by joe2037 on February 23, 2017 at 11:46 AM

    Hi,
    I have a petition form on supportclifton.com/petition to take in petitions via JotForm. Once filled out, the workflow then sends the user a confirmation email as well as sending the form response to multiple individuals in the State legislation. Since in the community there are older people which may not have the access to, or understanding of how to fill this out digitally, we are approaching them to provide us their information to add to the petition in an excel form on a laptop offline.
    Instead of someone taking all of these entries and manually typing them into the form to Kickoff the workflow in JotForm that sends to the senators, can we somehow import this excel document in JotForm and have their information added in your form database as to Kickoff the email workflows that would have taken place had they filled out the form digitally, or is the only option to manually enter each one of the forms via copy pasting every field for every user one by one through the front end on my website?
    Thanks,
    Joe
    Sent from my iPhone
    ...

  • Profile Image

    Answered by KadeJM on February 23, 2017 at 01:18 PM

    Joe, thank you for the details on your workflow. I believe I understand what you mean now.

    We do have an Import App that you might find useful.

    It basically allows you to import your Excel or CSV data as submissions but unless you add this to a form you have on your account containing an autoresponder followed by editing each of them otherwise it would not send any email to those submissions.  

    Doing the above with the import app would at least migrate your spreadsheet data to the digital form at least, though.

  • Profile Image

    Answered by joe2037 on February 26, 2017 at 10:46 AM
    So if I use the auto import app it will Kickoff the auto responder workflow
    but not the notification workflow. Is that correct?
    ...
  • Profile Image
    JotForm Support

    Answered by BDAVID on February 26, 2017 at 11:52 AM

    The import app only imports the data into the submissions of one of your forms. It does not trigger any email notification or autoresponder.

    However, as my colleague said, if you have already created the notification and/or autoresponder, and have enabled the send on edit option:

    They will be sent upon editing the submission through the submissions dashboard: https://www.jotform.com/help/269-How-to-View-Form-Submissions 

    Let us know if you need more help.

  • Profile Image

    Answered by joe2037 on February 26, 2017 at 12:46 PM
    Rather than one at a time, can that be done in mass?
    Sent from my iPhone
    ...
  • Profile Image
    JotForm Support

    Answered by Mike_G on February 26, 2017 at 01:34 PM

    Apologies for any inconvenience, I'm afraid there is no option available that will allow you to resubmit all the submissions on the submission page of your form at once.

    Thank you.

  • Profile Image

    Answered by joe2037 on February 26, 2017 at 03:46 PM
    Is there a way to remove duplicates from the count of the submitted forms? I would like to show both the total submissions and total unique submission if possible
    .
    Sent from my iPhone
    ...
  • Profile Image
    JotForm Support

    Answered by jonathan on February 26, 2017 at 08:08 PM

    We will resolve the next question on another thread here https://www.jotform.com/answers/1076599

    Thanks.

  • Profile Image
    JotForm Support

    Answered by aubreybourke on June 16, 2017 at 07:05 AM

    Just in response to you your question:

    "is there an import option that would import into the database?"

     

    Yes, but it will require a bit of programming. You can get some sample code here:

    Form to MySQL - Send form data to your MySQL Database

    & Webhook PHP Script Examples

    & How to Setup a Webhook with JotForm 

    Also:

    How to send Submissions to Your MySQL Database Using PHP