Calculated Fields Dependent of each other

(0) Share

Report

Posted on by Lund

Hi there,

I have a Product Entity form that contains plenty of price information, and therefor a lot of calculated fields.

When you set up a new product as it is right now, you need to save the form multiple times since the calculated fields are dependent of each other. So for instance you start filling in the vendor price, purchase quantities and selling quantities - press save and the adjusted vendor price will populate. Then you need to press save again since the landing factor and landed cost only will calculate if the adjusted vendor price is populated.

How do I create a user friendly experience where you only need to fill in the non-calculated fields, and press save only one time?

If the solution is workflows, how do I set them up?

Regards

Olivia

*This post is locked for comments

All responses (1)

Answers (1)

Verified answer

Drew Poggemann 9,079 on at

Like (1)

Report

RE: Calculated Fields Dependent of each other

Hi Lund,

I tested this out in Update 1 by creating the following:

1. Day Number Field (Numeric)

2. Calc1 - Calculated as "Day Number Field" + 1

3. Calc2 - Calculated as CONCAT(Calc1, " Test")

When I put this on the form and saved it saved correctly with a single save and did not force multiple saves.

You could put as a workflow to update the fields and if you setup as a realtime workflow then it would update all the fields after a single save. In the workflow you can utilize the updated value from the prior steps.

Hope this helps. If you need more details / clarification, let me know.

Thanks,