Jan 07, 2021 12:42 PM
Hello out there, I am not experienced in writing code and I am hoping that someone can help me make a workflow dream come true! I’ll do my best to explain what the goal is below, but please let me know if it is unclear.
In my Program Management base, I recently followed this example to add tasks from a Task Template table to specific projects, just copying/pasting the code: https://www.airscript.dev/2020/10/04/generating-tasks-for-projects
The code copies every task from the Task Template table into the project. What I am hoping for help with is: We have several different project types, each that involves its own set of tasks. Is there a way for me to add to the above code so that I can pick a specific set of tasks in the Task Template table, based on an identifier? Currently, to separate out which project types that tasks are associated with in the Task Template table, I have a ‘multiple select’ field that includes types like Solo Exhibition, Juried Exhibition, Traveling Exhibition, etc. I chose multiple select because there are some tasks that fall under multiple project types. Ideally, this would be the situation:
I’m hoping to avoid going the way of a Zapier integration, so thank you in advance for any guidance on this!
Jan 08, 2021 08:21 PM
Further to my initial message, I did figure out how to take care of this part in the app:
** The code will know which ‘project type’ the project is… let’s say that the “Super Cool Art Show” project in the Project table is a Curated Exhibition project type. Maybe the output says “you have selected Super Cool Art Show, which is a Curated Exhibition”*
Very eager for someone to help with the other part. :grinning_face_with_big_eyes: