Hand written forms

  • joe2037
    Asked on February 23, 2017 at 7: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 petition template 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?

  • KadeJM
    Replied 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.

  • joe2037
    Replied 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
    ...

  • KadeJM
    Replied on February 23, 2017 at 1: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.

  • joe2037
    Replied 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?
    ...
  • David JotForm Support Manager
    Replied 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:

    Hand written forms Image 1 Screenshot 20

    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.

  • joe2037
    Replied on February 26, 2017 at 12:46 PM
    Rather than one at a time, can that be done in mass?
    Sent from my iPhone
    ...
  • Mike_G JotForm Support
    Replied on February 26, 2017 at 1: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.

  • joe2037
    Replied on February 26, 2017 at 3: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
    ...
  • jonathan
    Replied on February 26, 2017 at 8:08 PM

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

    Thanks.

  • aubreybourke
    Replied on June 16, 2017 at 7: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