function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
sirishanekkanti06sirishanekkanti06 

suggest this formula..

hi friends,

 

    my requirement is when you enter the zip code it automatically populates the details of city,state.

i creating a some data base of records.

and i worked on workflow for field update.

work flow rule criteria is: when ever record is created or edited.

in field update i am entering a formula like this

 

city__c +"," +state__c +"-"+Zip_code_Pin_code__c

 

there is no errors in the formula editor..but execution wil be to display what ever we have to enter the zip code value that will be disply to all remaining fields..

 

will you please suggest where is the mistike i have to done..

jd123jd123

Hi,

 

Create one object Zipcode__c

 

1.Change the standard field name as ZipCode.

2.create all fields like city, state all fields

 

then in your object give lookup to Zipcode__c object once he select the zipcode all fields like state, country all will popuate with the formula or in oen field you can write your formula

 

Zipcode__r.city__c +"," +Zipcode__r.state__c +"-"+Zipcode__r.Name

 

If anything wrong please let me know.

 

 
sirishanekkanti06sirishanekkanti06

hi,

 

if we create a new object like zipcode__c

the default standard field will be created like zipcode name

here the data type of zipcode change is only eithier text or auto number only..