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

  • Profile Image
    rabebri
    Asked on March 28, 2016 at 11:27 AM
  • Profile Image
    Mike_G
    Answered 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.

  • Profile Image
    rabebri
    Answered 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_0but this does not work.
    I appreciate any help you can provide.
  • Profile Image
    rabebri
    Answered on March 28, 2016 at 01:44 PM
    Hi Mike
    I didn't realize that I had submitted a question about this but I do have
    ...
  • Profile Image
    BJoanna
    Answered on March 28, 2016 at 03: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.

    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.