How to update number id for accounts which didnot have number id?

[Deepika61]

Hi All,

Actually I have requirement that basically on the account form previously we donot have "Bill id " field, so now it is created with auto increment , so now i want to update all existing accounts which donot have that bill id  need to update with number 

Please help me to achieve this

Thanks

Deepika

[Dr Atul G- LNG]

Hi @Deepika61 

We cant update the existing Bill id , as it is auto generated. what you can do, by script, add the format/ number manually. This is only workaround, try in dev first.

[Deepika61]

@Dr Atul G- LNG 

Thanks for the response

Actually i donot want update with existing billing id, in the screenshot i have showed the format for newly created accounts , so now with that format i need a script to update all existing account records which are not having the "Bill Id"?

please provide me the script for that 

Thanks

Deepika

[Dr Atul G- LNG]

Hi @Deepika61 

I am not coder 😞

if count is less, what i can suggest

Go to List view

get Biil ID as editable ( for this activity only, try to do in NON Business hours)

Double click on field, and add the value manually, but now i m worried, if it duplicate may be later on some time then what will happen