Warning: Use of undefined constant user_level - assumed 'user_level' (this will throw an Error in a future version of PHP) in /nfs/c01/h06/mnt/3807/domains/sfdc.arrowpointe.com/html/wp-content/plugins/ultimate_ga.php on line 524

Summer ’07 Features


Warning: Use of undefined constant user_level - assumed 'user_level' (this will throw an Error in a future version of PHP) in /nfs/c01/h06/mnt/3807/domains/sfdc.arrowpointe.com/html/wp-content/plugins/ultimate_ga.php on line 524
Share

As you may know by now, Salesforce has an Idea Exchange category for upcoming Summer ’07 features. There are a lot of great features to be excited about including improvements to Mass Email, Workflow and Reporting. However, for me, the most exciting/useful feature will be the Cross-Object Formulas. Salesforce product management added a note to that idea saying that:

This idea really encompasses two features – referencing parent fields on a child, and rolling up child information to a parent. The latter of these is on schedule to be available with the Summer ’07 release! Stay tuned for more information in the coming months!

The ability to create formulas that COUNT, SUM, MIN, MAX, etc. values from child records will be huge. It will especially huge if conditions can be added within that. For example, from an Account, you might have a formula field to SUM(all Won Opporortunities from a particular Lead Source). Another might be to simply SUM(all Won Opportunities).

Until the release notes are out, we won’t know exactly what this functionality will (not) do, but it’s exciting to know some aspect of it is coming. This will save users a lot of time from having to run reports to get this information and it will save developers a lot of time having to create those reports!


Warning: count(): Parameter must be an array or an object that implements Countable in /nfs/c01/h06/mnt/3807/domains/sfdc.arrowpointe.com/html/wp-includes/class-wp-comment-query.php on line 399

