What is the fastest way to create dozens of conditional emails?

  • Profile Image
    data577
    Asked on June 10, 2020 at 03:29 AM

    I have already gone through the guide on how to send email based on a user's answer. My question is whether anybody can offer insights to help speed up that process.

    I have a form where a user selects a model from a dropdown list, and assigns a quantity to that model. Based on the selected model, I want a notification to be emailed, with all the ingredients for that model. The problem is that the total number of models is around 120, and each model has around 6 ingredients on average. That's a total of about 700 fields to update across 120 notification mails.

    Is there any way to speed up this process? The best I can think of is mail merge, but that still leaves manually creating 120 notification mails in JotForm.

    All of this would have been much simpler if only Jotform would allow forms to pull data in real time from a database or a Google spreadsheet. Any ideas or suggestions, please? (I know about the Spreadsheet to Form widget, but that doesn't update anything in a live form)

  • Profile Image
    JohnRex
    Answered on June 10, 2020 at 07:37 AM

    Unfortunately, you need to create one condition for each selection. But a workaround I can think for the email content is that you use this condition: How-to-Insert-Text-or-Calculation-into-a-Field-Using-Conditional-Logic.

    You'll only be needing one email template for this and a long text entry field. But you'll be creating 120 conditions.

    Here's how it works:

    If the user selected a MODEL from the dropdown field, create the UPDATE field condition:

    15917887952379420.png

    Now, the content of the INGREDIENT field will depend on the selection made. And since the email template is defaulted to accept dynamic values of the field, what will be shown in the email will depend as well to the selection, so no need to create a bunch of email templates with different contents.

    15917889252379420 2.png

    Here's a demo form: https://form.jotform.com/201613397219051 

    Please use your email to test it.