I’m a newbie so this may be a dumb question.
I’m building a To Do list. I’d like the primary field to be a Single Select for category (priority to do, shopping list, normal to do, etc.). Since Single Select is not available for the primary field I thought of using a formula that would simple be the name of my category field. This works, but duplicates data in the category field leading to confusion. I thought about hiding the primary field, but this also is not allowed. I then thought of auto number, but this too is not allowed. I tried the function record id. It works, but what it returns is confusing and meaningless to the casual user.
Can someone suggest a better way?