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.