Workato / Wrike Integrate | Setting task data based on ancestor folder
Expected result:
I have a recipe based on a previously made recipe from the Community Library that traverses from a new/updated task up through its ancestor folders. Once it reaches a folder that has a specific Custom Field, and that field contains a value, it is then assigned to the same field in the given task.
The problem(s):
- It will get to a folder that is "Logical Folder" and outputs an error.
- More than one folder is usually assigned to a task (or, a task is assigned to multiple folders. Semantics, but maybe more correct).
Now, these two things are quite different and will require different solutions. I'm not really that concerned about the Logical Folder issue; I intend to set a "Handle Error" action output the result in Google spreadsheet. That way I have a log of events, if necessary.
I am more concerned about the task being assigned to multiple folders. The expected result detailed in the first part is reliant upon a Custom Field that links to a Datahub table. Once that field is filled out on the task, the row that the value is part of will populate remaining fields in the task. My concern is the possibility that more than one folder with that field could be applied, thus one folder's value would end up overriding the other. This is what I need a solution for.
Possible Solutions I'll be testing:
- Another Custom Field to hold the folder id of the desired folder.
- Stop the recipe after the first succesful folder and just end the job there.
If anyone has run into this or a similar use case, I'd be glad to hear your solutions. Thanks in advance.
Correct, your solution should be the right way for this case.
- Another Custom Field to hold the folder id of the desired folder.
--> If it doesn't matter as long as you find an ancestor folder contains a value for the CF, you don't need to create another CF, but if there is some business logic that only the correct value from the CF should be used, then probably you need to create another CF as an attribute for addtional info of the folder for you to determine if the correct ancestor folder is located.
- Stop the recipe after the first succesful folder and just end the job there.
--> Only stop when you find the correct ancestor folder depends on your answer above.