Skip to main content
I'm using the following formula on Accounts to break up the address line into two lines for an integration:

 

Break Up Street Line 1

 

IF( 

 

CONTAINS(BillingStreet, MID($Setup.Global__c.CRLF__c,3,1)), 

 

LEFT( 

 

BillingStreet, 

 

FIND(MID($Setup.Global__c.CRLF__c,3,1), BillingStreet) 

 

), 

 

BillingStreet 

 

)

 

Break Up Street Line 2

 

IF( 

 

CONTAINS(BillingStreet, MID($Setup.Global__c.CRLF__c,3,1)), 

 

RIGHT( 

 

BillingStreet, 

 

LEN(BillingStreet)-LEN( Break_Up_Street_Test__c )), 

 

"" 

 

)

 

This is working correctly for myself, but other users (even other admins) just have the entire address show on Break Up Street 2.

 

Here is a picture of my global setting:

 

Giving Profile Access to a Public Global Custom Setting

 

What do I need to do to get the custom setting to work for all of my users?
3 respuestas
  1. 27 may 2017, 9:38
    Hi Micah,

     

    Could you please post a screen of the "manage" screen of your global settings? 

     

    Thanks,

     

    Quentin 
0/9000