AnsweredAssumed Answered

2 field valuelist not showing expected results

Question asked by dmorgan on Sep 18, 2017
Latest reply on Sep 19, 2017 by dmorgan

I'm trying to run an If( PatternCount ( ValueListItems ( Get ( FileName ) ; "Valuelist" ) ; Get ( AccountName )) )

 

The value list has 2 fields from the same table and TO. Fields are a checkbox with 1 or null, and a text field matching the users accountname. Tried 1st field checkbox, 2nd field accountname and only show 2nd field list, this gives me a list with a single value of 1 even if there are multiple records with show 2nd, without it's a list of 1 1...

I would have expected text1 and text2 or even 1 text1 1text2 ... which would be workable.

Reversed it gives me 1st value from the text field with a value in the checkbox field and with show both fields makes no difference.

 

I just need a list with the text field values if the checkbox is checked, I believe I can do it with an additional calculation field but that adds an extra field and I'm not sure why this doesn't work.

Outcomes