Workflow Calculated Fields Relationship Parameters Dropdown missing #5101

Open
opened 2026-02-20 16:29:35 -05:00 by deekerman · 1 comment
Owner

Originally created by @markbond1007 on GitHub (Sep 27, 2023).

Issue

Expected Behavior

When creating/editing a workflow and using the action "Calculate fields" there is an "Add relationship paramters" section. This should include drop downs for the relationship and then the field from the related bean and lastly the raw/formatted drop down. The field drop down is missing.

Actual Behavior

Dropdown is not appearing at all.

Possible Fix

Steps to Reproduce

  1. Create new workflow
  2. select a module
  3. add an action
  4. select Calculate Fields

Context

Your Environment

  • SuiteCRM Version used: 7.13.3/8.3.1
  • Browser name and version (e.g. Chrome Version 51.0.2704.63 (64-bit)): Chrome 117.0.5938.92 (Official Build) (x86_64)
  • Environment name and version (e.g. MySQL, PHP 7):PHP7/PHP8
  • Operating System and version (e.g Ubuntu 16.04):Debian
Originally created by @markbond1007 on GitHub (Sep 27, 2023). <!--- Provide a general summary of the issue in the **Title** above --> <!--- Before you open an issue, please check if a similar issue already exists or has been closed before. ---> <!--- If you have discovered a security risk please report it by emailing security@suitecrm.com. This will be delivered to the product team who handle security issues. Please don't disclose security bugs publicly until they have been handled by the security team. ---> <!--- Please be aware that as of the 31st January 2022 we no longer support 7.10.x. New issues referring to 7.10.x will only be valid if applicable to 7.12.x and above. If your issue is still applicable in 7.12.x, please create the issue following the template below --> #### Issue <!--- Provide a more detailed introduction to the issue itself, and why you consider it to be a bug --> <!--- Ensure that all code ``` is surrounded ``` by triple back quotes. This can also be done over multiple lines --> #### Expected Behavior <!--- Tell us what should happen --> When creating/editing a workflow and using the action "Calculate fields" there is an "Add relationship paramters" section. This should include drop downs for the relationship and then the field from the related bean and lastly the raw/formatted drop down. The field drop down is missing. #### Actual Behavior <!--- Tell us what happens instead --> <!--- Also please check relevant logs (suitecrm.log, php error.log etc.) --> Dropdown is not appearing at all. #### Possible Fix <!--- Not obligatory, but suggest a fix or reason for the bug --> #### Steps to Reproduce <!--- Provide a link to a live example, or an unambiguous set of steps to --> <!--- reproduce this bug include code to reproduce, if relevant --> 1. Create new workflow 2. select a module 3. add an action 4. select Calculate Fields 5. #### Context <!--- How has this bug affected you? What were you trying to accomplish? --> <!--- If you feel this should be a low/medium/high priority then please state so --> #### Your Environment <!--- Include as many relevant details about the environment you experienced the bug in --> * SuiteCRM Version used: 7.13.3/8.3.1 * Browser name and version (e.g. Chrome Version 51.0.2704.63 (64-bit)): Chrome 117.0.5938.92 (Official Build) (x86_64) * Environment name and version (e.g. MySQL, PHP 7):PHP7/PHP8 * Operating System and version (e.g Ubuntu 16.04):Debian
Author
Owner

@johntnz commented on GitHub (Sep 9, 2024):

The issue is at line 456 of actionComputeField.php where the check is counting something about the number of parameter fields defined for the calculation, instead of the number of relationships that exist for the base object.

There is a simple workaround until it gets fixed correctly. Define a field parameter and save the workflow. When you open and edit the workflow you can correctly create fields from the related objects. You can't delete the original field prameter but you don't have to use it in your calculation.

Although my PHP skills are not sufficient to determine what count should be being checked at line 456 I do not think that proposed fix #10216 is correct.

@johntnz commented on GitHub (Sep 9, 2024): The issue is at line 456 of actionComputeField.php where the check is counting something about the number of parameter fields defined for the calculation, instead of the number of relationships that exist for the base object. There is a simple workaround until it gets fixed correctly. Define a field parameter and save the workflow. When you open and edit the workflow you can correctly create fields from the related objects. You can't delete the original field prameter but you don't have to use it in your calculation. Although my PHP skills are not sufficient to determine what count should be being checked at line 456 I do not think that proposed fix #10216 is correct.
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/SuiteCRM-SuiteCRM#5101
No description provided.