Thu, 24 Sep 2026
Login

Count number of records matching month on date picker change

Confluence User - 31 May, 2021

Hi 

I have a date picker named month, I'm trying to create custom html to count number of records the corresponds with the month selected in the date picker when its changed.

for example if I select May-2021 custom html calculates total records for May-2021 and displays in text field qty_month.

I prefer to have a label but i cant seems to get any custom html to update with text fields \with read only and display as label when read only option enabled

any help to get me started with JavaScript would be fantastic as I am not familiar with Bean Shell.

Thank you

javascript;customcode;html;forms;label;date;datepicker;datetime;customhtml

3

Confluence User •
01 Jun, 2021 •
confluenceUser •
•
confluenceUser •

Is all the data available in the form? (I presume you are in a form) Then you can just write some javascript to match the selected month with the data available.

If not, you can try to pass the selected month value to a AJAX Subform then in the target form, retrieve the number accordingly.

Confluence User •
02 Jun, 2021 •
confluenceUser •
•
confluenceUser •

Yes i am picking the date in a form, i prefer JavaScript as i have little experience and there is lot of help available on the web

I'm a complete noob to JoGet, any chance you can point me how to  with either JavaScript or AJAX SubForm?

Confluence User •
02 Jun, 2021 •
confluenceUser •
•
confluenceUser •

when Planned Month (month) is selected, Qty This Month (qty_Month) to show total count of records per selected month

This is Main Form

Thank you

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Process not starting with Form submission.
Form Submission Performance Issue
How to embedded autoplay video to Homepage ?
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?
Display video as the background in the header only on home page
npm install in joget
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print