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

  • afgcashout
    Asked on May 6, 2016 at 3: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!

  • David JotForm Support Manager
    Replied on May 6, 2016 at 4: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.