Hello all,

I have the scenario where I'd like to have a constant value across all records in an object while being able to update that value frequently.

For instance, Let's say I have 3 records in Object A with a field called "value".

Record 1) Value:0;

Record 2) Value:5;

Record 3) Value:50;

Now, let's say I want a constant that scales all values in, say, a formula field, such that the values are from 0-100. So, constant = 2.0

Record 1) Scaled Value:0;

Record 2) Scaled Value:10;

Record 3) Scaled Value:100;

Now, imagine i added a fourth record

Record 4) Value:100;

And now the constant = 1.0;

Record 1) Scaled Value:0;

Record 2) Scaled Value:5;

Record 3) Scaled Value:50;

Record 3) Scaled Value:100;

What's the smoothest way to accomplish this? I thought I might be able to change a formula definition within an Apex trigger. Thinking that's not likely. Is there a way to define a field with a constant value. Again, I'd have to be able to change via an Apex trigger or scheduled code.

The only solution I have so far, is to just have lookup fields to another object (object b) that contains all the constants. Change the values in this second object's records and repeatedly check every record of object A  to ensure that it's always pointing to the right record in Object b. Of course, this seems to be quite awkward.

Are there any other possibilities that I'm missing?