Tunnel Of Death: How To Find An Object With Two Specific Custom Forms On It
You know the feeling you get when, during an online meeting, your screen share shows the "tunnel of death" with your desktop repeating over and over as you flush, embarrassed and frustrated, to scramble to figure out a way to make it stop?
I noticed a similar feeling when, upon trying to change a calculation on a custom form today, Workfront reported "There's a slight problem
[That] 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."
What that means is that -- somewhere within my Workfront environment -- there's an Affected Object attached two different custom forms that BOTH have the field I'm trying to change on them, and -- therefore -- I can't change my formula in the custom form I'm working on (e.g. 1+1=2), because it would conflict with the formula in the field on the other custom form, even if the other formula is wrong (1+1=3).
Fair enough...but how, exactly, can I then find this Affected Object? And what if there are more of them? And once I find them all, what do I do to get around this?
So! After an hour later of checking my notes, wf-pro, help, community, and noting that growing Tunnel Of Death feeling, for my own reference, and to spare you someday, here's how I escaped:
- look up the Field and note every Custom Form on which it is used (e.g. Form A, Form B, Form C) for the object type of interest (e.g. Issue)
- on each of those Custom Forms, create a brand new, separate, temporary checkbox parm with a single value of Yes, defaulted to Yes (e.g. _TEMP A on Form A, _TEMP B on form B, _TEMP C on form C)
- Save each Custom Form, effectively "tagging" any existing objects with "Yes, I am attached to Form A (and/or Form B, and/or Form C)"
- under Advanced Search, look for every possible combination:
- _TEMP A = Yes + _TEMP B = Yes + _TEMP C = Yes (none, in my case)
- _TEMP A = Yes + _TEMP B = Yes = Yes (none, in my case)
- _TEMP A = Yes + _TEMP C = Yes (Aha! TWO, in my case)
- _TEMP B = Yes + _TEMP C = Yes (none, in my case)
- Open each of the objects found and REMOVE one of the two forms (e.g. the one with 1+1=3)
- With that done, try changing field's formula again (e.g. 1+1=2)...which now WORKED in my case, since there were no more conflicts
- Drop the _TEMP custom parameters, having served their purpose
- Save, print, laminate, and post this for the next time you get that feeling
Regards,
Doug

