Does this provide the ability to use fields from their previous form, or information from say a .CSV?

  • Profile Image
    davsun55
    Asked on December 03, 2018 at 06:52 AM

    Does this provide the ability to use fields from their previous form, or information from say a .CSV? That would allow us to customise the emails with an amount outstanding and/or confirmation of their booking details.

    Thanks

    David



    This is a re-post of a comment on How to Set Reminder Emails for Your Forms

  • Profile Image
    John_Benson
    Answered on December 03, 2018 at 11:01 AM

    You can customize the email by adding an image or changing font styles. Here's a screenshot:

    1543852745zxfgt134123.png

    Does this provide the ability to use fields from their previous form, or information from say a .csv?

    Please provide more details of what you're trying to achieve so we can assist you properly.


  • Profile Image
    David Sunderland
    Answered on December 03, 2018 at 11:56 PM

    The sort of email we'd like to send is this, where the fields in «field» need to be populated from a CSV file:

    Hi «Firstname»,

    You will be staying in «Accom».

    We believe you have already paid $«Deposit» of your total cost of $«Total», leaving a balance of $«Balance». If that’s incorrect, please let us know.

    Full payment is requested by this Friday 23rd

    Pay by credit or debit card using this link https://form.jotform.co/80772932829872?groupName=«Group_name»&Email=«Email»&totalCost=«Total»&Paid=«Deposit»&Balance=«Balance»

    Thanks,

    David

  • Profile Image
    ashwin_d
    Answered on December 04, 2018 at 05:00 AM

    Unfortunately no it is not possible to populate data in email alert from any external source. 

    If you want you can take advantage of our "Spreadsheet to form" widget and see if it fits into your requirement. This will allow you to populate data in your form field from excel spreadsheet file. You may also like to take a look at the following guide as well which should help you:  https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget

    Hope this helps.

    Do get back to us if you have any questions.