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
------------------------------
Original Message:
Sent: 10-12-2020 15:29
From: Blake Harrison
Subject: Pipelines - 'is contained within' condition
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/
Original Message:
Sent: 10-12-2020 13:20
From: Mike Tamoush
Subject: Pipelines - 'is contained within' condition
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
Original Message:
Sent: 10-12-2020 13:05
From: Blake Harrison
Subject: Pipelines - 'is contained within' condition
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/
Original Message:
Sent: 10-12-2020 12:49
From: Mike Tamoush
Subject: 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
------------------------------