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

  • northpointam
    Asked on January 26, 2016 at 1:29 PM
  • Kevin Support Team Lead
    Replied on January 26, 2016 at 4:20 PM

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

    We will be glad to assist you.

     

  • northpointam
    Replied 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?  

  • TitusN
    Replied on January 27, 2016 at 4: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.