Find your content:

Search form

You are here

Can I create a static (but update-able) field that I can update in one place and have reflected on all records?


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!

Attribution to: jackerman09

Possible Suggestion/Solution #1

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:


Attribution to: JCD

Possible Suggestion/Solution #2

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.

Attribution to: techtrekker
This content is remixed from stackoverflow or stackexchange. Please visit

My Block Status

My Block Content