Jump to content


danwaterloo

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.

 

Thanks!


Hello!

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.