function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

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..




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.






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..