AnsweredAssumed Answered

Separator counts as member of value list

Question asked by LaRettaK on Sep 9, 2015
Latest reply on Sep 16, 2015 by TSGal

FMPA 14.0v2, Mavericks


If one sets up a field to validate as 'member of value list'

AND

If that value list is custom and it includes a dash separator

THEN

... typing a dash in the field will PASS validation.


The dashes also appear when calculation is:

ValueListItems ( Get ( FileName ) ; "customList" ) 


... and are counted with ValueCount() of the value list.


This means that tests we use to see if ALL custom values are checked in a field (bringing a checklist to completion) fails, if there are separators:

 

Let (

values = ValueListItems ( Get ( FileName ) ; "customList" ) ;

ValueCount ( FilterValues ( values ; field ) ) = ValueCount ( values )

)

 

And finally, scripts which use loops and first counts the number of values in these custom value lists, will loop a higher count than intended which could bring dire consequences.  This bug also exists in version 11 so it has been around for quite some time.

Attachments

Outcomes