Update fields based on another field using a formula

Who would benefit?

Data management

What impact would it make?

Automation of data and less error risk and more consistency

How should it work?

As someone who inputs data, I would like the PIM to allow me to have fields that update their value based on another field using a formula so that data manipulations or conversions are consistent throughout the catalogue.

For example, we have temperature, which is in both Celsius and Fahrenheit as we sell internationally. Ideally we only need to update the Celsius field and then the PIM can convert that into Fahrenheit. It would also mean that if the fahrenheit is missed out or incorrectly calculated, the PIM would negate the error.

Others might be concatenating a prefix or putting in a constant if another field has a value added to it.

Essentially it would be good for it to use the out of box formulas that syndication functions tab has plus calculations, but with a "IF" pretext to it.

Example:

IF

[Minimum temperature celsius] is updated then

[Minimum temperature fahrenheit] = ([Minimum temperature celsius]*9)/5 + 32

It would be a good start to have it work on update but to reach its full potential, it would be good for it to update based on context/criteria

Example:

IF [Obsolete] updated to = "True" then

[Approved for website] = "False"

The calculation attribute would only need to update if the source attribute is updated.

Why is it needed?

Allows for in system automation rather than relying on excel to do this.

Can then consistently handle data and set attributes as read only so they will only update based on another attribute or the conditions of another attribute.