AnsweredAssumed Answered

Scripting Question

Question asked by donjuan1498 on Sep 17, 2013
Latest reply on Sep 17, 2013 by philmodjunk

Title

Scripting Question

Post

     I am fairly new to filemaker and i have a script that is giving me fits. I think it is simple for an advanced user so I apologize ahead of time if it seems minuscule. 

     I am trying to have a script that searches2 fields and then changes the value of another field. The problem I am having is that when it searches my second field it is looking for the exact words. 

     Bascially where is says Product I need it to search every thing in the product field for ADDVANT which is the first set of charectors in some of the fields the complete field content would look like this. 

     Here is my if statement.

      

     If (Company = "North American Life"  and  Product  ≠ "ADDVANT"; Premium*Split;
      
     Here some of the field content. 
      

          ADDVANT-20-NT2 

          ADDVANT-100-PT2

          ADDVANT 20 PT2

          ADDVANT 20 P2

      
      
     Thank you ahead of time for any help you can provide. 

      

Outcomes