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

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

  • July 13, 2021
  • 3 Antworten
  • 3701 Ansichten

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?

    Dieses Thema wurde für Antworten geschlossen.
    Beste Antwort von 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 Antworten

    imgrund
    Adobe Employee
    imgrundAdobe EmployeeAutorAntwort
    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

      S
      SubhashSa
      July 16, 2021

      I GOT is now -- The solution is life saver -- for people like me who might miss out on details --

      • The issue form can not be copied as it is
      • Create issue form with out the queue detail first
      • Copy the issue form to project form
      • Now add the field with Name say "ABC"-- in the above example Antony used name " Request Type"
      • On project form the now add the field from library
      • By default the calculation will be blank add the formula {ABC}
        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 EmployeeAutor
        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.
        Allgemeine NutzungsbedingungenAccessibility statement

        Loading footer...