3

In this situation I would like to have a field for 'LIBOR.' I would like to be able to update this field once/wk, but ideally, I would like to be able to update it once, in one location, instead of having to do a mass update to every record. Does any functionality like this exist? Thanks!

3
  • Or you can create custom setting for that one field with name value pair, use that in a formula on required to.
    – user611
    Commented Sep 26, 2012 at 5:03
  • Do you mean on different objects? Something like a global variable?
    – Saariko
    Commented Sep 27, 2012 at 15:23
  • @Saariko, yes, the question was answered below. Commented Sep 27, 2012 at 18:32

2 Answers 2

9

I suggest creating a Custom Label LIBOR with the value you intend to have in this field, and then adding a formula field on your object with a value of VALUE($Label.LIBOR). This will allow you to update the value of the custom label and have the change reflected instantly across all of your records.

EDIT: You also need to use the VALUE() function so that you get the correct data type (number, not text), because label values are always text. It should look like this:

VALUE($Label.LIBOR)
1
  • 4
    Once edit I would suggest to your answer is that you also need to use the VALUE() function so that you get the correct data type (number, not text), because label values are always text. It should look like this: VALUE($Label.LIBOR) Thanks! Commented Sep 25, 2012 at 16:15
0

It seems like a data modelling question to me. The variable value should be broken into a lookup table which the other records look up to.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .