Details about this thread
  • State Verified Answer
  • Replies 6 replies
  • Subscribers 293 subscribers
  • Views 984 views
  • Users 0 members are here
Related content from around SugarClub

Workflow:send email pb with related Module

Thomas Tallard

Hello, I would like to send a custom email due to a specific name relative to a campaign and a contact.

So for example, I have two modules with a relationship

  • Campaign form
  • Contact

When I build my rapport, I have no problem, I can see the campaign and the associated contact.

But when I build a workflow to send an email to the contact that notified the campaign. It doesn’t work. I did exactly the same thing that https://support.sugarcrm.com/Knowledge_Base/Workflows/Notifying_a_Customer_When_Receiving_a_Note_Via_the_Portal/

I put 2 persons to the wished email (the administrator, I and the contact). The contact doesn’t receive the email. I put some dynamic value in the body of the email And I have only the values of the target module. The values of the associated module aren’t displayed. Instead I have a Invalid Value.

https://image.noelshack.com/fichiers/2019/49/3/1575475484-help.jpg

Regards,

Thomas

Parents
  • 0

    Hi Thomas,

    The likely issue here is that you are testing against a workflow that is set to trigger when the record is saved rather than after time elapses. The KB article linked in your original post details how to configure the workflow for this scenario. Your condition based off the screenshot provided should read 'Name equals SMS API queries thomas for 0 hours'. 

    The reason why time elapsed workflows are critical for this type of functionality is due to how relationships are formed in Sugar. The order of operations for your current workflow would be:

    1. New Campaign Form record is saved
    2. On-Save workflows are triggered
    3. Relationships are saved

    The reason invalid values are generated is that the on-save workflow is not aware of an existing relationship yet. Configuring a time-elapsed workflow ensures that the relationship is established when the scheduled job processes the workflow. The order of operations in this scenario would be:

    1. New Campaign Form record is saved
    2. Record is queued for workflow processing if field conditions are met
    3. Relationships are saved
    4. Scheduler runs at next interval and processes any records meeting the time-elapsed criteria

    Please let me know if any issues persist after configuring the time-elapsed workflow.

    Co-Founder | SugarCRM's 2024 Global Outfitters Partner of the Year

Reply
  • 0

    Hi Thomas,

    The likely issue here is that you are testing against a workflow that is set to trigger when the record is saved rather than after time elapses. The KB article linked in your original post details how to configure the workflow for this scenario. Your condition based off the screenshot provided should read 'Name equals SMS API queries thomas for 0 hours'. 

    The reason why time elapsed workflows are critical for this type of functionality is due to how relationships are formed in Sugar. The order of operations for your current workflow would be:

    1. New Campaign Form record is saved
    2. On-Save workflows are triggered
    3. Relationships are saved

    The reason invalid values are generated is that the on-save workflow is not aware of an existing relationship yet. Configuring a time-elapsed workflow ensures that the relationship is established when the scheduled job processes the workflow. The order of operations in this scenario would be:

    1. New Campaign Form record is saved
    2. Record is queued for workflow processing if field conditions are met
    3. Relationships are saved
    4. Scheduler runs at next interval and processes any records meeting the time-elapsed criteria

    Please let me know if any issues persist after configuring the time-elapsed workflow.

    Co-Founder | SugarCRM's 2024 Global Outfitters Partner of the Year

Children