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

    How can I send auto-email responses to email addresses that the user fills into a spreadsheet?

    Asked by knoxr1 on June 29, 2017 at 02:01 PM

    I am giving applicants the option to consolidate contact information for multiple different sites into one application, which I would like to have in a spreadsheet. What I need is to be able to send auto-emails to the email addresses that the applicant will indicate inside of the spreadsheet. How do I set that up?


    Thank you

  • Profile Image
    JotForm Support

    Answered by John_Benson on June 29, 2017 at 05:14 PM

    This is possible by using the Form Calculation widget in the Input Table. For more information, please check this guide: https://www.jotform.com/help/343-How-to-Perform-Form-Calculation-in-the-Matrix-Field

    After that, you need to copy the field value of the Form Calculation widget to the Email field. This field will be used as the recipient of the autoresponder email. To pass data to another field, please follow this guide: https://www.jotform.com/help/286-How-to-Pass-Field-Value-to-Another-Field

    You need to create multiple autoresponder emails for each email fields. Here's a guide: https://www.jotform.com/help/26-Setting-Up-an-Autoresponder-Email

    If you don't want to use the Update/Calculate Field condition (Pass field value to another field), then you can try using the email conditions, here's the guide: https://www.jotform.com/help/167-How-to-Send-Email-Based-on-User-s-Answer


    Here's my demo form: https://form.jotformpro.com/71573656677976

    You can clone the form if you would like to check the conditions and autoresponder configuration. Here's a guide: https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL


    If you have questions regarding on the guides I have given, please don't hesitate to ask us. We're here to help. Thank you.

  • Profile Image

    Answered by knoxr1 on July 03, 2017 at 12:01 PM

    Thank you for the steps. I have the input table and the form calculation widget set up, but I'm having trouble passing the email addresses from the calculation (pulled from the input table) into the email field. I know how to set up email autoresponders/conditions, but I can't figure out how to get the email addresses from the input table into the email fields. Please advise.

    Thank you

  • Profile Image
    JotForm Support

    Answered by John_Benson on July 03, 2017 at 02:06 PM

    I checked your form and I noticed that you didn't add the Pass Field Value to Another Field conditions. For more information, please follow this guide: https://www.jotform.com/help/286-How-to-Pass-Field-Value-to-Another-Field

    I cloned your form and I have set the condition for first email field. You need to do that on all of the email address fields. Here's the clone form link: https://form.jotformpro.com/71835061577966. Here's the result:

    Here's how I set the condition for the first email field:

    1. I have removed the old Form Calculation and added a new one.
    2. Open the Form Calculation Wizard and add the "If you intend to provide food/beverages..." Input Table field.
    3. Select the First Email in the Input Table field.

    After that, set the Update/Calculation condition to Pass the value to another field. Here's how:

    To check my condition configuration, you can clone the demo form. Here's a guide: https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    Hope that helps. Please contact us again if you have questions.

  • Profile Image

    Answered by knoxr1 on July 11, 2017 at 07:18 PM

    That worked, thanks! The problem I'm running into now is that even though those fields are hidden on the form, they are visible when users receive an email with PDF of the form data. What setting do I need to change to keep those fields hidden at all times? 

    Thank you
  • Profile Image
    JotForm Support

    Answered by EltonCris on July 12, 2017 at 12:22 AM

    Uncheck those fields in your form submissions page settings. This excludes them on the PDF.