If it can't be done at the DB level (as an option when creating/editing the field) you could create a trigger on object insert that checks if the field is equal to null and if it is simply populate it with the value you want as the default.
Edit the field and specify a value in the Default Value formula. Note that this won't affect existing records, only new records that are created from that point forward.
If it can't be done at the DB level (as an option when creating/editing the field) you could create a trigger on object insert that checks if the field is equal to null and if it is simply populate it with the value you want as the default.
Hi, Thanks for the reply.
Is it possible to set the default value when creating/editing the number field?
Thanks
Hari G S
Edit the field and specify a value in the Default Value formula. Note that this won't affect existing records, only new records that are created from that point forward.