Pipeline - Delete Record
Hi, I have a Couple of Tables, say Table A , Table B and Table C. Table C is a Helper table with records of sequential numbers I am using as a loop counter. e.g. QTY is 5 so 5 related Part Recor...
Forum Discussion
I've still been working on this issue, and trying a different approach.
have created a Quickbase API - Make request that can retrieve the data I need.
https://api.quickbase.com/v1/reports/1/run?tableId=xxxxx&top={{a.abs_difference}}
Is it possible to do a second Make Request to PurgeRecords from the result of the previous query? I can't figure out the correct syntax.
http://yyyy.quickbase.com/db/xxxx?a=API_PurgeRecords&query={8.EX.????}
------------------------------
Grant
------------------------------
Instead of searching all records, what about a trigger on the quantity field in Table A. Then you can use $prev to get the previous value and only continue if it decreased.
A) Trigger on Record Update, quantity field change on Table A
B) If a.quantity > a.$prev.quantity
Stop
C) Search Table B matching appropriate Table A record, limit= {{ a.$prev.quantity - a.quantity }}
For Each C
D) Delete record
I think you were on the right track at the beginning, but you didn't have a loop around the Delete record step.
Hope that helps!
------------------------------
Doug Henning
------------------------------
