Need Help : Workflow triggers do not fire when creating/updating items via a Subtable (Association field) in a Form

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:

  1. Collections: Quotes (Parent) and Quote Items (Child).
  2. Workflow: I created a workflow on the Quote Items collection.
  • Trigger: On Create / On Update.
  • Action: Query the Product Master and update the Unit Price field in the current Quote Item record.

The Problem:

  • :white_check_mark: Works: When I create or update a record directly in the Quote Items collection table, the workflow runs perfectly and copies the price.
  • :x: 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 α

Please refer to:

Thank you for reply.

I understood.

“Triggering by Bulk Data Operations is Not Currently Supported” So, I can’t achieve my goal.

It doesn’t necessarily have to be done via a Workflow.

Is there a way to automatically populate the Unit Price field from the Product Master immediately when a product is selected in the subtable row? I am looking for a feature that fetches the price value and sets it into the field (like an auto-fill or copy action) upon selection.

The price field is set to a default value, which is the current object/product/price.

I might have misunderstood, but does “Default value” work when the field value is changed? Here is my desired workflow:

  1. I add a new row in the subtable.
  2. I select a Product from the dropdown.
  3. The Unit Price field automatically fills with that product’s price immediately.
  4. I can then edit the price if needed.

Does the “Default value” setting support this “On Change” behavior?

I solved it!

I use Field Linkage Rules.

Thank you.

https://docs.nocobase.com/handbook/ui/blocks/block-settings/field-linkage-rule