HOWTO: Change the maximum number of rows to show in a Dashlet

sugarcrmdevelopers —  May 9, 2011 — 1 Comment

I spend a good portion of my day trolling the forums looking for questions users have with using and extending Sugar, and am always impressed by how well the community comes together to help each other. A great example of this is this post I came across the other day:

Forgive me as I am quite new to Sugar.   I am needing to change the maximum number of records displayed in a module. For example, the “My Accounts” module under the home tab is showing records “1 – 5 of 12”. I want it to show a max of 20 records at a time. Thus for this example, I should be seeing records 1-12 of 12.

Any help is appreciated.

This is a great question, and one that I’m sure many users struggle with. Fortunately, there is an easy fix that forums poster osamcrm illustrated. Simply edit your config.php file in the root of your SugarCRM instance and edit the key ‘dashlet_display_row_options’ by just adding an extra item on the array for what the maximum number of items you wish to show is. So for 20 items, the config option would look like this:

Now you can go into the config options for the dashlet and choose the value you entered as the new value for the number of rows to show.

One response to HOWTO: Change the maximum number of rows to show in a Dashlet


    This is a pretty old post and this setting seems to be ignored in 7.5. Is there a new way to do this in 7.x or am I missing something.

    Our config.php:
    ‘dashlet_display_row_options’ =>
    array (
    0 => ‘1’,
    1 => ‘3’,
    2 => ‘5’,
    3 => ’10’,

    config_override.php is empty

    but the options listed when configuring a dashlet are 5, 10, 15, 20.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s