I am working on a customization for Customer Shipment Entry where a user enters in PCID value that is an external value and then swap it out for the real PCID value.
I have a ColumnChanging event on ShipHead.PCID with a condition to validate the external PCID, then a BAQ REST call to grab the real PCID value from a lookup table and lastly a Row Update to update the ShipHead.PCID. In the logs everything is executing correctly until the Row Update. Once it sets the PCID, the screen freezes and a Track in the Network tab is showing the error “Daily quota exceeded”.
Is that the correct path to swap out values during ColumnChanging? Or will that cause issues with other stuff?
I think the issue is I’m trying to update the same field I’m triggering the Column Changing event on with ShipHead.PCID. When I add Event Disable/Enable blocks around the Row-Update then it moves forward, except it still uses the original changing value in %value% for validations which fails.
Next issue is how to reset %value% to a new value.
What I ended up doing was I created a temp variable in TransView that I populated on load from ShipHead.PCID, then when that variable was updated, I swapped it out and updated ShipHead.PCID. All updates wrapped in the Event Column Disable/Enable to prevent loops. Seems to work fine so far.
