Salesforce IdeaExchange
Support for aggregate functions in SOQL
We often need to bring back way more data than we need to and do extra processing on the client because we can't use aggregate functions in SOQL queries. Specifically MIN, MAX, COUNT and SUM would be very very useful. We should be able to group on any field and use these aggregate functions on any other field, eg:
SELECT StageName, SUM(Amount) FROM Opportunity
GROUP BY StageName
Also, to truly make these functions useful, you would need to be able to use them on lookups as well, eg:
SELECT Owner.Name, COUNT(*) FROM Opportunity
GROUP BY Owner.Name
Roll-up summary field - cases on account
We would very much like to be able to do a count of the # cases on an account. Like other rollup summary fields we might even want to have a few different aggregates so that we could differentiate a few key types of cases or time-frames as well as an overall total.
For us having a case count by contact is not as important, but for other businesses it might be. Ideally there would be the ability to do summaries of cases at both the contact and account level.
The ability to use a picklist value in a formula field without ISPICKVAL
Currently, it is not possible to use a picklist in a formula field just by inserting the merge field. Creating a text formula field, one would think that it is possible to display a value of picklist just by inserting the merge field into the formula. However, without using the ISPICKVAL function a picklist cannot be used in a formula field.
Please add the ability to use a picklist in a formula field without using the ISPICKVAL function.
Export Data of Recycle Bin by DATALOADER
I want to export data of recycle bin by dataloader.
Use Ranges in CASE function
I know this is a long shot, but the CASE function would be much improved if we could use ranges for the Result Criteria.
CASE(MyCustomFormulaField_Number ,
1-40, "Low"
41-80, "Medium"
81-100, "High"
"No Number" )
Record types should be included as 18 chars in backup
All ID fields in the backup are in 18 character form, except the record type field in each csv file, which is 15 chars long. However, the ID field in RecordTypes.csv itself is 18 chars.
Perhaps it's not a big issue, but if you try to join the CSV information together (eg external analysis, or data synthesis) then you have to REMEMBER to trim the ID of the record type records.
It's just inconsistent - surely there's no reason for this.....
"Where is this used?" button for all fields
We should have an easily accessible method if finding where any field is being used, such as via the "Where is this used" button available on S-Controls. For example, this would show
- page layouts
- formulas
- validation rules
- workflow
Global custom fields
It will be great if you can provide facility to create global custom fields.
We should be able to add these global fields with standard and custom objects as custom fields.
This will be helpful if we are using same field with same values (picklist and multipicklist fields) in more than one object. Currently we needs to create/update the field labels and values in all the objects separately.
Data Loader Update Notification!
Here is a simple one. It would be great if somewhere within the Data Loader download page it would indicate the current release.
"Print Schema" and/or "Dump Schema" to document custom schema
Hi,
This idea/need is similar to "Ability to Download SF Object Schema and ERD", but the focus is on documentation, rather than database re-creation.
I need a quick way to document our customized SFDC schema. The ideal thing would be a "print schema" selection somewhere on or under the "setup" screen. Direct and PDF options would be great.
It would be nice to be able to dump to a csv as well ("Dump Schema?"), just the schema info with no data. But just printing to a PDF would be fine for now.
Thanks!
-- David.
Custom Schedule Object
Create the ability for admin to create an object type called Schedule. Everyone can use schedules for all kinds of objects. It is impossible to create schedule with separate lines of data records and easily manipulate them and see that collection of data as a whole. Reports are good to view but the realistic use of the data is not. The same setup of the Opportunity Products schedule could be used as the model for the custom schedule. Companies are all about planning ahead and making those decisions based on a collective whole, therefore schedules can fulfill this need in looking at data.
A custom schedule would come preloaded with certain fields and a schedule similar to Opportunity Product Schedule. It would come with quantity for the number of lines, line descriptions, either date/month for each line or ability to create auto-numbering, and amount.
This could then be related to any custom object and allow for items such as revenue forecasting in other custom objects, product listing, pretty much anything that needs scheduling and not a full on task to schedule. Something that may also help is simply by adding in + at the bottom to allow addition of rows.
Ability to save 'field maps' when using data 'import wizard'
Please, please, please provide the ability to save 'field maps' when using the data 'import wizard' in precisely the same way that sdl files can be created to record mapping information when using the Data Loader.
Hours can be wasted mapping and re-mapping data files with identical layouts.
Remember, there's a 50,000 record load limit, and the Data Loader doesn't apply the same data deduplication logic that the 'import wizard' does. That's why it is necessary!
You know it makes sense.
Subscribe
POST IDEA