2 Replies Latest reply on Apr 30, 2012 9:42 AM by digital-carpentry

    Help with basic calculation field

    raykennedy

      I know a couple other programming languages and still trying to grasp filemaker. This is probably a simple question but I haven't had much luck with it.

       

      Here is what I am trying to do. I DB I created and I added a field specifically as a calculation for the purpose of creating another way to flag of categorize the data for static searchs at a later date. When I import data into my table there is content that is pulled into decription. I have a separate calculation field that searches for certain keywords in the description field and if it finds them than it puts a certain flag or keyword in the calculation field.

       

      Here is how I envision the code:

       

      If(description LIKE %ABC%; "123", 0);

       

      So basically if the field description has the content "ABC" than it will input "123" in the new calculation field.

       

      I hope that makes sense. Any ideas on how to approach this?