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