Devs who use Webflow's CMS API are familiar with some weird behavior in how Webflow names fields.
“Wait, what... ?”
Yep, you can see why this creates all kinds of confusion and challenges for API devs,
Admittedly, this is pure speculation... but I'm pretty sure my guesses hit close to the mark.
And while understanding the reasons for this weird behavior won't fix the problem, understanding why these limitations exist might help you sleep a lot better at night.
Webflow's internal field-key naming mechanism goes to great lengths to avoid re-using old keys. That could be a design oversight, but more likely it is designed that way to avoid other problems related to the underlying DB or perhaps how backups & restores work.
Overall, I'd guess that the field-key-naming algo works something like this;
Much of this is tied to the underlying technology which appears to be MongoDB.
Why do I think it's MongoDB?
And more stuff, too.
I was curious, so I dug a bit deeper, and at least according to some job boards, Webflow's data storage makes use of MongoDB, Snowflake, Stitch, dbt, and Kafka. Is that stack accurate? I've no idea. But I feel validated anyway.
Actually, it matters a lot. Let's get some geek on.
In MongoDB, each record is stored as JSON ( BSON variant ).
A record might look like this, which is very much like what we see through the CMS API.
Document db's do not have a central schema like a relational db has, so each document can be completely different. Because of this, there are no governing rules on how fields are named.
That gives you a lot of flexibility, which is important for a CMS... but the cost of that flexibility is chaos.
Old records contain old field keys. New records cannot re-use those old-field keys for new things, without breaking your data integrity.
Renaming fields is a problem because there's no schema to operate as a single point of reference. Webflow would have to go into every document and change them individually. A major db update like that could effectively bring your production site down for a few minutes while 50,000 records are updated. Such an operation could even affect performance for other users, and their sites. Webflow can't allow that. This would also explain the tight caps on CMS record counts, and the Collection List max display of 100 items.
Shared hosting means playground rules.
This is why the field-key is set at the the point you create the field, and is never changed when you rename it.
I'd also guess that when you delete a field, that field data is not actually deleted. It's just removed from the Collection table definition, to avoid the massive update costs. What that means is that old field-keys can never be re-used, since they still exist in old items.
So what can you do?
If you're going to be using your CMS through the API, and those field names matter to you, plan ahead.
Plan your Collection List schema before you create anything, because one you create that field, that name is set forever.
Avoid deleting fields, unless you are certain they are permanently gone, forever. If you delete a field, you will never be able to create a new field with that same field-key again in that Collection. Instead, empty it using the API, rename it in the designer as DO NOT USE, and save it for later. If you need that field-key named e.g. field-1 again, it's waiting for you.
Rename fields all you like, just remember that all the renaming in the world will not change that underlying field-key in the API.
Remember, if you muck it up, and really need those field names, your only option is to re-create the Collection entirely, which can be a huge amount of work.
None of this fixes the problems, but I hope it helps you dodge some of them.
For me, I feel more sane, when I can understand the reason those limitations exist. I'm not going crazy. It's not bad design, or inept developers... it's foundational infrastructure.