I have two user filters in record, is to possible to hide and show second user filter based on value selected in 1st user filter.
For example in the below image I have two filters named 1) FEEDBACK and 2) APPOINTMENT DATE,
FEEDBACK filter had 2 values Good and Neutral, Is it possible to display the Second filter(APPOINTMENT DATE) only when we choose Good in the FEEDBACK filter?
Discussion posts and replies are publicly visible
AFAIK, Subject to correction I don't think show you can hide second filter based on the result of the first filter. for record type. you need built using dropdowns outside the grid.
AFAIK Appian's built-in record list functionality doesn't offer an option to directly show or hide filters based on selections from other filters.Instead of relying on the default record list, create a custom interface with a grid built using the a!gridField function.This grid will display the records based on your logic.https://docs.appian.com/suite/help/24.1/fnc_system_recorddata.html.https://docs.appian.com/suite/help/24.1/fnc_system_queryrecordtype.html
Hello Devarneni Shiva Prasad Rao
No, You cannot have this functionality in record filters. The only work around is to have your filters built using dropdowns outside the grid.
Shubham Aware said:reate a custom interface with a grid built using the a!gridField function.This grid will display the records based on your logic.
I guess the problem is not about the data. Its about the filters.
If you use a!queryRecordType() as data in gridField() you can show and hide filters on value selection.
Devarneni Shiva Prasad Rao : As per my understanding you cannot have this functionality in record filters. You can use interface rules and expressions to conditionally show or hide the second user filter based on the value selected in the first user filter.
for example :
local!showAppointmentDate: IF(local!feedbackFilter= "Good", true, false)
Not sure how you would save the value to local variable from the first record user filter?
manishs0028 said:conditionally show or hide the second user filter based on the value selected in the first user filter
Konduru Chaitanya : Let me correct my sentence here:
As per my understanding you cannot have this functionality in record filters. You can use interface rules and expressions to conditionally show or hide the second filter based on the value selected in the first filter.
local!showAppointmentDate: IF(local!feedbackFilter= "Good",true,false)
All I am saying is instead of going with record userfilter approach , We can go with interface rule/expression/local variable approach