Skip to main content

Is there a way to auto-number. it’s like I need GVE001 to VGE250. is there an easy way to do that?

Hi


Yes there is. Assuming you mean you want to autonumber GVE001 to GVE250 (not VGE in your post)


Add another field of type “autonumber”


Add a field of type “formula” and add the following


CONCACTENATE(‘GVE’,name of your autonumber field)


Hope that helps!


Andrew


Hi


Yes there is. Assuming you mean you want to autonumber GVE001 to GVE250 (not VGE in your post)


Add another field of type “autonumber”


Add a field of type “formula” and add the following


CONCACTENATE(‘GVE’,name of your autonumber field)


Hope that helps!


Andrew


i dont understand, would you send a video? thanks and sorry


i dont understand, would you send a video? thanks and sorry


where is that i am trying to do:


where is that i am trying to do:


as @Andrew_Davies mentioned


You will need 2 columns for that.



  1. Name column created with formula CONCACTENATE(‘VGE’,name of your autonumber field)

  2. Column with type Autonumber


Sorry this has taken a while - here is a little video. Hope it helps!



Reply