Can't set anything as Primary Key

I have created a collection with a number of text fields. However, the default ‘title’ field is the primary, and none of the other text fields even have an option in the popup (not even a grayed out one) to set as primary.
Why is this? I really don’t want to keep around a column that I don’t need. I also need to make email column primary, but I can’t.

Hi,
You should able to do it with text type field.


Please provide the editor url and I’ll take a look.
Thanks.

editor.wix.com/html/editor/web/renderer/edit/7d6ea04c-c345-4833-ae19-094e0bec84a5?metaSiteId=54140cfb-e3ce-44ba-9388-ed10b8d4708f

There are two databases there and neither will let me change the primary key

I’m able to change it, checking why it is happened to you.

Just had an idea, could it be because of my role?
Role: Admin Limited

Yes, maybe related. Try it just on any other site that you are an admin there.

I was made admin, and I still don’t have the option. However, the owner was able to change primary keys.