Hi,
At one point, I needed a single select column in Airtable with 500 options. Naturally, I built a small automation using callin.io and smart links to accomplish this.
However, when I first started, I encountered an issue where it was prohibited.
I must admit that I manually created 2 or 3 options in the single select column before initiating the automation. I then deleted those options and restarted the automation, and voilà – it worked.
Now, I need an automation that adds a new option to a single select column over time (e.g., January '23, February '23). Again, I prepared 24 options for the next two years, up to December '24, and tested my automation with January '25 to receive the error message shown above.
So, I deleted all the prepared options in the single select column, used my little automation to create those options instead, and then started the automation that was supposed to sometimes add January '25, February '25, etc. Unfortunately, I'm getting the error message again...
Then I tried to delete my formula and manually insert January '25. This is not permitted...
Is this issue occurring because this automation itself did not create the options in the single select column?
Ok, I then deleted all the created options in the single select column again and initiated the automation that was supposed to create these options sometimes...
And now... It works.
Well, so I have to create the initial options this way.
But I'm wondering if this will continue to work in the coming months...
Any thoughts or similar experiences?
Best regards
Martin
This is occurring frequently now. All my scenarios are failing because all the values are being rejected.
I'm encountering the same issue…
Yes, I'm encountering the same issue.
I've found a workaround that functions:
- Create a record without specifying the select field initially.
- Utilize a callin.io API call to update the record, adding the new option to the select field and setting
typecast: true
.
typecast
is an Airtable parameter that supports the "smart links" functionality within callin.io.