Menu
SuiteCRM Pull Request Party hosted by SalesAgility
Welcome, Guest
Username: Password: Remember me

TOPIC: Calculated field workflow doesn't recalculate

Calculated field workflow doesn't recalculate 6 months 2 weeks ago #75190

  • yodaswhiskers
  • yodaswhiskers's Avatar
  • Offline
  • New Member
  • Posts: 1
  • Karma: 0
Hi,

I am new to SuiteCRM, I have only used SugarCRM previously and would be really grateful of some help.

I have created a calculated field workflow which multiplies two other fields within the same custom module. The calculation works fine for the first save but does not repeat the calculation thereafter despite the following setup:

Run: Always
Run on: All records
Repeated runs: Checked

Can anybody help me with what I am doing wrong?

Thanks in advance,

YW
The administrator has disabled public write access.

Calculated field workflow doesn't recalculate 6 months 2 weeks ago #75205

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 10192
  • Thank you received: 1531
  • Karma: 352
You really don't want to have a Workflow with those settings. It will try to go over all your records every time the Scheduler runs (every minute!).

Just make it "on save", not "on scheduler". Keep the "Repeated Runs" checked.

I don't know how many records you have, but possibly your server is currently overwhelmed with long-running Workflows running on top of others...

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.

Calculated field workflow doesn't recalculate 6 months 2 weeks ago #75206

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 10192
  • Thank you received: 1531
  • Karma: 352
Check in Workflow module, on the left sidebar, option "View Process Audit" to see if there's any left-over jobs from your previous set up.

Once I had a hung job that I had to clean up from the database before I could get any other Workflow to run...

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.
Time to create page: 0.044 seconds
Powered by Kunena Forum