Are they making these edits via a regular Quick Base form? Sounds like form rules might be handy here
Do you need to just alert them? Or do you need to stop them editing QTY at all. An alternative approach might be that when your 'Flagged Item record' checkbox is checked to add a form rule that locks down / hides the QTY field and displays text on the page that directs them per your comment above.
To your specific point - form rules can be created such that if the QTY is edited and this is a flagged record - and it differs from the qty of the components - the form rule can display a message that QTY is different - and they need to update the components too.
Chayce Duncan | Director of Strategic Solutions
(720) 739-1406 |
chayceduncan@quandarycg.com Quandary Knowledge Base
