2 Replies Latest reply on Aug 12, 2015 2:07 PM by philmodjunk

    If certain series of text is contained than do (blah)

    JimZ

      Title

      If certain series of text is contained than do (blah)

      Post

      Hello,

      Thank you in advance for your time and help. I am trying to find out if it is possible to have a filemaker script search for a series of characters in a field and if it is there then perform an action. This is similar to excel text function.

      In fileMaker: If(table:field1 = "over", table:field2 = "Done") BUT I want it so if the field lets say contains "overdue: 245 days" it will also do this( the number of days changes every day).

       

      In excel one could put a simple asterisk (*) and that would denote text could continue from there. such as a Sumif(A1 ="Over*",,) and it would sum only the records that contained "Over" in the beginning of the word.

       

      Additional info:

      I have a field 1 that states if an item is checked out, available, or overdue (this many days). I want to show text in another field  2 if field 1 says "checked out" or "overdue: X days".

      Any help is greatly appreciated