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

  • Profile Image
    knoxr1
    Asked 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

    Screenshot
  • Profile Image
    John_Benson
    Answered 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
    knoxr1
    Answered 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
    John_Benson
    Answered 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
    knoxr1
    Answered 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
    EltonCris
    Answered on July 12, 2017 at 12:22 AM

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

    http://www.jotform.com/help/269-How-to-view-Submissions

    Example: