How to show data from matrix table fields separately inside of email Notification?

  • rabebri
    Asked on March 28, 2016 at 11:27 AM
  • Mike_G JotForm Support
    Replied on March 28, 2016 at 12:29 PM

    I'm sorry, I'm not sure I understand what your concern is really is. Can you help us by giving us more information or details, please?  We will wait for your response. Thank you.

  • rabebri
    Replied on March 28, 2016 at 12:56 PM

    Hi Mike

    I didn't realize that I had submitted a question about this but I do have one.
    I would like to create an email notification which reports data from the rows of a matrix independent of the table (I am able to get data from the entire table/matrix by using the form field for the matrix (i.e., {RatingsAcAch} )
    I was wondering what codes I would enter to report the 8 items of the matrix separately?
    The 8 ids listed in the properties of the matrix are: #input_128_0_0, #input_128_1_0, #input_128_2_0, #input_128_3_0, #input_128_4_0, #input_128_5_0, #input_128_6_0, #input_128_7_0
    I assumed the form field (or subfield) code would include the matrix name/form field{RatingsAcAch} + the individual ID and be something like the following:{RatingsAcAch#input_128_1_0} but this does not work.
    I appreciate any help you can provide.
    How to show data from matrix table fields separately inside of email Notification? Image 1 Screenshot 20
  • rabebri
    Replied on March 28, 2016 at 1:44 PM
    Hi Mike
    I didn't realize that I had submitted a question about this but I do have
    ...
  • BJoanna
    Replied on March 28, 2016 at 3:11 PM

    Unfortunately that is not possible to achieve. It is not possible to separate data from the rows of a matrix inside of email Notification.

    However there is possible workaround for this issue. You would need to add 8 Form calculation widgets to your form and then set calculation to show data from specific matrix field inside of Form calculation widget. 

    If you want to pass text values then you need to set matrix table field to (A-Z) inside of form calculation widget.

    How to show data from matrix table fields separately inside of email Notification? Image 1 Screenshot 20

    Then you will need to add Form calculation fields to your email Notification. 

    You can use hide option to hide form calculation fields form your form. 

    Here is my sample form: https://form.jotform.com/60875890177974 

    Feel free to clone it.

    Hope this will help. Let us know if you need further assistance.