1 Reply Latest reply on Sep 18, 2013 7:00 AM by philmodjunk

    How do I make a conditional calculation to search a record field for a specific string?

    AaronBrimacombe

      Title

      How do I make a conditional calculation to search a record field for a specific string?

      Post

            

           I have two fields: Description and Type.

           When the Description field contains the string "Beneficiary" amongst other words, I would like the field Type to automatically set as "Beneficiary"

           So the calculation I have come up with is:

      If ( Descrizione= "BENEFICIARI" ; Type = "Beneficiary") 
      

           The problem is, Filemaker only searches the entire text and not just an individual string, is there any function I can use to make this happen?