Help

Autofill drag with alphanumeric?

Topic Labels: Formulas
1613 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Benjamin_Wan
4 - Data Explorer
4 - Data Explorer

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