How To Capture Queue Topic Of The Request On The Project's Custom Form | Community
Skip to main content
imgrund
Adobe Employee
imgrundAdobe Employee
Adobe Employee
July 13, 2021
Solved

How To Capture Queue Topic Of The Request On The Project's Custom Form

  • July 13, 2021
  • 3 replies
  • 3701 views

Hi - I know someone posted about this before, but I'm having issues trying to find it :(

I'm looking to capture the Queue Topic of the Request on the Project's custom form so I can use it for some task reporting someone needs.

Anyone remember how to do that?

I can get a calculated field on the request that will capture that info, but then how would that transfer to the project when converted?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by imgrund

    Hi Everyone - figured it out!!

    So, on the issue, I have a calculated field called Request Type and the calculation is Queue Topic.Name

    Then on the Project, I have put the Request Type field on the custom form, but the calculation is just Request Type

    (I know, it is a little weird, but it works beautifully!!)

    NOTE: This is not retroactive. This only works at the moment of conversion from issue to project.

    3 replies

    imgrund
    Adobe Employee
    imgrundAdobe EmployeeAuthorAccepted solution
    Adobe Employee
    July 14, 2021

    Hi Everyone - figured it out!!

    So, on the issue, I have a calculated field called Request Type and the calculation is Queue Topic.Name

    Then on the Project, I have put the Request Type field on the custom form, but the calculation is just Request Type

    (I know, it is a little weird, but it works beautifully!!)

    NOTE: This is not retroactive. This only works at the moment of conversion from issue to project.

      M
      MichelleMc6
      Level 3
      November 1, 2021

      Hi, Anthony

      I came across this post and I think it's getting me closer to what I'm trying to do but still need help. I'm trying to create a custom project code that includes the year + Workfront project ID + queue topic from the request queue the original request came from. So, right now I have

      CONCAT(RIGHT(YEAR(Entry Date),2),"-",Reference Number)

      in a calculated field on a project report to pull in the first two components. How do I get the queue topic from the originating request queue to append to the end of that?? So, we'd have

      21-123456-queue topic

      And, to add even more complexity, if we could determine the queue topic and assign a 2 or 3-digit code to each rather than show the whole name.

      Any guidance would be appreciated.

      Thanks,

      Michelle

      kynabaker16
      Adobe Employee
      kynabaker16Adobe Employee
      Adobe Employee
      July 15, 2021

      Thank you for sharing, Anthony!! I'm sure this will come in handy to people!

      S
      SubhashSa
      July 15, 2021

      It dose not work for me -- The calculation "Request Type " Does not give error but on project it is just blank

      imgrund
      Adobe Employee
      imgrundAdobe EmployeeAuthor
      Adobe Employee
      July 15, 2021

      Just to confirm, Did Request Type have data on the request before you converted it into a project?

        N
        nryan2
        Level 3
        July 16, 2021

        Is there any way to do this without converting the issue to a project? I have information on a issue created in a project that I'd like to transfer to the project level (or task level) for reporting.

        imgrund
        Adobe Employee
        imgrundAdobe EmployeeAuthor
        Adobe Employee
        July 16, 2021

        Not in a calculated field as I don't think you can do collections for that. But you might be able to do it on a report in a custom column. Is the info you are trying to grab only on the tasks you want? Or is there some other attribute that we could "filter" on?

        N
        nryan2
        Level 3
        July 16, 2021
        What I’m really trying to do is get the request reference number and one custom date field that is on the request custom form to display on an assignment report. I don’t think it is possible because they are not related except at the project level but your post gave me a glimmer of hope. Additional details: the user is not assigned to the request, and the request is submitted on the project.
        Terms & ConditionsAccessibility statement

        Loading footer...