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

    Can I pull data from my underlying google sheet back to the form?

    Asked by afgcashout on May 06, 2016 at 03:48 PM

    If so, how? I'd like to make a condition that only allows one submission with the same date which is something that would have to query my submissions spreadsheet in order to work. I'd also like to display a message if it doesn't work.

    Similarly, I have a google sheet that contains a summary from a number of forms and totals certain information from each. Is there a way to pull a piece of this information back to a form to use as a check total / condition of submission? An alternative would be if there is a way to sum the same field from a number of different submissions of a number of similar forms. If either is possible, can you help me through the process?

    Liking what I can do so far! This could greatly simplify what has always been a fairly complex and time consuming workflow for us. Thanks!

    Page URL:
    https://form.jotform.com/61244724890155

    pull data sheet Submissions message check different
  • Profile Image
    JotForm Support

    Answered by BDAVID on May 06, 2016 at 04:46 PM

    Looks like you are looking for a more complex system. Unfortunately, we do not have a feature to automatically pull data from another resource, nor the capability to query the database to trigger a condition.