Creating a Fusion Scenario that acts like Bulk Assignments

[OmahaOmaha]

I'm in the middle of creating a fusion scenario that acts like the bulk assignments tool that you would find in the workload balancer.  However, we want to build a scenario that updates all of the correlating task assignments based on a typeahead field found on a project level form. Once the project level typeahead field is filled out, the correlating task assignments in the project would update with that users name, wherever the associated job role would appear.  The issue I'm running into is how to connect the project level typeahead field to those task assignment roles. Any assistance would be greatly appreciated.

[ChristinaJay]

The way we did it which was messy was:

#1 Typeheard_Role_Assignment field on the project. (A)

then

#2 Calculated field User ID of #1 on the project 

then

#3 Calculated field equal to #2 on a task form

then

#4 have it reference the task assignment to the calculated field. 

I know there's a reference in there the fusion data structure that 

Role Name = Role ID

then

#5 for Role ID xyz use UserID etc. 

[OmahaOmaha]

this portion throughs me off:

#2 Calculated field User ID of #1 on the project 

then

#3 Calculated field equal to #2 on a task form

Are you saying that I need to create a calculated field on both the project and task level that captures the results of the #1  typeahead field?

[ChristinaJay]

There may be an easier way to do it, but the reason for the calculated field on the task is because I wasn't able to reference the project's typehead value from the task without it being a calculated field. 

[OmahaOmaha]

Hi Christina,  I tried both using a typeahead field from the project level and a calculated field from the project level. When I referenced either one on a task level calculated field I got "N/A" as my result.  Did you have a similar issue? If so, how did you workaround it?

[JimBr1]

I just completed a scenario that does a similar action.

Overview of senario function:

I use a Webhook to monitor a flag I can set on a custom form to trigger my event, 'Update Task Assignments'

The scenario then looks at 8 type ahead fields I have on the form to determine the user ID via a JSON function

With that user ID I can derive their role ID

A search of tasks with on the project will expose those tasks that have an assignment with that role

Once I have a list of tasks, I iterate again looking for specific assignments with that role 

Once the assignments are identified, I use the update (assignment) module to add my user ID to the specific assignment

I will say its a bit slow as the number of tasks and their assignments can produce a pretty large number of items to iterate thru - but it does work.

[OmahaOmaha]

Jim do you have a blue print of this scenario you created to review?

[JimBr1]

I'm sure it could be optimized a good bit - but it works - let me know if you have any questions

[OmahaOmaha]

Hi @JimBr1 thanks for the feedback. I do have one question though, with regards to the Clear Variables module I keep getting the following error and I'm not sure why:

Validation failed for 1 parameter(s).

• Missing value of required parameter 'name'.