Genx Posted June 20, 2006 Share Posted June 20, 2006 I have a variety of fields that rely on one value list. To be valid, the contents of that field have to be a member of the value list (I don't want to use the filemaker validation because it's annoying). Anyway, i was thinking of using If(Substitute (ValueListItems( "filename.fp7" ; "valuelist" ) ; FieldValue ; "" ) ≠ ValueListItems ; 1 ; 0 ) But the problem is it picks up incomplete values on the value list as valid. Is there an easier way of doing this? Cheers, ~Genx Link to comment Share on other sites More sharing options...
IdealData Posted June 20, 2006 Share Posted June 20, 2006 Value list entries are all terminated with a LF/CR pair (except the last one). Typically I add a dummy paragraph marker to the end of the value list, then I always compare with "String" & "paragraph marker", but I use the POSITION function - so any value >0 must be a valid entry. Link to comment Share on other sites More sharing options...
Genx Posted June 20, 2006 Author Share Posted June 20, 2006 Hmmm, thanks mate. ~Genx Link to comment Share on other sites More sharing options...
Genx Posted June 20, 2006 Author Share Posted June 20, 2006 Come to think of it though, wouldnt "alue" return true if "value" was a value in the value list? Link to comment Share on other sites More sharing options...
comment Posted June 20, 2006 Share Posted June 20, 2006 If you want to use Position(), you must check for: Position ( ¶ & list & ¶ ; ¶ & item & ¶ ; 1 ; 1 ) I prefer: not IsEmpty ( FilterValues ( item ; list ) ) Link to comment Share on other sites More sharing options...
Genx Posted June 20, 2006 Author Share Posted June 20, 2006 That works perfectly, thanks comment. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6492 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now