Cannot create incrementing or adding Numerical fields

Adding fields from Studio is just part of the work. You need to add some logic either via workflow or via logic hook to add the required functionality.

Check this post for a sample on how to add auto-incremental numbers based on a SQL request: