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. [Proj...
Forum Discussion
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
------------------------------
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/
------------------------------
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
- 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
------------------------------- Sorry - I copied from your original message and didn't even notice the switch around.
Yes, your query should be- contains [Value]
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------- So yeah - what I am getting at is, is there a way in pipelines to have [Value] is contained in
- ?
------------------------------
Mike Tamoush
------------------------------