Pulling custom form data from issue to the project template | Community
Skip to main content
M
MichaelaDi1
New Member
October 22, 2025
Solved

Pulling custom form data from issue to the project template

  • October 22, 2025
  • 2 replies
  • 186 views

I'm new to Fusion and one of the quick wins we've identified is pulling the overall deliverable due date custom field in the issue into the project template. The goal is for the last task due date which is release final files automatically aligns with the overall due date set by the client in their request. Is this even possible and if so, what happens to the tasks if the time allotted doesn't align with the template? Any insights would be helpful to the possibility, concerns and even how to start setting this up as a scenario. Thanks in advance!

Best answer by Patrick-antegma

Hi ​@MichaelaDi1,

 

I would use the module “Workfront - Watch Events” and listen to Create and Update events of issues. You can also add a filter for template, portfolio, program here to get only relevant events.

 

Then I use the projectID of the incoming issue event and search for the issue with the biggest due date in the custom form. 

 

Let’s say issue custom form has custom fields: myCustomDueDate. The technical name would be DE:myCustomDueDate.

 

Use the module “Workfront - Custom API Call” (because the normal Workfront Search module can’t really order elements which want to do) and use the path “/optask/search” and as query parameters:

 

projectID: <project ID from the new state of the incoming create or update issue event>

DE:myCustomDueDate_Sort=DESC  // Gives you the latest date

DE:myCustomDueDate_Mod=notnull // That issues without due date are ignored

fields: id,DE:myCustomDueDate // returned fields

$$LIMIT: 1 // Only returns 1 item in the results.

 

Here is the API spec: https://developer.workfront.com/issues.html#get-/optask/search

 

Use the module “Workfront - Update Record” to set the value of the DE:myCustomDueDate into the custom field on the project.

 

 

Check also the following docs for more details:

https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/report-elements/filter-condition-modifiers

https://experienceleague.adobe.com/en/docs/workfront/using/adobe-workfront-api/api-general-information/api-basics#retrieving-objects

https://experienceleague.adobe.com/en/docs/workfront/using/adobe-workfront-api/api-general-information/api-basics#sorting-query-results-in-the-api

2 replies

kautuk_sahni
Community Manager
kautuk_sahniCommunity Manager
Community Manager
February 2, 2026

 ​@Lyndsy-Denk ​@Richard_Carlson ​@VicSellers ​@Doug_Den_Hoed_AtAppStore ​@monicacardoso ​@Ross_Barton 

Sharing this with you in case you’d like to provide any guidance or best practices. Your expertise would be invaluable, thank you!

Kautuk Sahni
Patrick-antegma
Patrick-antegmaAccepted solution
Level 4
February 3, 2026

Hi ​@MichaelaDi1,

 

I would use the module “Workfront - Watch Events” and listen to Create and Update events of issues. You can also add a filter for template, portfolio, program here to get only relevant events.

 

Then I use the projectID of the incoming issue event and search for the issue with the biggest due date in the custom form. 

 

Let’s say issue custom form has custom fields: myCustomDueDate. The technical name would be DE:myCustomDueDate.

 

Use the module “Workfront - Custom API Call” (because the normal Workfront Search module can’t really order elements which want to do) and use the path “/optask/search” and as query parameters:

 

projectID: <project ID from the new state of the incoming create or update issue event>

DE:myCustomDueDate_Sort=DESC  // Gives you the latest date

DE:myCustomDueDate_Mod=notnull // That issues without due date are ignored

fields: id,DE:myCustomDueDate // returned fields

$$LIMIT: 1 // Only returns 1 item in the results.

 

Here is the API spec: https://developer.workfront.com/issues.html#get-/optask/search

 

Use the module “Workfront - Update Record” to set the value of the DE:myCustomDueDate into the custom field on the project.

 

 

Check also the following docs for more details:

https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/report-elements/filter-condition-modifiers

https://experienceleague.adobe.com/en/docs/workfront/using/adobe-workfront-api/api-general-information/api-basics#retrieving-objects

https://experienceleague.adobe.com/en/docs/workfront/using/adobe-workfront-api/api-general-information/api-basics#sorting-query-results-in-the-api

    Terms & ConditionsAccessibility statement

    Loading footer...