Error message: There is a slight problem. That field is used in a multi-form configuration
Problem
When you change a calculation on a calculated custom field on a custom form, Adobe Workfront might display the following warning:
There’s a slight problem
[The field] is used in a multi-form configuration, if you would like to change this formula you will need to remove this field and replace it with a new one containing the desired calculation.
Cause
At least two custom forms containing the calculated custom field you’re trying to change are attached to a single object in your Workfront instance.
Example: Custom forms A and B are both attached to the same task. Both forms contain a calculated custom field called Profit. You encounter the error when you try to edit the calculation in the Profit field on custom form A.
You can’t change the calculation for the custom field in one of the forms because that would conflict with the formula in the same field in the other form.
To resolve this conflict, you must find the object where the multiple forms with the same calculated custom field are attached, then do one of the following:
- Remove one of the forms from the object.
- Change the calculation as needed, but do so in all of the custom forms that are attached to the object.
- In all of the custom forms attached to the object, add a new calculated custom field containing the calculation you need and mark the old calculated custom field as obsolete.
This article explains how to find the object and then resolve the problem in one of these three ways.
Find the object where the custom forms are attached find-the-object-where-the-custom-forms-are-attached
-
Click the Main Menu icon
-
Click Custom Forms > Fields.
-
Apply the Field List view to find the calculated field you are trying to modify, and make note of every custom form on which it is used (e.g. Form 1, Form 2, Form 3) .
-
Click Forms, then apply the Form List view.
-
Click the Filter drop-down list, then New Filter.
-
Click Add a Filter Rule, then start typing “custom form name” and select this value when it displays in the list.
-
Select Equal for the filter modifier, start typing the name of each form you made a note of in Step 1, then select it when it displays.
Example: Custom Form Name Equals Form 1, Form 2, Form 3.
-
Click Save Filter, then name the new filter, and click Save Filter.
-
In the list of forms, make note of the object type of the filter, such as Task or Issue, that displays in the Type column.
-
On each custom form you found in Step 1, create a new Checkbox custom field with a single default value of Yes.
Example: Field 1 on Form 1 = Yes, Field 2 on Form 2 = Yes, Field 3 on Form 3 = Yes. This means “The Calculated Custom Field exists on Form 1,” or “The Calculated Custom Field exists on Form 2,” and so on.
-
In the Search icon
-
Click the object of your custom form (such as Issue), click Filter your results, then click Add a filter.
-
Start typing the name of a Checkbox field in the Start typing field name field and select it when it displays in the list, then select Equal and type Yes (without quotation marks) in the following box.
Example: Field 1 Equal (Case Sensitive) Yes.
-
Click Add a Filter and add all Checkbox fields to your Advanced Search.
Look for every possible combination.
Example: Build several filters with the combinations you find, as listed below. You should find objects with multiple attached custom forms that contain the same calculated fields. You might find the following scenarios:
- Field 1= Yes + Field 2 = Yes + Field 3 = Yes (no objects, for example)
- Field 1= Yes + Field 2 = Yes (no objects, for example)
- Field 1= Yes + Field 3 = Yes (two objects, for example)
This means that the calculated field exists on both Form 1 and Form 3, because the corresponding Checkbox fields (Field 1 and Field 3) exist on these objects.
Field 2 = Yes + Field 3 = Yes (no objects, for example)
-
Continue on to one of the following sections in this article:
Remove one of the custom forms from the object and edit the calculation there remove-one-of-the-custom-forms-from-the-object-and-edit-the-calculation-there
-
Find the object where the custom forms are attached, as explained in Find the object where the custom forms are attached in this article, then open the object.
-
Remove one of the custom forms from the object, then save the object.
note note NOTE To add the fields from the form you removed from the object, you might need to edit the custom form that remains attached to the object. This way, you can preserve the custom data information on the object. -
In the custom form you removed, edit the calculation for the custom field you were trying to update originally, then click Save.
This time, Workfront should not encounter a conflict.
-
(Optional) Remove the Checkbox fields from the custom forms or delete them from Workfront.
Make identical edits in the calculation in all of the attached custom forms make-identical-edits-in-the-calculation-in-all-of-the-attached-custom-forms
-
Find the object where the custom forms are attached, as explained in Find the object where the custom forms are attached in this article.
-
Remove the field from all of the custom forms that are attached to the object, then save the forms.
-
Add the custom field containing the new calculation back to the custom forms.
note important IMPORTANT The calculations must be identical in all of the attached custom forms. -
(Optional) Remove the Checkbox fields from the forms or delete them from Workfront.
Add a new calculated field containing the edited calculation to one or all of the attached custom forms add-a-new-calculated-field-containing-the-edited-calculation-to-one-or-all-of-the-attached-custom-forms
To avoid losing data in the existing calculated custom field, or if you need to the edited calculation in only one of the custom forms attached to the object you found:
-
Find the object where the custom forms are attached, as explained in Find the object where the custom forms are attached in this article.
-
Add a new calculated custom field containing the calculation you need to one or all of the forms.
-
Rename the old calculated custom field Obsolete.
On all of the forms that were attached to the object, this older calculated custom form preserves its historical data, but users stop using it.
note important IMPORTANT The older field might be referenced in other calculated custom fields, so you need to update those calculations after changing its name. -
(Optional) Remove the Checkbox fields from the forms or delete them from Workfront.