How do I make a conditional calculation to search a record field for a specific string?
I have two fields:
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?