Creating Tasks from a Template

Creator: Victoria Plummer

If you have a standard tasks list that you use for each event, project, etc., you can automatically add that task list to each new event that is added to your table. Using the scripting block, you can choose which events you want to apply this template of tasks to.

See the original source for an example of this scrip as well as an example Airtable Universe base using the script.

Source Code

							
							// pick tables from your base here
let checklist = base.getTable('Planning Check List')
let templateView = base.getTable('Planning Check List').getView('Template View');
let templateQuery = await templateView.selectRecordsAsync();
let templateRecords = templateQuery.records;
let noChecklist = base.getTable('Projects').getView('No Checklist');

// Select Event to Create Checklist
let selectedEvent = await input.recordAsync('Choose Event to Create Checklist',noChecklist);

// create the tasks
let createRecords = templateRecords.map( c => ({fields: {

        'Name': c.getCellValue('Name'),
        'Project': [selectedEvent],
        'Days Out': c.getCellValue('Days Out'),

}})
);

if(selectedEvent)await checklist.createRecordsAsync(createRecords)
else output.markdown("# Uh-Oh You didn't select an event!")

output.text('Done!');