Adobe Workfront Fusion

I'm currently working on a project that requires incrementing an alphanumeric-based string using Fusion, but I'm struggling to determine how to make this happen using Fusion's text tools. Specifically, I need to read a record with either an ONLY numeric string (e.g. 12345) and append an alpha character at the end (e.g. A), or I need to read that same string with the alpha character at the end, and increment by one letter (e.g. 12345A -> 12345B). Any ideas or insight is apprecaited!

We have lots of scenarios. And, we have lots of data stores. I'm doing housekeeping, and know there are at least some data stores that we no longer need. I'm wondering how one would go about discovering/confirming which scenarios (if any) would be impacted by removing a data store?Similar to seeing which scenario is using a webhook, but for data stores. I have a sick feeling there is no way to do this without manually inspecting every scenario.

We use snowflake as a data store for campaign data shared across multiple tools. Now that we adding a group to our existing instance of WF, there is a need to use Fusion to regularly send data to Snowflake. Has anyone done this before? Any trouble with the integration? Thanks!

I can't find a way to round a number to a specific number of decimals. So e.g. 3.14159 to 3.1416 or 3.14 I'm surely missing something. Any ideas where to find that function?

I'm using a WF module to read data from a CSV file. On occasion there are errors in the data in the file so the WF Module will fail. I add an ignore module from the Tools to keep the WF module to continue processing the remaining data. The ideal thing would be to have the entry of data be accurate so this does not occur, however that's wishful thinking. The problem is I would also like to know when an error occurs. The Ignore module does not provide the capability to connect to a WF module for notification. Is there a way to do what I'm asking in Fusion?

Happy New Year!! I have a scenario where I am connecting to HR data to search for terminated users and deactivate them in WF. The process itself is very simple, but I am running into an issue with the 2000 maximum search limit. We have over 2000 users, so basically the functionality works, but only for the first 2000 users. I am guessing I am missing something silly that will allow me to search all users, but I am not sure what I am missing. Use Case:Pull all HR user records and then search WF for user records that do not match and deactivating those users. Thanks!!

My company is interested in connecting WF and SP, more specifically, would like to have a ticking system on our SP page. Would the connection allow us to set up Requests that someone could put into SP and it be automatically put into a request queue in WF?

Hi, I'm looking for a way in Fusion to swap the special characters in a string (e.g. Cédric Genzić) for the base versions (= Cedric Genzic). Any ideas?

I am trying to build a scenario that will collect stage approvals from a task approval process after final stage approval, create a document with the stage approval, and then upload to the task. Scenario setup: I am watching updated tasks to see when Task approval workflows are complete. From there I am collecting more task data, owner data, and assignee data. Then I create a record to update to add a note and change the status from "In Progress" to "Approved". I'd like to capture the approvers from each stage and the start/completion dates for an audit report that would be created/uploaded to the task. Has anybody created a similar solution?

My scenario has a router that splits into two routes. One is the fallback (although having no fallback but mutually exclusive filters makes no difference). The routing is based on the existence of a form on a project. Two bundles travel through the scenario. The first bundle spots the form is in place and moves on to the end. The route includes a couple of text aggregators. The second bundle takes the same route because the form is in place (same project) and it runs the route it should but this time it also jumps onto the other route and runs one of the two text aggregators, skipping the first couple of modules on that alternate path. The second path has never fired so I cannot see why this should happen. I've attached a picture showing this. The scenario is trying to gather document approval details (approvers, statuses & dates) and paste the lot into a custom form on the project the tasks that hold the document being approved sit. Thanks v much

Forgive me for all my rookie questions.... 😜 I am attempting to use WF data to update a spreadsheet that lives in a Box folder. I got the file ID and file Name filled in, but what do I use for the "data" field. How do I tell the module which rows and columns to update in the spreadsheet?

The link below explains how to retrieve an image URL, put it into the object URL, and pull it into a report as a thumbnail. Is there a way to do this using Fusion? It's far too manual to do for hundreds of requests. https://one.workfront.com/s/document-item?bundleId=the-new-workfront-experience&topicId=Content%2FReports_and_Dashboards%2FReports%2FCustom_View_Filter_Grouping_Samples%2Fview-display-image-in-view.htm&_LANG=enus

Is it possible to use a date wildcard in Fusion. For instance, if I wanted change the planned start date of a task to 3 days from today, or maybe backdate a project start date to last week? Can we use the date/time functions to do this?

I have a scenario that uses a create record module to post an update to an issue that is awaiting approval to remind the approver they have a past due approval. I would like to make some words bold, italic, etc. I've tried rtf code, bb code and html tags. None work. If I create some text in an rtf text editor and paste it in, it holds the formatting though. Are there codes I can type in to the update test box to format the update?

Does anyone know how to create hyperlinked text in Fusion? My goal is to send an email with a link to a newly created Task. It would be something like Task: New Task Name (New Task Name would be a string from a form that becomes the task name) ... where the hyperlink is something like: https://instance.my.workfront.com/task/[FUSION TASK ID VARIABLE]/overview I can create the text of the link. I have that down. But how do I make use it to encode a hyperlink? Worst case, how can I make the link itself clickable, if I can't encode the Task Name?(ex. https://instance.my.workfront.com/task/[FUSION TASK ID VARIABLE]/overview)

