AnsweredAssumed Answered

Field Contains

Question asked by kennyferg on Feb 6, 2010
Latest reply on Feb 6, 2010 by kennyferg

Title

Field Contains

Post

Using FM10 on Mac - Novicee user 

 

Sorry in advance if this has been asked before.

 

I want to check the contents of the field 'PublicationID'. If the word "Year" is contained anywhere within PublicationID I want the values in the field 'Total' to display the figure 600. If the PublicationID contains the word "Month" the other field should display 50.

 

I can take care of the field values easily enough but I am struggling to find whether or not the  field PublicationID contains the word "Year" or "Month"

 

On another program I use, I can put the statement "If PublicationID contains "Year" ..." but I can't seem to find an equivalent in FM10 

 

Thanks in advance 

Outcomes