Hi there,
We made a custom module called “Inventory” to track some assets. I was hoping to have a simple Workflow that updates the “Total Value” field based on two other fields within the module (“Quantity” and “Value (per item)”)
Originally, this topic was intended to be a question about if this was possible and if so then what would the equation be. I figured it out while writing, but wanted to create the topic anyway in case people have this question in the future. So if that’s you, please reply letting you know this helped!
Steps to create:
New Workflow
Select Module
Added condition “Date Modified” “Equal to” “Any Change”
Actions:
Select Action: Calculated Field
Parameters: Add “Quantity” and “Value (per item)”
This gives each parameter a variable {P0} and {P1}
Formulas:
Selected “Total Value” field. Clicked “Add formula”
Formula used: {multiply({P0};{P1})}
Where I messed up was not putting the parameters in {} brackets. This is probably basic to all of you, but I"m hoping it helps anyone else who is struggling with parameters and calculated fields.