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
Sarthak Bajaj 6Sarthak Bajaj 6 

Add Particular value in field update which is used in workflow

Hi all,
 
I have a text field Zip which is a not required field.What i want is that if a user leaves this field blank so it must be auto populated with a particular value-"00000".

The solution which i opted is I creaed a Workflow with formula 
ISNULL(Zip__c)


Then in the Field Update I used 
TEXT(00000)


The outcome of which is thet Zip is getting auto populated with only one Zero.But i Want 5 zeros.
Thannks in advance
Best Answer chosen by Sarthak Bajaj 6
Yury BondarauYury Bondarau
Hi,

I guesss you do NOT need to use TEXT() function.
Use value in quotes instead, for example: 
'00000'

 

All Answers

Yury BondarauYury Bondarau
Hi,

I guesss you do NOT need to use TEXT() function.
Use value in quotes instead, for example: 
'00000'

 
This was selected as the best answer
Sarthak Bajaj 6Sarthak Bajaj 6
Thanks alot Yury Bondarau.
That was so easy.:)
It worked for me.
Sarthak Bajaj 6Sarthak Bajaj 6
I dont kw why but it is  automatically autofilling the field while in the edit page(before saving the record).
Though th eprocess i sworking fine,but how can ishow the field as null in the beginning so that user can enter data what he wishes to enter without removing 00000 first.
It would be great if you help.