8 Comments »


  1. Warning: Use of undefined constant user_level - assumed 'user_level' (this will throw an Error in a future version of PHP) in /nfs/c01/h06/mnt/3807/domains/sfdc.arrowpointe.com/html/wp-content/plugins/ultimate_ga.php on line 524
    Steve Said,

    June 20, 2007 @ 7:29 am


    Warning: Use of undefined constant user_level - assumed 'user_level' (this will throw an Error in a future version of PHP) in /nfs/c01/h06/mnt/3807/domains/sfdc.arrowpointe.com/html/wp-content/plugins/ultimate_ga.php on line 524

    When they’re talking about this feature, they’re always saying “Parent – Child” and I think that’s important. Account is the parent of Opportunity, so I think you’d be able to sum Opportunity Amounts to the Account. But, Contact to Opportunity via the ContactRole object isn’t a Parent – Child relationship, so I suspect we won’t be able to do those kinds of rollups.

    We’ll see when the release comes…


  2. Warning: Use of undefined constant user_level - assumed 'user_level' (this will throw an Error in a future version of PHP) in /nfs/c01/h06/mnt/3807/domains/sfdc.arrowpointe.com/html/wp-content/plugins/ultimate_ga.php on line 524
    Luke Said,

    June 20, 2007 @ 7:38 am


    Warning: Use of undefined constant user_level - assumed 'user_level' (this will throw an Error in a future version of PHP) in /nfs/c01/h06/mnt/3807/domains/sfdc.arrowpointe.com/html/wp-content/plugins/ultimate_ga.php on line 524

    Thanks for pointing that one out – I missed it in my 90-second review of the new features. I’ve spent the past 3 months coming up with various ways of doing just this in AJAX ; as is so often the case, I spend hours “preinventing” the wheel when I should just wait for Salesforce to roll out a solution!

    (course I am still waiting for HTML formatting in Solutions that was promised in Spring…)

    Luke “Always Thinkin” C.


  3. Warning: Use of undefined constant user_level - assumed 'user_level' (this will throw an Error in a future version of PHP) in /nfs/c01/h06/mnt/3807/domains/sfdc.arrowpointe.com/html/wp-content/plugins/ultimate_ga.php on line 524
    Scott Hemmeter Said,

    June 20, 2007 @ 8:16 am


    Warning: Use of undefined constant user_level - assumed 'user_level' (this will throw an Error in a future version of PHP) in /nfs/c01/h06/mnt/3807/domains/sfdc.arrowpointe.com/html/wp-content/plugins/ultimate_ga.php on line 524

    Steve, I agree. They are not delivering 100% of the need expressed in the Idea. This would only be formulas from parent objects looking down on their child objects. It would not allow you to include, for example, the Contact’s Mailing City on a Case (i.e. it would not allow joined fields).


  4. Warning: Use of undefined constant user_level - assumed 'user_level' (this will throw an Error in a future version of PHP) in /nfs/c01/h06/mnt/3807/domains/sfdc.arrowpointe.com/html/wp-content/plugins/ultimate_ga.php on line 524
    Andres Said,

    June 22, 2007 @ 10:55 pm


    Warning: Use of undefined constant user_level - assumed 'user_level' (this will throw an Error in a future version of PHP) in /nfs/c01/h06/mnt/3807/domains/sfdc.arrowpointe.com/html/wp-content/plugins/ultimate_ga.php on line 524

    I wonder too if cross object formulas will be available for custom objects.

    If I build a Master-Detail relationship between an Opportunity and a Custom Object, will I be able to “roll up” financial values (for example) to the Opportunity?

    We’ll see! Closer is better than not at all though. I suspect at minimum custom fields on Opportunity Lines will be available for “roll up” to the Opportunity. I know of a few clients that have spent thousands of dollars to “get there” for just this need in particular.


  5. Warning: Use of undefined constant user_level - assumed 'user_level' (this will throw an Error in a future version of PHP) in /nfs/c01/h06/mnt/3807/domains/sfdc.arrowpointe.com/html/wp-content/plugins/ultimate_ga.php on line 524
    Chris Said,

    June 24, 2007 @ 8:34 pm


    Warning: Use of undefined constant user_level - assumed 'user_level' (this will throw an Error in a future version of PHP) in /nfs/c01/h06/mnt/3807/domains/sfdc.arrowpointe.com/html/wp-content/plugins/ultimate_ga.php on line 524

    Agreed – can’t wait for this to feature to be rolled out, along with any subsequent ideas that may be needed to finish it off…


  6. Warning: Use of undefined constant user_level - assumed 'user_level' (this will throw an Error in a future version of PHP) in /nfs/c01/h06/mnt/3807/domains/sfdc.arrowpointe.com/html/wp-content/plugins/ultimate_ga.php on line 524
    Aiden Said,

    June 28, 2007 @ 7:20 am


    Warning: Use of undefined constant user_level - assumed 'user_level' (this will throw an Error in a future version of PHP) in /nfs/c01/h06/mnt/3807/domains/sfdc.arrowpointe.com/html/wp-content/plugins/ultimate_ga.php on line 524

    Hi,
    I just logged into a Summer 07 pre-release of salesforce.com and immediately tried to test what “Roll-Up Summary” fields can and cannot do.

    Here’s some information from the on-line help which shows the limitations of this new feature.

    Create roll-up summary fields on:
    Any custom object that is on the master side of a master-detail relationship.
    Any standard object that is on the master side of a master-detail relationship with a custom object.
    The object on which you create the field should be on the master side of a custom master-detail relationship.

    (I can create a roll-up summary between Account and a custom table, but so far can’t create one between Account and Opportunities, Opportunity and Opportunity Line Items, or Opportunity LIne Item and Opportunity Line Item Schedules.)

    For the maximum number of roll-up summary fields allowed in your organization, see App Setup Limits.

    Roll-up summary fields cannot calculate the values of other roll-up summary fields.

    Roll-up functions are Count, Sum, Min, Max

    Roll-up summary fields can calculate the values of formula fields.

    Calculating roll-up summary field values may take up to 30 minutes, depending on the number of records affected and other factors.
    If your organization uses multiple currencies, the currency of the master record determines the currency of the roll-up summary field.

    Roll-up summary fields do not support objects with advanced currency management. If advanced currency management is enabled in your organization, we recommend deleting any existing currency roll-up summary fields on opportunities to prevent the invalid roll-up summary icon from displaying.

    Automatically derived fields such as current date or current user are not allowed in roll-up summary fields.


  7. Warning: Use of undefined constant user_level - assumed 'user_level' (this will throw an Error in a future version of PHP) in /nfs/c01/h06/mnt/3807/domains/sfdc.arrowpointe.com/html/wp-content/plugins/ultimate_ga.php on line 524
    David Claiborne Said,

    June 28, 2007 @ 10:57 am


    Warning: Use of undefined constant user_level - assumed 'user_level' (this will throw an Error in a future version of PHP) in /nfs/c01/h06/mnt/3807/domains/sfdc.arrowpointe.com/html/wp-content/plugins/ultimate_ga.php on line 524

    I also tried the roll-up summary in the pre-release. I was looking for something that would roll up child accounts into a parent account.

    Nope, it’s not there.

    You could do it with Apex, but it could get very contentious when there are a lot of accounts and a lot of children.


  8. Warning: Use of undefined constant user_level - assumed 'user_level' (this will throw an Error in a future version of PHP) in /nfs/c01/h06/mnt/3807/domains/sfdc.arrowpointe.com/html/wp-content/plugins/ultimate_ga.php on line 524
    John Hart Said,

    July 6, 2007 @ 11:47 am


    Warning: Use of undefined constant user_level - assumed 'user_level' (this will throw an Error in a future version of PHP) in /nfs/c01/h06/mnt/3807/domains/sfdc.arrowpointe.com/html/wp-content/plugins/ultimate_ga.php on line 524

    Aiden,

    I haven’t yet tried the roll-up fields in a pre-release build.

    Have you seen any official documentation about the “up to 30 minute” delay in calculating roll-up values? The Summer 07 release notes don’t mention this.

    I was hoping to use some of these values within triggers, but if there’s a delay then that won’t be workable & I’ll have to maintain them myself. Any pointers to official docs which state this?

    thanks,
    john

RSS feed for comments on this post · TrackBack URI

Leave a Comment

All comments are moderated. Other visitors will not see your comment until it has been approved.


Warning: Use of undefined constant user_level - assumed 'user_level' (this will throw an Error in a future version of PHP) in /nfs/c01/h06/mnt/3807/domains/sfdc.arrowpointe.com/html/wp-content/plugins/ultimate_ga.php on line 524

Warning: Use of undefined constant user_level - assumed 'user_level' (this will throw an Error in a future version of PHP) in /nfs/c01/h06/mnt/3807/domains/sfdc.arrowpointe.com/html/wp-content/plugins/ultimate_ga.php on line 524