is there a way to auto assign tasks according to a single select field.
I have a single select with multible Teams (CRM, Website, Social Media etc.). I want a new record to be auto assigned to the team lead of the team from the single select field. New records will be created with a form.
I assume there's another table where the link between the Team Lead and the Team exists? Perhaps a table where each record represents a single team with a field for the team lead?
If so, try creating an automation that'll trigger when the form is submitted, and its action will be to look for the appropriate "Team" record based on the option selected from the single select field. You can then use the result of that Find Record action in an "Update Record" action to assign that Team Lead to the task
I assume there's another table where the link between the Team Lead and the Team exists? Perhaps a table where each record represents a single team with a field for the team lead?
If so, try creating an automation that'll trigger when the form is submitted, and its action will be to look for the appropriate "Team" record based on the option selected from the single select field. You can then use the result of that Find Record action in an "Update Record" action to assign that Team Lead to the task
