checking a portal for an occurrence of a few strings..

[Steven Cappiello]

I'm trying to check if a filename in a portal of attachments contains one of a few words, and then have it auto-enter "yes" into a text field if so... it's entering nothing into the text field even when the strings I'm searching for exist in the related value list.. what am I doing wrong ?

Let (



[values = ValueListItems(Get(FileName); "attachments")]; 



Case(



(



 (PatternCount( values; "CV") >0)



or 



(PatternCount (values ; "resume") >0)



or  (PatternCount(values ; "app") >0)



  );  "yes"; "") )

thanks :

[Fitch]

For one thing, you don't need the square brackets in your Let function when you only have one expression, but I'm not sure that would break the calc. Is the related table in the same file? If not, then Get(FileName) would fail. Is "attachments" the correct v/l name?

Since you have FileMaker 8 Advanced, use the Data Viewer to evaluate each piece of your calc and you should find the answer easily.

[comment]

You need to use an UNSTORED calculation field - if you want it to update when related records are modified. Even so, with the calculation referencing a value list, it might not refresh until you click into the field or do a manual Refresh Window.

[Steven Cappiello]

Thanks comment.. that was the problem. thanks for the help Fitch