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

    Populating form fields with values from a Google sheet?

    Asked by jonnavarra on September 07, 2015 at 01:42 AM

    from what I've read in the forum, it sounds like this functionality, that is the ability to populate my form with data from a row in my spreadsheet, is not available.

    questions are:

    will this feature be available in the near future?

    can you recommend a possible solution or work around to this requirement. I will not be able to include the values in my URL as there will be many fields I need pre-populated.

    Unrelated to above (was going to look it up here but didnt get a chance)- how can I turn off the notifications after every submission of the form. Each submissions counts up against my 100 limit and will most likely exceed that while developing and testing... any chance the feature can be temporarily disabled?

    thanks

     

    sheet values a Submissions pre-populated thanks solution
  • Profile Image

    Answered by Sammy on September 07, 2015 at 06:18 AM

    At the moment we do not have the functionality available, I will submit a feature request to our developers but I wont be able to estimate the delivery period at this point in time.

    You can use third party libraries to feed data to your form using JSON, kindly refer to one of these solutions

    http://chriszarate.github.io/sheetrock/

    http://www.ravelrumba.com/blog/json-google-spreadsheets/

    To seamlessly implement with solutions you will have to download your forms full source code so that you will be able to integrate properly.

    https://www.jotform.com/help/104-How-to-get-the-Full-Source-Code-of-your-Form

     

    Please let us know if you need assistance with getting started.

  • Profile Image

    Answered by Sammy on September 07, 2015 at 06:21 AM

    Regarding you second question about receiving email notification for each submission, all you need to do is delete the notification emails for the particular form.

    It is currently not possible to turn off/disable the submissions quota count for form submissions.

  • Profile Image

    Answered by jonnavarra on September 07, 2015 at 07:34 AM

    thanks for the response.

    however each submissions goes up against my quota, which i will likely exceed during my development.

    what happens when i exceed my quota? My forms are locked and I'm not able to do anything until the next month or something?

    thanks

    Jon

     

     

     

  • Profile Image

    Answered by Shadae on September 07, 2015 at 10:55 AM

    Hi Jon,

    Once you have reached your form submission limit, your forms will be disabled until your submission count resets on the 1st of each month.

    You can also upgrade your account at any point. Please see our pricing page to see our available plans and the benefits associated with each.

    Please feel free to contact us if you need further assistance.

  • Profile Image

    Answered by jonnavarra on September 07, 2015 at 12:45 PM
    I've already subscribed for a year. 
    I think that is a little bit on the shady and sneaky side to expect customers to be ok with being charged against the quota when forms are still being developed. 
    You guys know the effort it takes to create these things and while your product makes it easier there's still the need to test which could easily consumed ones quota. there should be a "development quota"  extended to free developers from losing access to the forms because of overage.
    I'm creating several forms on my site, and this being my first foray into jot form you have to expect lots of trial and errors. So i now have the additional exercise to watch my testing because I'm near exceeding my quota, which if i do do reach it, I'll either be useless or forced to upgrade to a more expensive plan- 
    so maybe that is the plan with these limits.
    Got it! 
    Sent via the Samsung Galaxy Note® 3, an AT&T 4G LTE smartphone

    ...
  • Profile Image
    JotForm Support

    Answered by ashwin_d on September 07, 2015 at 01:42 PM

    Hello,

    I have moved your question to a new thread and you will be answered here:  http://www.jotform.com/answers/656459 

    Thank you!