Discussions

 View Only
  • 1.  Pipelines - 'is contained within' condition

    Posted 10-12-2020 12:50
    Is there any trick or workaround to use a condition in pipelines that is essentially, 'is contained in' (verses, 'contains')?

    Use Case:

    I have a table with a list field of project numbers. [Project Numbers List].

    I want pipelines to search all records in a table and return: Records where [Project Number] is contained in [Project Numbers List]. The list is in an unrelated table, so I can't simply create a formula checkbox or anything.

    It's quite simple to go backwards, if I needed to search where [Project Numbers List] contains [Project Number]. Any tricks for my use case?

    ------------------------------
    Mike Tamoush
    ------------------------------


  • 2.  RE: Pipelines - 'is contained within' condition

    Posted 10-12-2020 13:06
    I don't know that I understand the difference.

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------



  • 3.  RE: Pipelines - 'is contained within' condition

    Posted 10-12-2020 13:20

    In Pipelines, when you search a table, the first part of the condition is always a field in the table you are searching. So for in my case, my condition starts with:

    [Project Number]....

    Then I can choose "Equals", "Is Set", "Contains", etc....afterwards I can drag and drop the field from my trigger table into the condition.

    So, in my use case I can say: [Project Number] contains {{a.Project_Numbers_List}}.

    However, that isn't correct. I need: [Project Number] is contained in {{a.Project_Numbers_List}}.



    ------------------------------
    Mike Tamoush
    ------------------------------



  • 4.  RE: Pipelines - 'is contained within' condition

    Posted 10-12-2020 15:30
    Is there a reason you're not wanting to search the other way around? "[Project Number] contains {{a.Project_Numbers_List}}" like you mentioned originally?

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------



  • 5.  RE: Pipelines - 'is contained within' condition

    Posted 10-12-2020 18:09
    Unless I am misunderstanding something, because it simply wont yield any results.

    If my Project Number = ABC, and the Project Number List is ABC;DEF;GHI

    then: [ABC] contains [ABC;DEF;GHI]?  Will say No.
    But [ABC;DEF;GHI] contains [ABC]? That will yield yes.

    Correct? The smaller singular item does not contain the large list...

    ------------------------------
    Mike Tamoush
    ------------------------------



  • 6.  RE: Pipelines - 'is contained within' condition

    Posted 10-12-2020 20:41
    Sorry - I copied from your original message and didn't even notice the switch around. 

    Yes, your query should be [List] contains [Value]

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------



  • 7.  RE: Pipelines - 'is contained within' condition

    Posted 10-13-2020 09:13
    So yeah - what I am getting at is, is there a way in pipelines to have [Value] is contained in [List]?

    ------------------------------
    Mike Tamoush
    ------------------------------