Forum Discussion
PrashantMaheshw
2 years agoQrew Captain
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
------------------------------