Learn Airtable scripting #3: Running scripts in automations with Giovanni Briggs

[@danya1383]

Hi Aron and Gio! I love this and was able to understand enough about the script to re-purpose it for a learning management system that I am building. Currently I have it set up so that once a new employee enters "new" view, it triggers the automation to run a script which reads what "role" they are and then generates new training assignments in the field linked to the employee, based off of their role (templated roles table linked to associated templated training table). GREAT. I'm stuck on the next part I need to do though... I want to create a script/automation that will allow the training manager to fill out a VERY simple form that allows them to manually assign trainings from the TRAINING template (analogous to the task template table in your example). They would be able to select the employee and then from a drop down check off any of the available template trainings. I need the script to then run in the same way where instead of linking the employee to the templated task, it creates a new training assignment task from the templated task... I am new to scripting and maybe this is super simple and I'm just missing something... any suggestions on how to approach this would be greatly appreciated, as I need to have an MVP by end of Q1 :0 Thanks for all the great content!!!

[@danya1383]

TLDR, trying to create same workflow without requiring a parent table of "projects" (or in my case "employee type")

[@marcom.9328]

which software do you use for streaming and split screens?

[@theReal_WKD]

I love this series, very useful! One problem though: I don't understand the step where you take the script, copy/paste it into automations, format the original script as comments and then write some new lines of code in the newly pasted script. I mean I get that it's in order for the script to run automatically, without someone having to manually run it but why don't we do that in the first place? Why create a script, that we will copy/paste into automations and even edit on top of all that? I hope it makes sense 😅

[@AutomateAlltheThings]

hi WKD, glad you're enjoying this! Reason I'm copy pasting is that I had written the script in the previous episode and so it was easier to copy pate and adjust. You can absolutely start writing directly in the automation "run script" action!