Skip to main content
omkaro0002
August 27, 2024
Question

User filter based on current record values

  • August 27, 2024
  • 4 replies
  • 0 views

Hello community,

There is a scenerio where I just want to add a user filter to popup only with the options that are mapped to a record.

e.g. there are 10 reference records used in filter and mapping is like::

Record A - 1,2,3,4

Record B - 4,5,6

Record C - 6,8,,4,3,9

Is there any way to just popup mapped referenced values to the filters for selected records.

4 replies

richardm900458
August 27, 2024

Hello omkar,

i have a hard time to follow you with this part of your Explanation

popup only with the options that are mapped to a record.

Can you elaborate that a bit more?
Aa far as i understand you have two records linked?
You want to use the "user filters" just for the selection of the connected record?

omkaro0002
August 27, 2024

Hi [mention:c03f69cc9b264af29d5e31ca80c64eff:e9ed411860ed4f2ba0265705b8793d05] ,

Scenario is like (1:M relationship) e.g.

Record A  => Benefits (A,B,C)

Record B => Benefits (C, D, E)

Record C  => Benefits (E,B,A)

So, when viewing Record A, in Benefit filter the values should populate the values mapped to particular records.
Although, this is something that is not supported in appian filters, So, I have implemented in a different way.

Thanks!!

stefanhelzle0001
August 27, 2024

I think this is not something Appian supports OOTB, but you can easily build that. Do you have any specific question?

omkaro0002
August 27, 2024

No, [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] 
That was the requirement, but yes it can be done manually. Thanks!!