You need to sign in to do that
Don't have an account?
Samyra Chrisp 18
Is there a way to build a formula that dynamically names fields?
I need to build a dynamic formula that will allow me to name the fields based on the current year.
For example, I've built out a formula
if(isNull(X2017_EBITDA__c)=False,"2017: $" & Text(X2017_Revenue__c) & " | $" & Text( X2017_EBITDA__c )&BR()&
"2016: $"&TEXT( X2016_Revenue__c )&" | $"&TEXT( X2016_EBITDA__c )&BR()&
"2015: $"&TEXT( X2015_Revenue__c )&" | $"&TEXT( X2015_EBITDA__c )
I'd like to fill in the year in the field names dynamically based on the current year. Is this possible?
For example, I've built out a formula
if(isNull(X2017_EBITDA__c)=False,"2017: $" & Text(X2017_Revenue__c) & " | $" & Text( X2017_EBITDA__c )&BR()&
"2016: $"&TEXT( X2016_Revenue__c )&" | $"&TEXT( X2016_EBITDA__c )&BR()&
"2015: $"&TEXT( X2015_Revenue__c )&" | $"&TEXT( X2015_EBITDA__c )
I'd like to fill in the year in the field names dynamically based on the current year. Is this possible?
You want to update the field names or value?
Field values can be updated by a Formula (formula field), a Trigger or a Process (Process Builder).
However, I doubt if you can update the field names this way.