custom filter on the list

Avatar

Avatar
Validate 1
Level 1
Ramaswami
Level 1

Likes

0 likes

Total Posts

100 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Applaud 5
View profile

Avatar
Validate 1
Level 1
Ramaswami
Level 1

Likes

0 likes

Total Posts

100 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Applaud 5
View profile
Ramaswami
Level 1

22-07-2020

Hi Team, 

 

i have a list which is going to update daily through a workflow. Now i want to add a custom filter on this list such as a user can enter a month and year to filter the respondents based on month and year. 

 

This is my list : 

 

Ramaswami_0-1595415641150.png

 

So i want to add a filter on the "date" column so based on month and year of that date we need to show the results in the list. 

 

For example : Like in the screenshot below there should be a month drop down and year input box where a user can enter and based on the month and year of the date column we need to filter the results of list. 

 

Ramaswami_1-1595415755929.png

 

I have clicked advanced filter on the list and this is the query i am taking : 

 

Ramaswami_2-1595416040677.png

 

i have clicked on save button on the right and it gave me below : 

 

Ramaswami_4-1595416254399.png

 

i clicked on form : It seems the code here should be written in xml or html so what code i need to write here for displaying month field with month dropdown and year feild input box. 

 

Ramaswami_5-1595416290487.png

 

When i click on preview i am getting some error : 

 

Ramaswami_6-1595416384073.png

 

Can anyone help on this. 

 

 

Accepted Solutions (0)

Answers (2)

Answers (2)

Avatar

Avatar
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

157 likes

Total Posts

925 posts

Correct reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile

Avatar
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

157 likes

Total Posts

925 posts

Correct reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile
Sukrity_Wadhwa
Employee

28-07-2020

Hi @Ramaswami , 
Were you able to solve this?

Avatar

Avatar
Boost 250
MVP
DavidKangni
MVP

Likes

258 likes

Total Posts

372 posts

Correct reply

152 solutions
Top badges earned
Boost 250
Validate 1
Give Back 5
Give Back 3
Give Back 25
View profile

Avatar
Boost 250
MVP
DavidKangni
MVP

Likes

258 likes

Total Posts

372 posts

Correct reply

152 solutions
Top badges earned
Boost 250
Validate 1
Give Back 5
Give Back 3
Give Back 25
View profile
DavidKangni
MVP

22-07-2020

Hi,

 

First, your document type needs to be an existing schema in ACC. You will also need to update your form to support dynamic value

 

Custom filter

 

Thanks,

David