I have been delving into some new areas lately and I keep coming up with more and more functionality wishes. Some bigger than others, but I want to keep documenting them as I collect bunches of them. These are more configuration and development related.
When querying data using SOQL, you cannot perform an ORDER BY. I assume this is to protect system performance, but it’d be great if there was some way to perform sorts on your data in the API. Maybe this is having ORDER BY as a parameter in SOQL. Alternatively, there could be a sort() method that can be called once you actually have your QueryResult in memory. This method should allow you to provide a multi-column sort order.
I have seen some sorting functions on the message boards, but they are a bit over my head. It would be nice to have this built right into the product.
I echo Gokubi’s recommendation for the ability to configure the Partners object. It would be great to be able to add additional information regarding the relationship between 2 accounts.
More Description fields when configuring
It would be nice to have more areas to input a description when you are configuring. Also, when there is a description field, it’d be nice to be able to see that when viewing the data in a list. For example,
- Display the Description when listing the Fields for an object
- Include a description on the Sharing Rule page and display it when viewing Sharing Rules. Some organizations have 100s of Sharing rules and it’s hard to keep them straight sometimes. Display this field on the Sharing Rule list
- Display the Description field when listing the Profiles
Utilize Views in more places in the Setup area
Setup Views on pages like Fields, Profiles, Sharing Rules, etc. so you could include any fields you want on there. You might have a view for Formula Fields that shows you all the formulas right there in one page. Or a Profile view that displays the profiles and all of their Tab permissions. Views exist today when Managing Users. Apply the same concept in other areas of the application so we do not have to drill into each record to see details all the time.
Where is this Public Group Used?
Publis Groups can be very useful for administering access to Reports, Dashboards, Documents, etc. However, it is difficult to know where a Public Group is being used unless you click into every folder. It’d be nice to have a view from the Public Group page to see where it is being used.
Picklists in Formula Fields
Right now, you cannot simply grab the value of a picklist field in a formula. You have to know the value you are looking for and use the ISPICKVAL function. Alternatively, you need to create a formula field for the picklist and go through every possible picklist value and output its corresponding text. This can be burdensome. There should be a way to simply reference the picklist field in a formula and use its value.
Formula Field Length
The workaround to the issue with picklist fields is to create a formula field that does an ISPICKVAL function on every possible picklist value and then outputs the equivalent text. The max formula size is 1000 characters, so sometimes you need to create multiple formula fields to accomplish this. If the Picklists in Formula Fields wish isn’t fulfilled, then the max length of a formula field should be increased.