Announcement

Collapse
No announcement yet.

Recurring Tasks

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Recurring Tasks

    Set up a task to be repeated every month, every week, etc. For example: generate invoices the 20th of each month.

  • #2
    Any thoughts about this?

    Comment


    • #3
      EspoCRM doesn't have recurring events. You can try to do this with workflow (included to Advanced Pack)

      Comment


      • #4
        Thank you for your answer Tanya. We are thinking to buy the advanced pack and didn't know we can achieve this. Just to make sure, can you confirm that I can create recurring tasks/events every month/week in an easy way?

        Comment


        • #5
          Workflow has trigger type Schedeled where you can set a scheduling rule as crontab and action type Create Entity. you can test it there http://demo.espocrm.de/advanced/

          Comment


          • #6
            Hello Espo team, Hello community,

            Does anyone has ever implemented to add recurring option to the espocrm tasks ? In many cases, using workflow seems like a hammer to kill a fly.

            Thank you,

            Xavier

            EDIT : I see a lot of posts asking for the same thing, with no update at the end of each discussion feed. Where are we now with this cold-hot topic ?
            Last edited by xador; 06-13-2023, 09:00 PM.

            Comment


            • esforim
              esforim commented
              Editing a comment
              Welcome xador! Yes, officially it is somewhere on the backlog, when? When yuri have time and considered it a useful feature I guess.

              Solution?

              1) Need paid official extension Workflow and supposedly it is possible from there.
              2) Need paid 3rd party extension that can do this that. But the store is Euro only, and if I convert that to my country the expense is a tad too high to get approval to buy.
              3) Do it yourself (!?!??!) might be possible. I'm exploring this possible using formula in the upcoming weeks once I do more customization. Not sure when yet.

              Good luck!

            • Kharg
              Kharg commented
              Editing a comment
              esforim I think I will start working on something after I finish working on my huge backlog. Still needs some ideas for the UI tho.

          • #7
            Thank you for your answer !

            My use case was for a task of recurring invoice. We have delegated that to the accounting software : Quickbooks, which is more tied to that goal.

            Cheers,

            Xavier

            Comment


            • #8
              xador I finally got around to doing it now that I understand formula a bit better!

              Here is the result of my work:
              In the future this thread will be use for discussion; the Wiki hosted on Github will be used instead to post update; please see: https://github.com/o-data/EspoCRM-Learning-and-Design/wiki Part 2 of this post can be found here: https://forum.espocrm.com/forum/gene...5114#post55114 (https://forum.espocrm.com/forum/general/54706


              There is one more thing I probably will do though, create a record "Task" or "Meeting" for the employee to chase up the payment or to check if payment have been received.

              Look like you using some sort of accounting as well and I think this formula very closely match what you want to do, or give you some idea and enlightenment.

              From my testing, it doing what I want, as I play with it, I will get 'bug' which I slowly will fix it.

              Kharg Above is my "code skill-less" result. It recurring basis on the concept of "Paid" not being received. Not the best and need to do this for each Entity whereas I think an Extension can just do it with a

              Mouse Click of "Yes Recurring and When". Enjoy your weekend upcoming up!
              Last edited by esforim; 06-16-2023, 08:34 AM.

              Comment


              • #9
                You could can try this:

                Add a 'rrule' list field to the Task Entity with these values:
                • NO
                • DAILY
                • WEEKLY
                And this script in formula:

                Code:
                while (status == 'Completed') {
                    if (rrule == 'DAILY') {
                        record\create('Task',
                            'name', name,
                            'parentId', parentId,
                            'parentName', parentName,
                            'parentType', parentType,
                            'status', 'Not Started',
                            'priority', priority,
                            'dateEnd', datetime\addDays(dateEnd, 1)
                        );
                        
                        break;
                    }
                    
                    if (rrule == 'WEEKLY') {
                        record\create('Task',
                            'name', name,
                            'parentId', parentId,
                            'parentName', parentName,
                            'parentType', parentType,
                            'status', 'Not Started',
                            'priority', priority,
                            'dateEnd', datetime\addWeeks(dateEnd, 1)
                        );
                        break;
                    }
                
                    if (rrule == 'MONTHLY') {
                        record\create('Task',
                            'name', name,
                            'parentId', parentId,
                            'parentName', parentName,
                            'parentType', parentType,
                            'status', 'Not Started',
                            'priority', priority,
                            'dateEnd', datetime\addMonths(dateEnd, 1)
                        );
                        break;
                    }
                    
                    if (rrule == 'MONTHLY') {
                        record\create('Task',
                            'name', name,
                            'parentId', parentId,
                            'parentName', parentName,
                            'parentType', parentType,
                            'status', 'Not Started',
                            'priority', priority,
                            'dateEnd', datetime\addMonths(dateEnd, 1)
                        );
                        break;
                    }
                    
                    if (rrule == 'YEARLY') {
                        record\create('Task',
                            'name', name,
                            'parentId', parentId,
                            'parentName', parentName,
                            'parentType', parentType,
                            'status', 'Not Started',
                            'priority', priority,
                            'dateEnd', datetime\addYears(dateEnd, 1)
                        );
                        break;
                    }
                    
                }​

                Comment


                • victor
                  victor commented
                  Editing a comment
                  - You have a duplicate code for 'MONTHLY'.
                  - For the custom field 'rrule', according to your formula, you should also add the value 'YEARLY'
                  Last edited by victor; 08-12-2024, 09:40 PM.

                • criffoh
                  criffoh commented
                  Editing a comment
                  Thanks victor!
              Working...
              X