Skip to main content

Can i autonumber

  • November 13, 2022
  • 5 replies
  • 58 views

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

5 replies

Forum|alt.badge.img+17

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


  • Author
  • New Participant
  • November 14, 2022

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


  • Author
  • New Participant
  • November 14, 2022

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


where is that i am trying to do:


Greg_F
Forum|alt.badge.img+18
  • Brainy
  • November 14, 2022

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

Forum|alt.badge.img+17