Use fields from their previous form, or information from CSV?

  • davsun55
    Asked on December 3, 2018 at 6: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

  • John_Benson
    Replied on December 3, 2018 at 11:01 AM

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

    1543852745zxfgt134123 Screenshot 10

    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.


  • David Sunderland
    Replied on December 3, 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

  • Ashwin JotForm Support
    Replied on December 4, 2018 at 5: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.