Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 02, 2022 05:57 AM
Hi Everyone,
Is there a Formula to populate the Alphabet Automatically. I have created a Auto number column and created 26 records and I need to populate the Full Alphabet Automatically. Is this possible or not?
Thank you
Apr 02, 2022 07:27 AM
Welcome to the Airtable community!
There are ways to create 26 records, each with a different letter of the alphabet. However, they are all more effort than manually creating the records and typing in the letters.
You could have a SWITCH formula that converts the autonumber to a letter.
You could have a script that creates the records with their letters.
You could type out the letters, one per line, and then paste them into Airtable, having Airtable create new records.
You could use a third party automation service like Zapier or Make. But again, that seems like a lot of extra work.
Apr 02, 2022 12:03 PM
Apr 02, 2022 09:54 PM
Hi,
Just a Bump? :upside_down_face: :grinning_face_with_big_eyes:
Apr 03, 2022 02:04 AM
Hi @kuovonne and everyone,
Sorry if I disturb you!
Can I know the full formula for this? Or can anyone add the full formula for this?
Thank you!
Have great day!
Apr 03, 2022 07:55 AM
You can see the syntax for a SWITCH function in the formula field reference. It is listed with the logical functions. Be sure to put your letters in straight quotes, and no quotes around your numbers.
Apr 03, 2022 08:32 AM
You could also use MID(string, whereToStart, count)
for a bit of a simpler formula.
Write out all the letters in order for the string
, then use Autonumber field for the where to start
and put 1 for the count
.