Thu, 24 Sep 2026
Login

How to add filtering to spreadsheet form

Confluence User - 05 Aug, 2018

How to add filtering to spreadsheet form (in one table) ?

For example i would like to filter it by date (only selected date would be appeared for editing)

 

Thank you

 

forms;userviews

2

Confluence User •
06 Aug, 2018 •
confluenceUser •
•
confluenceUser •

Hi, you can try assigning a custom load binder to the spreadsheet element. Then you can do your required filtering when loading the data. Found an example of a custom load binder at Load & Store Form Grid Data Using Bean Shell Form Binder

Confluence User •
09 Aug, 2018 •
confluenceUser •
•
confluenceUser •

Found similar case at https://dev.joget.org/community/display/KBv6/Load+Grid+Data+with+Custom+Sorting+and+Filtering but unfortunately it needs parent-child tables with foreign key. i need to filter my spreadsheet form since it's no fk (in one table).

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
i am building an app, and for some reason i am not able to open it anymore. All apps --> my app --> system error
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print