Hello,
I am building a Quoting system and facing an issue with Workflows not triggering for items added through a Subtable.
My Goal: I want to copy the Unit Price from the Product Master to the Quote Items when a product is selected.
- I need to copy the actual value (snapshot), not just look it up, so that the price on the Quote Item can be manually adjusted later without affecting the Master.
Current Setup:
- Collections:
Quotes(Parent) andQuote Items(Child). - Workflow: I created a workflow on the
Quote Itemscollection.
- Trigger: On Create / On Update.
- Action: Query the Product Master and update the
Unit Pricefield in the currentQuote Itemrecord.
The Problem:
Works: When I create or update a record directly in the Quote Itemscollection table, the workflow runs perfectly and copies the price.
Fails: When I open the Quote (Parent) form and add/update items inside the Subtable (Quote Items), the workflow does not seem to trigger, and the price remains empty.
Question: Is there a specific way to trigger workflows for child records when they are created/updated via a Parent Form’s subtable? Or should I approach this logic differently (e.g., using a workflow on the Parent collection)?
Any advice would be appreciated. Thanks!
NocoBase 2.0 α
