Just Brainstorming
IF this table is not very big , you might be able to use formula query out all instance of 2525/test,Fake Part along with their Record ID in a field , then maybe have a criteria to get a checkbox in place for only 1of them (earliest [Record ID#]) , another for sum.
Then a pipeline can trigger which deletes all the non checkboxes items and creates a record
| part |
[Record ID#] |
Sum |
Formula Query |
Chebox |
| 2525/test,Fake |
3 |
10 |
3,5,6 |
Yes |
| 2525/test,Fake |
5 |
0 |
|
False |
| 2525/test,Fake |
6 |
0 |
|
False |
------------------------------
Prashant Maheshwari
------------------------------