I have a scenario that looks for changed field value "Job Number" and then adds it to the beginning of the Project Name resulting in "ABC123456 Name Of Project". All good. But if a user changes the job number later on, I end up with "XYZ456789 ABC123456 Name Of Project". It adds the new job number without deleting the old one. I added a router and a filter "if oldTextVal=notExists" then concat the job Number & Name. And another path that says "if oldtextVal=Exists" then... here I would like to undo the original concatenation by reverting the job name to the "old state" before concatenating the new job number with the original job name. I can't figure out a way to get the old job name before the job number was added. I can't do "oldTextVal" without another field watch and it won't let me watch 2 fields in one scenario. Any ideas?

Where do we add the IGNORE module in a particular flow? Does it matter where?

This seems like something Fusion should be able to do, but I'm pretty new to the tool and haven't been able to figure it out. I know there are apps that let you create baselines on a recurring basis, but can Fusion do this?

I have a working solution that I am looking to simplify or make more efficient. There are times that a module will return a single record (Project) either through a Search Record module or a Custom API call module. In this example, I'm using both: a Custom API call so I can include parameterValues in the fields list; followed by a Search Record (for the same project) where I map the parameterValues collection that was returned in the response of the API call to the Outputs field of the Search Record module. This creates a dynamic way to pull in all of a project's custom data in the Search Record module without having to hard code the output selections. In this example, the record that is returned is a single bundle, and that bundle is a list of items (name, ID, DE:this, DE:that). What I need to do is iterate through that list of items, not knowing in advance which DE:fields may or may not be in the list. (I'm using contains on the name to determine if actions should or sho

I'm not sure if this is possible or not, but I was wondering... Can you block/stop a notification from sending when a action is executed in Fusion that prompts a email notification by default?Use case:I have an automation running that, if the project owner job role matches the task assigned to job role, it auto-populates with that owner's name. This works great at project creation because the status is in planning and no notifications are sent. However, when the project is already in current, and the owner attaches a new template with tasks that match their job role, they get emails to alert them of the assignment. Not a big deal, but pretty annoying, right? Can I stop those notifications? Something like, if the assigned to ID matches the owner ID, then don't send a notification. I highly doubt this can be done without just turning off the notifications completely, but I will be interested to hear if anybody may have a clever way around this. Thanks guys!

Hello, We are facing a challenge around the complexity of work and as we were working through this problem, I thought that asking the phenomenal brain power in this group could also shed some light or thoughts on this problem. It is also a good Friday-style thinking problem (maybe that is just me). The problem statement is seemingly simple on the surface: Generate a list of tasks with cross-project predecessors and determine the impact of changes when one or more tasks change across projects. Now, it does not appear that you can access the predecessor tables directly in fusion or in a custom API call as they are linked to tasks themselves. And when you are building a report in standard Workfront, this is a perfect use case for the EXISTS filter whereby you can at least get a list of tasks that have a cross-project predecessor relationship. The challenge with that is that EXISTS filters are not available in the API. For clarification of thought, here is the textmode filter to get th

The app reference guide on Fusion's page lists a good amount of apps that I do not have access to in my scenarios. This may be a dumb question, but why can I not access all the apps listed on this page?https://learn.fusion.workfront.com/connector-reference/

Hey guys! The use case here is pretty straight forward. We want to have any new updates or uploaded documents on the issue automatically move or copy to the resolve project. I am probably over engineering this because I am running into a myriad of problems when trying to do this. Here are a few I cannot get passed: The Filters. - I only want the resolve project to update with issue data (comments and documents) if it is brand new, not anything that previously existed. I think just a simple entry date filter may suffice. IF entry date = $$today, then pass through. How do you use a date wild card in Fusion?Copying Issue Notes to the Resolve Project. - I have tried using a update record and a create record module. Both of these just seem to duplicate the updates on the issue and they don't push to the resolve project. Does this have to be a custom API module or am I just missing something on one of these modules?The use of iterators causes the updates to run multiple times. - This may

Hello all I have a scenario that starts with an instant watch for new document versions being created. It gathers Version ID, Document ID, name etc. The next module gathers document-level data. The trigger runs ok and the version and document IDs are shown in the execution inspector but the second module fails saying the document ID doesn't exist. Also, when I use the document id shown in the execution inspector and search for that in Workfront, it's not found but when I use the document name from the trigger module, it is found, but it has a different document id to that shown in the execution inspector of the trigger module. My mapping of the document id from the trigger module to the read module is correct so I'm a bit stumped. Does Workfront do something odd with document ids in the background? Thanks v much Stuart Cairns

Hi Everyone I am trying to set up a Watch Events trigger pointed at Document Version. When I try to save this I'm getting an error : "The request failed due to failure of a previous request. > Function 'constructWatchFilterParameters' finished with error! Cannot read property 'O’ of undefined" Any ideas, anyone? I don't know if this is a product failure or what. Thanks v muchStuart Cairns