Skip to main content
Question

Grid edit in pipeline

  • November 23, 2022
  • 0 replies
  • 58 views

Hello,

I have a table Inventory orders in which whenever a checkbox is checked the Quantity field in another table Parts should get reduced by 1. I have created a pipeline for this.
The issue here is, when the records are grid edited in inventory orders, and if 2 records having same Part ID in inventory order are edited at a time, ideally the number in Quantity of Part table should get reduced by 2, but it is reducing by 1. The cause is both the triggers are at the same time and the pipeline triggers at a time for both the records. 
But the ask is, it should trigger one-by-one and the number should be reduced by 2.


Thank you!

------------------------------
Aishwarya Jinde
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
You might consider using a relationship instead, to sum the #  of parts used. ​​

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------