This recipe turns a status change into a set of tasks. A loop (a group of actions that repeats once for each record in a list) creates one task for every record in your onboarding checklist. It's meant to make sure every new hire gets the same start, without copying tasks by hand.
What you'll need
A
Candidatesdatabase app with aNametext field and aStatusfield with the optionHired.An
Onboarding checklistdatabase app. Each record is one step, with aTitlesuch as "Order laptop" or "Create email account".A
Tasksdatabase app withTitle,Status(withTo do), andDue date.
Build the automation
Open the
Candidatesapp on desktop or web and click the automations icon in the top bar (tooltipCreate and view automations).Select
New automation, then selectWhen a record is updated.In the trigger, select the field name. Tape preselects one of the app's fields. Select
StatusunderFIELDS, then select the preselected field again to remove it.Under
And if the following conditions are met, selectAdd filter. PickStatus, thenHas changed to, thenHired.Select
Add action→Search for records. Choose theOnboarding checklistapp and leave the filter empty to get every step.Select
Add action→Loop actions. Underfor each, select the records fromSearch for records.Inside the loop, select
Add action→Create record. Choose theTasksapp.The step already has the required rows
TitleandStatus. InTitle, keepSet value, enter "Onboarding: ", insert the checklist step'sTitle, enter " for ", and insert the candidate'sName.In
Status, chooseTo do. SelectAdd fieldto addDue date. It comes withSet dateandCurrent date. Set the offset to7 Days.Select
Create automation.
Note:
Set the status once.
Has changed tomakes the automation run once, when the status changes. Moving a candidate back and forth creates the tasks again.A search returns at most 1,000 records. A run also stops after three minutes, so keep the checklist short.
Each created record counts as an action. Each
Create recordin the loop counts as an action, and a run can use at most 1,000 actions.
The result
When you set a candidate to Hired, one task per checklist step appears in Tasks, for example "Onboarding: Order laptop for Juliet Adams", each due in a week.
Variations
Filter the search by a
Rolefield so engineers and sales hires get different checklists.Add a
Send emailstep after the loop to tell the hiring manager that the tasks were created.Add an
Assigneeperson field to the checklist and copy it to each task.
Learn more
FAQs
Can I loop over a number instead of a list of records?
Can I loop over a number instead of a list of records?
Yes! Use a script to turn the number into a list, then loop over it. Learn how to create several records from a number →
Why did the loop create no tasks?
Why did the loop create no tasks?
If no tasks appeared, it could be because:
The search found no records. Check the filter and the app you chose.
The
for eachsetting is empty. Without a list to loop over, the actions inside the loop don't run.
Are you a developer using the Tape API for automations?
Are you a developer using the Tape API for automations?
The automation API has its own documentation for developers. Full reference: for_loop in the developer docs →
Still have questions? Find answers and get help from community experts in the Tape community →
