Results 1 to 2 of 2

Thread: Update calculated fields

  1. #1
    matt.tart is offline Junior Member
    Join Date
    May 2011
    Posts
    5

    Default Update calculated fields

    I have a calculated field I want to update every night, I think I can use a scheduler to run a script. What would the code look like just to run through every record in a module and update the calculated fields?

  2. #2
    rafael.q.g@hotmail.com's Avatar
    rafael.q.g@hotmail.com is offline Sugar Community Member
    Join Date
    Jun 2011
    Location
    Florianópolis - Brazil
    Posts
    782

    Default Re: Update calculated fields

    You could write your own php code in an external oage which access sugar crm database and compute desired info.

    Then you can create a scheduler and configure it to access your page's url.
    Rafael Queiroz Gonçalves
    Advanced OMG UML Certified Professional
    Sun Certified Enterprise Architect for the Java Platform
    Sun Certified Programmer for the Java 2 Platform
    IBM Certified Advanced Application Developer - Lotus Notes and Domino
    IBM Certified Application Developer - IBM WebSphere Portlet Factory
    Computer Science Mastering / UFSC - PPGCC

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Update calculated fields
    By matt.tart in forum Developer Help
    Replies: 0
    Last Post: 2011-10-25, 09:45 PM
  2. Calculated fields 6.1?
    By Meyer in forum Help
    Replies: 6
    Last Post: 2011-07-29, 11:06 AM
  3. v6.1 calculated fields
    By Meyer in forum Help
    Replies: 2
    Last Post: 2011-04-08, 05:35 AM
  4. Creating Fields - calculated fields and 'related' field
    By gipps in forum General Discussion
    Replies: 0
    Last Post: 2007-07-21, 10:17 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •