question Autopopulate Product field from demand table to Project table in Developer forum

Autopopulate Product field from demand table to Project table

Community Alums — Wed, 11 Dec 2024 17:22:48 GMT

Hi,
I have to auto populate product field value from 'demand' table to product field in 'Project' table.
I had configure business rule for that requirement, below are the screenshot.

and also it will trigger when I create New project record from 'New' UI button which is present in related list of Demand table.

But when I click on 'Edit' button and select any existing record then that business rule will not trigger and the value of product field will not populate.

Thank You.

Re: Autopopulate Product field from demand table to Project table

Brad Bowman — Wed, 11 Dec 2024 17:31:09 GMT

Clicking the Edit button and selecting a Project, updates the Project record by populating the Demand field, but does not update the Demand record, so you will need another Business Rule that runs on the project table before insert/update when the Demand field is not empty. The script will be easier as you can just use:

(function executeRule(current, previous /*null when async*/) { current.product = current.demand.product; })(current, previous);

Re: Autopopulate Product field from demand table to Project table

Community Alums — Wed, 11 Dec 2024 17:55:19 GMT

Thanks @Brad Bowman .

Re: Autopopulate Product field from demand table to Project table

Community Alums — Mon, 16 Dec 2024 12:51:33 GMT

Hi @Brad Bowman

When I update or change the demand product field value, It will not updated in product field which is present in project table.

Thank you

Re: Autopopulate Product field from demand table to Project table

Brad Bowman — Mon, 16 Dec 2024 13:46:04 GMT

It looks like your first Business Rule on the Demand table should cover this test case. Is that Business Rule still active and configured as it was in the screenshots?

Re: Autopopulate Product field from demand table to Project table

Community Alums — Mon, 16 Dec 2024 18:58:13 GMT

It was resolved that issue

Re: Autopopulate Product field from demand table to Project table

Community Alums — Tue, 17 Dec 2024 12:49:58 GMT

Hi,

I have one more query.

If the user remove that product field from demand table, so it will not remove from related product field which is present on Project table.

How to fix above issue

Thank you

Re: Autopopulate Product field from demand table to Project table

Brad Bowman — Tue, 17 Dec 2024 13:13:58 GMT

Remove the Filter Condition on the Demand Business Rule:

Product(product) is not empty

So that the script will run every time the demand is updated, or add some different Filter Conditions if you don't want it to.