Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
5 years ago

Pipelines - 'is contained within' condition

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
------------------------------
Pipelines
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    5 years ago
    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/
    ------------------------------
    • MichaelTamoush's avatar
      MichaelTamoush
      Qrew Captain
      5 years ago

      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
      ------------------------------
      • BlakeHarrison's avatar
        BlakeHarrison
        Qrew Captain
        5 years ago
        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/
        ------------------------------