Thu, 24 Sep 2026
Login

how to group existing data and populate in spreadsheet by month?

Confluence User - 23 Sep, 2021

Hi how can i populate data to show all in spreadsheet based on month after select by project code, btw currently i'm using ajax subform to auto populate from drop down into spreadsheet




forms;datalists

1

Confluence User •
23 Sep, 2021 •
confluenceUser •
•
confluenceUser •

You can use a JDBC Form Binder with SQL to populate your Ajax Subform and use the special hash variable #requestParam.primaryKey# in your SQL to filter, for example:

select * from app_fd_subform where c_foreignkey = "#requestParam.primaryKey#"

where the value of #requestParam.primaryKey# is retrieved from the field property "Parent Field to keep Subform ID" in form builder (i.e. "projectcode"). There is a demo app you download to learn.

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