Jump to content


Member Since 08 Mar 2015
Offline Last Active Feb 28 2017 12:30 PM

Topics I've Started

Change default number of rows in a Report

19 March 2016 - 11:52 AM

Hi, I'm trying to create a report with more than the default 20 rows. The sql for the report shows a 'limit = 20' on it.
I'd like to have 100 rows, so I need to change the value of 20 to 100.
Any idea on how to do this?
Thanks! Dan
select `opportunity`.`id` opportunityid from `opportunity` where (((`opportunity`.`closedate` >= '2016-02-18') and (`opportunity`.`closedate` <= '2016-03-19')) and (`opportunity`.`name` IS NOT NULL)) order by `opportunity`.`name` asc, `opportunity`.`closedate` asc limit 20 offset 0

Workflow- clone project?

28 March 2015 - 12:57 PM

In my business ( a small lettershop), I have opportunities that turn into orders ( a mailing job, consisting of 3 to 5 tasks). 


I'm trying to setup a workflow so that when an opportunity is saved as 'closed/won', then it would create a small project, consisting of the 3 to 5 tasks, that would would have the same name as the opportunity. 


Is there a way to clone an existing project template, and automatically name it, via a workflow?

I would like this to be automatic, if at all possible.




08 March 2015 - 04:06 PM

Just wanted to say hello.

I have been using SugarCRM for years now, looking for another solution where the road continues forward on the open source side.

I'm hoping Zurmo.org will continue, I just loaded it yesterday, and it's everything that I had hoped for, and has a lot of possibilities.