Thu, 24 Sep 2026
Login

Display latest values in form grid in email

Confluence User - 03 Oct, 2023

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.


forms;email

6

Confluence User •
03 Oct, 2023 •
confluenceUser •
•
confluenceUser •

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

Confluence User •
04 Oct, 2023 •
confluenceUser •
•
confluenceUser •

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.

Confluence User •
04 Oct, 2023 •
confluenceUser •
1 •
confluenceUser •

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

Confluence User •
04 Oct, 2023 •
confluenceUser •
•
confluenceUser •

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

Confluence User •
05 Oct, 2023 •
confluenceUser •
•
confluenceUser •

Much thanks, your solution works for my case. 

Confluence User •
05 Oct, 2023 •
confluenceUser •
•
confluenceUser •

you are welcome

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Process not starting with Form submission.
Form Submission Performance Issue
Export As PDF
Select Box
one to many relationship
Can we create a dropdown field directly in a Joget List so that users can change the status of a record from the list view itself?
How to auto load client data after selecting it in a dropdown?
Retrieve image upload from form into PDF
Error storing data
How to generate unique ID using Textfield?
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print