Display latest values in form grid in email

 
1
0
-1

I want to display the latest values inserted in the form grid of the form, but right now, when i check the email, its has failed to retrieve the value.


Table name for the form that the form grid is referring to is called, lg_edit_addInfo


Below is how the form look like.


But this is added in the main form as a form grid.

current output is like this in email.


    CommentAdd your comment...

    2 answers

    1.  
      3
      2
      1

      hello i suggest you to use hash datalist with filter search on the email tool and you have to make a datalist jdbc database binder, on there you can inner join the data from the form grid. heres the example :

      1. The datalist

      2. How to use Datalist Hash

      3. Output

      1. sushidetest

        or you can use nested hash form, but you need to add a hidden field with id parent_id. both solution working if your main form and form grid stored on different table.

        hope it help

      2. Di Sheng

        Much thanks, your solution works for my case. 

      3. sushidetest

        you are welcome

      CommentAdd your comment...
    2.  
      1
      0
      -1

      Find the sorting property and enable it. Set the default sorting field. See the pic below.

      1. Di Sheng

        hi, the answer you have provided, doesnt work with what i want. I have applied your solution and it doesnt work as current output in the email is still the same.

      CommentAdd your comment...