Connect Runn and SQL Server

Both apps 35Runn 24SQL Server 11

• Trigger
  New Assignment

  Triggers when a new assignment is created in Runn, optionally limited to one person, role or project.

• Trigger
  New Client

  Triggers when a new client is created in Runn.

• Trigger
  New Contract

  Triggers when a new contract is added to a person in Runn.

• Trigger
  New Holiday Group

  Triggers when a new holiday group is added to your Runn account.

• Trigger
  New Person

  Triggers when a new person is added in Runn.

• Trigger
  New Project

  Triggers when a new project is created in Runn.

• Trigger
  New Rate Card

  Triggers when a new rate card is created in Runn.

• Trigger
  New Role

  Triggers when a new role is created in Runn.

• Trigger
  New Skill

  Triggers when a new skill is created in Runn.

• Trigger
  New Team

  Triggers when a new team is created in Runn.

• Trigger
  New User

  Triggers when a new user is added to your Runn account.

• Action
  Assign a Manager

  Adds a Runn user as a manager of a person or placeholder, keeping any managers they already have. Returns the updated person.

• Action
  Create Assignment

  Creates an assignment that schedules a person or placeholder on a project in a role for a date range, with the same number of minutes on each working day.

• Action
  Create Client

  Creates a new client in Runn with a name and, optionally, a website and links to external systems.

• Action
  Create Contract

  Adds a new contract to a person in Runn, setting their role, dates, employment type, cost and working hours.

• Action
  Create Person

  Creates a person in Runn, along with their first contract (role, employment type, cost and working hours).

• Action
  Create Project

  Creates a project in Runn for a client, optionally setting its budget, pricing model, rate card, team and managers, or duplicating it from an existing template project.

• Action
  Create Role

  Creates a role in Runn, with optional default hourly cost, standard charge-out rate and external references.

• Action
  Create Skill

  Creates a new skill in Runn that can be assigned to people and placeholders.

• Action
  Create Timesheet (Actual)

  Records the time a person actually spent on a project for one day, creating the actual or overwriting an existing one for the same date, person, project, role and workstream.

• Action
  Find Client

  Returns Runn clients whose name contains the text you enter (case-insensitive), with each client's id, website, archived status and external references.

• Action
  Find Person

  Finds people in Runn by email, first name, last name or external id, returning every match and the first matching person.

• Action
  Find Project

  Returns the projects whose name contains the text you give (ignoring case), optionally narrowed by external ID or last-modified date.

• Action
  Find Role

  Finds roles in Runn whose name contains the text you give, ignoring case. Returns the matching roles, how many matched, and the first match.

• Trigger
  New or Updated Row

  Triggers when a new row is added or modified.

• Trigger
  New or Updated Row (Custom Query)

  Fires for each new or changed row returned by a SELECT statement you write against the connected SQL Server database.

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected SQL Server database.

• Action
  Add Row

  Add one row to a table on the connected SQL Server database.

• Action
  Delete Row

  Delete the rows in a table whose chosen column equals a value.

• Action
  Find Row

  Find the first row in a table whose chosen column matches a value.

• Action
  Find Rows via Custom Query

  Runs a SELECT statement you write against the connected SQL Server database and returns every row it matches.

• Action
  Find Row via Custom Query

  Runs a SELECT statement you write against the connected SQL Server database and returns the first row it matches.

• Action
  Run Custom Statement

  Runs a statement you write against the connected SQL Server database that changes data rather than returning rows, and reports how many rows it changed.

• Action
  Update Row

  Change column values on every row of a table whose chosen column matches a value.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.