Filter by date in UI

 
1
0
-1

how can I make a filter in UI that when u select a date it will show the information store in the date, like i fill a request form and i want find the form in UI by just entering the date that i fill the form, how can i make it

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      if i understood correctly you want to find the records based on the date in which the form was created? 

      In Joget, by default joget creates and stores 2 columns in database dateCreated, dateModified

      in your list you can use this column to create a filter. drag and drop the dateCreated column to the filter and set the type as date or date range. additionally u can also enable orderBy datecreated in the list settings to always show the most recent records on the top

      To elaborate a bit further:

      1. Open your list design in Joget.
      2. Drag the "dateCreated" column from available columns to the filter area.
      3. Set the filter type to "Date" or "Date Range" depending on your preference.
      4. Save your list design.


      For sorting:

      1. Go to the list settings.
      2. Find the "Order By" option.
      3. Select "dateCreated" and choose descending order to show newest first.


      This setup will allow users to easily filter records by the date they were created, making it simple to find forms filled on specific dates.


      Hope this helps.

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

        Use AJAX Subform and link the subform to the date which you can then use SQL Query to retrieve the record from the database to display.

          CommentAdd your comment...