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

    If I integrate my form with a google spreadsheet, is it possible for that spreadsheet to send an email with the results which are calculated by the sh

    Asked by smithkim on April 14, 2013 at 04:34 PM
    Page URL:
    Noneyet

    email integrate
  • Profile Image
    JotForm Support

    Answered by EltonCris on April 14, 2013 at 07:55 PM

    Hi,

    Can you please complete your question? I can't seem to understand it well. 

    Also, I am thinking what you want to achieved is not possible with gspreadsheet. If I got your question correctly, how about using grid listing or html table listing report? You can add them to your autoresponders.

    Grid Listing

    Create an HTML Table Listing Report

    We'll wait your reply about this. Thanks!

  • Profile Image

    Answered by smithkim on April 15, 2013 at 03:46 AM
    Hi, the missing word in my question is sheet, which I think you probably guessed. It seems my question just had too many characters!From what I can make out, grid listings and table listings only show the submissions. I want to be able to send each person who makes a submission the outcome produced by the spreadsheet. I can make that outcome appear in my webpage by embedding the googlesheet there and then it gets updated automatically but I then want a way of sending that output to the user.Kim
  • Profile Image
    JotForm Support

    Answered by Welvin on April 15, 2013 at 04:31 AM

    Hi Kim,

    Please note that modifying the Google Spreadsheet result may brake the integration. Also, the results or submissions are not separated on a different sheets, they are group in a single spreadsheet.

    You may just do this manually and send them the result using their email addresses from the form submissions list.

    Or, if you can manage "ImportRange".

     

    Thanks

  • Profile Image

    Answered by smithkim on April 15, 2013 at 04:39 AM
    Thanks. I have used importrange recently so I know how that works. But that still doesn't tell me how to automate the result to the user?
  • Profile Image
    JotForm Support

    Answered by Welvin on April 15, 2013 at 04:55 AM

    Hi Kim,

    You may consider publishing/sharing the Google Spreadsheet as HTML then just give them the link through your Form Auto Responder. The HTML Link is live and will capture any updates made on the sheet.

    Thanks

  • Profile Image

    Answered by smithkim on April 15, 2013 at 05:09 AM
    That's a manual process each time though isn't it? I want this automated if possible.
  • Profile Image
    JotForm Support

    Answered by Welvin on April 15, 2013 at 05:36 AM

    Hi Kim,

    No, all are automated. You will have to use the ImportRange Function to query all the results from the original sheet into another spreadsheet. This another spreadsheet will contain your formulas/calculations. You can then share this another spreadsheet in HTML Method as suggested on my previous response. 

    Let me know if you need more clarification or let me know if I am lost on what you are trying to achieve. You want to calculate the results, right? The mean purpose of this method base on what I have understood is how you can manage to calculate the results and share it to anybody.

    Or, if you mean to automatically calculate submission individually and also give them the result into a separate single spreadsheet, unfortunately, that is not possible with this method. All submissions are present on a single spreadsheet and formulas for each submissions are visible to everyone.

     

    Thanks

  • Profile Image

    Answered by smithkim on April 15, 2013 at 05:46 AM
    I understand what you say. However, although the resulting calculation is shown on a webpage, the user still doesn't receive an email with the results, which is what I would ideally like.
  • Profile Image
    JotForm Support

    Answered by Welvin on April 15, 2013 at 06:09 AM

    Hi Kim,

    An Email from the Google Spreadsheet result changes is not possible.

    You may consider giving them the link through "Form Auto Responder" as suggested above and advice them to bookmark the link and check every time.

     

    Thanks