ActiveCollab + SQL Server

Create tasks in Active Collab for new SQL Server rows from custom queries

Effortlessly manage your tasks with this SQL Server to Active Collab integration. With this workflow, whenever a new row is added to your SQL Server database based on a custom query, a new task will be created in Active Collab. This seamless connection saves time and ensures that your team can focus on completing tasks rather than manually creating them.

When this happens...
New Row (Custom Query)
Triggers when new rows are returned from a custom query that you provide. Advanced Users Only.
TriggerPolling
automatically do this!
Create Task
Creates a task.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

- Table/ViewRequired
Trigger
Polling
Try It
- QueryRequired
Trigger
Polling
Try It
- Table/ViewRequired
- Primary KeyRequired
- Order ByRequired
- Trigger Column
Trigger
Polling
Try It
- Disclaimer Copy
- QueryRequired
Action
Write
- TableRequired
- ID ColumnRequired
Action
Write

- QueryRequired
Action
Search
New Comment
Triggers when a comment is added to an object in Active Collab.
Trigger
Instant
Try It

New Task
Triggers when a new task is created.
Trigger
Instant
Try It
New Task List
Triggers when a new task list is created in a project in Active Collab.
Trigger
Instant
Try It
Time Tracked
User has tracked time on project or task.
Trigger
Instant
Try It
- Company NameRequired
Action
Write
- Task IDRequired
Action
Write
- ProjectRequired
- Task ListRequired
- Task NameRequired
- Task Body
Action
Write
- ProjectRequired
- DiscussionRequired
- Comment BodyRequired
Action
Write

- Table/ViewRequired
- Order By
- Dedupe Key
Trigger
Polling
Try It
New Table
Triggers when you add a new table.
Trigger
Polling
Try It
- QueryRequired
Trigger
Polling
Try It
- TableRequired
Action
Write
- TableRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- QueryRequired
Action
Search
New Project
Triggers when new project is created.
Trigger
Instant
Try It
Task Closed
Triggers when a task is closed in Active Collab.
Trigger
Instant
Try It
Task Moved
Triggers when a task is moved to another task list.
Trigger
Instant
Try It
- ProjectRequired
- TaskRequired
- Comment BodyRequired
Action
Write
- Project IDRequired
Action
Write
- Project NameRequired
Action
Write
- ProjectRequired
- Discussion TitleRequired
- Discussion Description
Action
Write
- Select ProjectsRequired
- User EmailsRequired
- Member TypeRequired
Action
Write