AnsweredAssumed Answered

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

Question asked by AaronBrimacombe on Sep 18, 2013
Latest reply on Sep 18, 2013 by philmodjunk

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?

Outcomes