How to automatically populate each row in a project tracker with repeating tasks?

1

I have a project tracker that will have several hundred items going.

Each item has 4 steps, and the steps are the same each time. Using the Project Tracker with Tasks template, how can I autofill the tasks for each item instead of copying and pasting hundreds of times?

image
image968×439 35.3 KB

It would be really helpful to be able to track each item’s progress.

1 Like
2

Hi Irene,

Welcome to the community!

You need to create a button in the project table with the following formula:

TasksTemplates.ForEach(
  Tasks.AddRow(
    Tasks.Name, CurrentValue.Name,
    Tasks.Project, thisRow
  )
)

This means → For each template create a task based on that template and assign the current project

Then you can create another button, that presses all the buttons in your projects tables.
RunActions(Projects.[Create tasks])

You could skip having buttons in the project tables and have all the logic in the single button, but to get started it’s easier to understand like this.

Here you have a little demo, feel free to check the formulas and how the tables are connected.

Hope this helps,

Pablo

5 Likes