Once, I needed in airtable a single select column with 500 options.
Of course I build a little automation with make and smart links to create this.
But when I started I got the issue that it was prohibited.
I have to admit that I created 2 or 3 options in the single select column manually before I started that automation.
I just deleted those options and started the automation again and … viola – it worked.
Now, I need an automation, that adds a new option to a single select column when time goes on. (January '23, February '23 etc.)
Again, I prepared 24 options in the single select column for the next 2 years till December '24 and tested my automation with January '25 to get the error message above.
So I deleted all my prepared options in the single select column, took my little automation to create those options instead and than I started the automation, that sometimes should add January '25, February '25 etc.
But unfortunately I get the error message again …
Then I tried to delete my formula and insert Januar '25 manual.
And this is not allowed …
Do I get this issue because this automation itself hasn’t created the options in the single select column?
Ok, then I deleted all created options in the single select column again and started the automation that should create those options sometimes …
And now … It works.
Well, so I have to create the first options this way.
But I am asking myself, if this works in the next months, too …
Any thoughts or similar experiences?