Easy way to auto recalculate formula

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Adam_KSA
    Junior Member
    • Mar 2022
    • 18

    Easy way to auto recalculate formula

    Hi. I'm looking for solution to auto recalculate formula. I'm not a software developer and I've got basic knowlage about programming so please give me clear information.
    Yes/No/Try this/Go away.
  • Kharg
    Senior Member
    • Jun 2021
    • 410

    #2
    Auto recalculate based on what?

    Every hour? Every time you open the record? By clicking a button?

    There's an extension by telecastg that adds a button to recalculate formulas https://payhip.com/b/28Dhw

    Comment

    • victor
      Active Community Member
      • Aug 2022
      • 727

      #3
      For several records, there is a special formula recalculation function. If we are talking about one record in which we work, then the simplest option is to change it, for example, write something in the description field, save the changes, and then clear this field and save changes again.

      A field with type Boolean can serve the fastest for the case of working with a specific record, where recalculation is often required.

      As an option for absolutely all records of a specific Entity, you can create a workflow that will update all records every minute (but this option requires significant resources of your server).
      Last edited by victor; 11-22-2022, 10:15 PM.

      Comment


      • esforim
        esforim commented
        Editing a comment
        From what I read, I think Workflow is your best bet Adam. Unfortunately it is Paid to use though but you must make sacrifice if you need this feature.
    • Adam_KSA
      Junior Member
      • Mar 2022
      • 18

      #4
      Thanks for fast reply. I want to recalculate the formulas for all records in one category once a day, using cron or other tools. Now i have to mark all entities in category and click Action>Rrecalculate the formula. I want to automtize this task.

      Comment

      • shalmaxb
        Senior Member
        • Mar 2015
        • 1602

        #5
        Perhaps this helps: https://forum.espocrm.com/forum/deve...ulate-formulas

        Comment

        Working...