Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Autofill drag with alphanumeric?

Topic Labels: Formulas
1170 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi, can Airtable auto fill with alphanumeric sequence? For example, my sequence goes UF-3101, UF-3102, UF-3103, etc. When I highlight the first two cells and drag it down, it just repeated the UF-3101, UF-3102 over and over instead of adding +1.

Anyway airtable can do this?

Thanks

1 Reply 1

Welcome to the community, Benjamin! :grinning_face_with_big_eyes: It works for numeric fields, but not for single line text fields. If this sequence is going to continue indefinitely, I would suggest using a formula.

First make an autonumber field, which will give you an automatic numeric sequence beginning at 1. Then add a formula field with this formula (replace “Autonumber” with the name you gave your autonumber field):

"UF-" & (3100 + Autonumber)

No need to drag anything, as Airtable will continue incrementing the number each time you make a new record.

10%20PM