2 Replies Latest reply: Aug 29, 2018 5:02 AM by Shraddha Gajare RSS

    Flag creation help

    Mahitha M

      Hi Experts,


      Can any one please help me on below requirement.


      I have two tables Table 1 contains TYPE field and  Table 2 contains Comment field. These two tables are linked in on Key field.


      In the UI based on these two fields I have to  create a flag based on below conditions.


      If Comment field =Yes* then its 'Yes'

      if TYPE field = TERMINAL then its 'Yes' Flag else No Flag


      I have tried like below

      if (Match(TYPE ,'TERMINAL' ) or wildmatch(Comment,'Yes* '),'Yes','No')  as Flag


      but here when I have clicked on Yes only TYPE= TERMINAL is selected the second condition Comment='Yes*records are not selected. Please help me on this.


      Thanks in advance.

        • Re: Flag creation help
          David Štorek


          are you using this if condition in app or in script (just asking because of "as Flag" but generaly doesnt matter)?


          I think your expression works well. As you have it, it should work as following. 'Yes' will be displayed by all rows with Type='Terminal' and also by all rows with Comment=Yes*. Which implies that allso rows with different comments could be selected if type=terminal and vice versa. Se attached app for demonstration.


          You can allso atteched your app with sample to check if it is correct

          • Re: Flag creation help
            Shraddha Gajare

            Try to create these condition in script