parsing the last four digits of a field to the email notification

  • Profile Image
    northpointam
    Asked on January 26, 2016 at 01:29 PM
  • Profile Image
    Kevin_G
    Answered on January 26, 2016 at 04:20 PM

    Could be possible to get more details about your request please?

    We will be glad to assist you.

     

  • Profile Image
    northpointam
    Answered on January 27, 2016 at 12:48 AM

    Hello, When configuring an auto reply email from a form submission, I am interested in parsing out the last 4 digits of a particular field to include in the alert email.  Is there a way to modify the field reference to do this?  If so what is the syntax.

     

    For Example if I want the last 4 digits of a bank account number to show in the email alert, I would want to parse out the last 4 characters of the {bank_Acct_#} field.   If excel I would use the =RIGHT(cell,4) function. is this possible to do in the jotform email alerts?  

  • Profile Image
    TitusN
    Answered on January 27, 2016 at 04:46 AM

    I'm afraid you cannot extract the last four digits from the results directly using a parameter.  The result is submitted as one property of the bank account field result - it can only be split programmatically before submission. 

    You could consider splitting the bank account number across two (or more) text input fields. 

    You can then use the last input box with the last four digits in your email notification. 

    We could help you style the fields such that they appear as the same field on the same line. 

    Let us know.