Custom Field ID to Name in Project Report

@Jason Semall , I see what you mean now. I think the best solution I can suggest is to put a calculated field on your issue/request and project form. On the issue form, put in the calculated field Label: Original Requester Calculation: Entered By.Name On the project form, put in the calculated field Label or retrieve the field: Original Requestor Calculation: IF(ISBLANK(Original Requester),"",Original Requester) Both are calculated fields so nothing for the PM or the user to enter. Then you can map the original requestor to the DAM. --- I've used Workfront to have designers (non contributor role in DAM) submit their images to be placed on the DAM by just one person (DAM admin). Requestors/Designers submit their requests with their assets to Workfront. The request form contains the info about the images/assets. I needed the same info attached to each image so that whoever is uploading to the DAM, the data is already mapped about the image and just needs to actually push the button to send to the DAM ( future state: automating this as well) but currently there's no way of auto attaching custom form to the image/asset. When I say code, I meant I wrote a program to tell the system to check all new requests for the DAM and attach a custom form to each asset and then push the contents of the request fields into the document form. The program also gives the DAM admin person manage rights to the asset so they can upload the asset to the DAM. Polly Co

Amazing, thanks so much, Polly! I have added those fields and will be testing it over then ext couple of weeks. I am also going to keep the solution you described in my back pocket in case the way I have designed our workflow doesn't end up working the way I'd like. Our designers will have contributor licenses and will be asked to push all their assets to DAM themselves, as we do not have a full time DAM admin. One more issue that I have just discovered that I would love to hear your thoughts on is the known limitation within mapping of only being able to send one value from WF to DAM for multiselect custom fields. Said another way, I have several custom fields on my forms that allow a user to select multiple values while filling out a request/issue. When I map those fields to DAM, only the last value selected is passed through (all others are ignored). Have you run into this same issue? Jason Semall Sr Creative Ops Mgr Conversant

Hello, Can we use calculated fields to pull the planned completion date of a task (or any other information from a task) in a project custom form? Thanks, Yannick Yannick Seifert WebMD

@Jason Semall , I haven't used checkboxes to map to the DAM but I've tested and saw what you meant by just one checkbox item is being sent forward. So... the best option I could think of is adding another calculated field for each checkbox field. For example, you have test3 as a checkbox field with dam1,dam2 and dam3 as the contents of the checkbox field. You then add a test4 calculated field. The calculated field contains this: CONCAT(IF(CONTAINS('dam1',test3),'dam1',''),IF(CONTAINS('dam2',test3),'dam2',''),IF(CONTAINS('dam3',test3),'dam3','')) Continue the pattern to as many contents of the checkbox field. If user has checked dam1 and dam2 on test3, test4 contents will be dam1dam2 (you can prettify this content later - I'm just giving you an example how you could possibly set up your calculated field). You can then map test4 to the DAM. Hope that helps. Polly Co

@Yannick Seifert , I haven't seen it done and I took a look at my calculated fields, I don't think it's possible but maybe somebody else in the forum can answer. Logically, the reason why I think it's not possible in the custom form is that usually the project custom form is set up upon project creation, which means tasks weren't set up yet which also meant that there should be a way to update the custom form (like Recalculate timeline or recalculate finance) but currently we don't have that. So no to the calculated field. However, another option that I have for things like this is thru API and some programming, don't know if that's an option available to you. But basically, it's like calculating fields you want outside of WF and then exporting the data back to an open field on your project custom form. Regards. Polly Co

Hi Yannick, You can pull task information on a project report by using collections in reports. There was a great presentation done at LEAP on this and I have attached the deck. Good luck! Sarah Nau Dominium

@Polly Co thank you so very much for all your help on this! This is seriously so much more helpful than going through actual support. They simply told me they knew that was an issue and that there was no fix scheduled. End of story. I greatly appreciate all the time you have taken to walk through this with me, as well as the help with text mode and calculated fields. That is definitely a weak spot of mine (for now anyway). You solution looks like it would solve my problem ! However, I am bit confused on exactly how the "pattern" would work beyond 3 options. I have fields with 15+ values, so I am having trouble visualizing how that would work in the formula you provided. Would it simply be CONCAT(IF(CONTAINS('damX',test3),'damX','') for as many options as I have? Jason Semall Sr Creative Ops Mgr Conversant

@Jason Semall , the pattern would be IF(CONTAINS('damx',test3),'damx','') So CONCAT(Pattern1,Pattern2,Pattern3,Pattern4,Pattern5) where pattern is IF(CONTAINS('checkbox option',checkboxfield),'checkbox option','') CONCAT( IF(CONTAINS('dam1',test3),'dam1','') , IF(CONTAINS('dam2',test3),'dam2','') , IF(CONTAINS('dam3',test3),'dam3','') , IF(CONTAINS('dam4',test3),'dam4',''), IF(CONTAINS('dam5',test3),'dam5','') ) Polly Co

Alright, thanks @Polly Co ! I'll start building those out! If there are spaces between the words of the values from the custom for field, should those be removed? What about "", &, and () in the values - should those be removed? Or should you enter your values into the calculation exactly as they are in the fields? Also, just wanted to confirm these calculated fields should be added on the Project custom form, not the creative change custom form. Jason Semall Sr Creative Ops Mgr Conversant

Thank you Sarah, I know how to pull a specific task info in a project report using the collection but I wonder if there is a way to use this type of calculation in a calculated field in a project custom form. This is the text mode I used to pull the planned completion date from a task where the milestone is called "production" in a project report: displayname=Prod. listdelimiter= listmethod=nested(tasks).lists textmode=true type=iterate valueexpression=IF(IN("Production",{milestone}.{name})=true,IF(ISBLANK({actualCompletionDate})=false,'‚òë',{plannedCompletionDate})) valueformat=HTML The main reason is that with the above you cannot use the data pulled for further manipulation like sorting your report/compare this column to another column/filer etc. For ex. in the report I used the code above, I would like to sort by the production planned completion date and filter "out" any project where the task production is completed and cannot do that. I kind of address that by inserting a tick box so it is easily identifiable but not ideal (especially the fact that projects are sorted randomly). Thanks, Yannick Yannick Seifert WebMD