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

    Notification if a form has not been completed

    Asked by sidneyg on September 20, 2016 at 09:13 PM

    We would like to be notified if a form has NOT been completed over a certain period of time.  Example: Our staff must complete an inspection report every 30 days.  I would like to be notified if the form has not been completed after 35 days from the last inspection.  If they do complete the inspection within the 35 days, the 'timer' starts over and will notify me if they do not complete the form in another 35 days.  Hope that makes sense.  

    a and another after in
  • Profile Image
    JotForm Support

    Answered by Charlie on September 20, 2016 at 11:25 PM

    Unfortunately, we do not have this kind of feature. The form will only trigger email alerts if it is opened and if a submission has been made.

    I believe what you are looking for is much more of an automated system and needs a developer and a web server for a custom script. Here are my suggestions on how you can set this up:

    Option #1:

    1. I'll create a custom script that will periodically checks the number of submissions of a form or depending on the date range. You can use JotForm's API for this: http://api.jotform.com/ 

    2. You'll have a web server where you will need to trigger the custom script on a interval, if you have a web server with a Cron job, then that would work.

    3. Your custom script will then send an email to you if the number of submissions or if there's no submission made on a date range.

     

    Option #2:

    1. You can try integrating your form to Google Spreadsheet.

    2. Now you can use App Script in Google to monitor the number of submissions in the spreadsheet, or you can monitor by date. Here are some examples that you can refer to:

    https://zapier.com/learn/google-sheets/google-apps-script-tutorial/ 

    https://mailparser.io/blog/send-emails-from-google-spreadsheet/ 

    http://stackoverflow.com/questions/11025491/google-apps-script-send-email-based-on-date-in-cell 

     

    This is out of our scope so you might need to hire a developer for this if you are not a programmer. 

    I hope that helps.

  • Profile Image

    Answered by Tom  on November 07, 2016 at 02:32 AM

    thanks for posting this information as i needed it most keep updating me about this topic

    Register Coupon