Trying to either nest or append two values from two lists, with a shared id field

Need help Database
1

I have setup a daily digest that goes to each opted in user.

I want to list each open task created by the user, and for each task, identify what project that task is associated with.

This would look like:

  • Project 1 > Task 1
  • Project 1 > Task 2
  • Project 1 > Task 3
  • Project 2 > Task 1

So far, I have a list of tasks working:

“Search for Taskss:each item’s Task Name join with line_break”

But I cant figure out how to add the Project name, which is stored in the Project lists.

Context: Each Project and Task are linked via “Project-ID” field.

TYIA

2

You must construct the list recursively. I guess you are doing this client-side.

You search for all Projects and pass that list to a Custom Event (CE) Process Project list, that does the following:

  1. Search all Tasks of the first Project of the list
  2. Pass the Task list to a another CE Process Task list, together with Project name (text), as arguments. This CE returns a text constructed as follows
  1. Calls itself, passing the List of Projects, after removing the first item.
  2. Appends the returned text of step 3 to that of step 2, and returns.