Add "Contains" condition into workflow.....

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • chrisjiang
    Member
    • Dec 2018
    • 88

    Add "Contains" condition into workflow.....

    Hi developers,

    I am using Advanced Pack and would like suggest it adds "Contains" condition as in Report filter function..

    thanks.
  • yuri
    Member
    • Mar 2014
    • 8624

    #2
    Hi,

    You can use formula as an alternative.

    string\contains(yourTextField, 'string')
    If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

    Comment

    • chrisjiang
      Member
      • Dec 2018
      • 88

      #3
      Originally posted by yurikuzn
      Hi,

      You can use formula as an alternative.

      string\contains(yourTextField, 'string')
      Thanks yuri for your attention!

      I have tried the the attached screenshot or the following:

      streamCount = ifThen(string\contains(Post, '#Followup#'), streamCount+1)

      but neither works....

      Can you let me know anything I did wrong?

      Thanks.

      Chris

      Comment

      • yuri
        Member
        • Mar 2014
        • 8624

        #4
        EspoCRM never uses upper case for a first letter in field, attribute, link names. https://github.com/espocrm/documenta...tion-arguments

        You should not use label values in formula. System name is 'post', not 'Post'.
        If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

        Comment

        • chrisjiang
          Member
          • Dec 2018
          • 88

          #5
          Originally posted by yurikuzn
          EspoCRM never uses upper case for a first letter in field, attribute, link names. https://github.com/espocrm/documenta...tion-arguments

          You should not use label values in formula. System name is 'post', not 'Post'.
          I changed to lower case but still bad luck.....

          I tried two ways as in attached screenshot but both failed....

          Please help!

          Comment

          • yuri
            Member
            • Mar 2014
            • 8624

            #6
            https://github.com/espocrm/documenta...ula-conditions
            "There should not be any ; delimiter used in formula code when it determines a condition."

            You need to use && operator instead of semicolon.
            If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

            Comment

            • chrisjiang
              Member
              • Dec 2018
              • 88

              #7
              Originally posted by yurikuzn
              https://github.com/espocrm/documenta...ula-conditions
              "There should not be any ; delimiter used in formula code when it determines a condition."

              You need to use && operator instead of semicolon.
              It works very well now. Thanks you so much for your patience!

              With best regards.

              Comment

              Working...