Menu
Welcome, Guest
Username: Password: Remember me

TOPIC: Change field in one module using data from a related module

Change field in one module using data from a related module 1 week 6 days ago #89091

  • AeroDonkey
  • AeroDonkey's Avatar
  • Offline
  • Premium Member
  • Nothing can't be done....!
  • Posts: 115
  • Thank you received: 3
  • Karma: 0
I have a module with member information. It has a one to many relationship with a payments module. Is there a way to iterate through all payments associated with a related member and report a month that a payment was missed. Also report on the first month a related member made a payment (first payment).

For instance: payment made and recorded in june and august. Report july as unpaid.

And the second. A member has been paying for 6 months. Report the month of the first payment.

I've tried a workflow and it doesnt seem to work.

Condition:
Payments Module
Payment date>april
Payment date< june

Action: modify record

Member Module
May paid checkbox filled



Report is configured to show if payment month is unchecked
The administrator has disabled public write access.

Change field in one module using data from a related module 1 week 2 days ago #89260

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 10932
  • Thank you received: 1635
  • Karma: 371
This sounds too complex for a workflow...

You would need to write some custom code, I guess.

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.045 seconds
Powered by Kunena Forum