Connect Clust and SQL Server

Both apps 45Clust 34SQL Server 11

• Trigger
  New Application Closed

  Triggers when an application is closed.

• Trigger
  New Application Created

  Triggers when a new application is created.

• Trigger
  New Application Late

  Triggers when an application passes its deadline.

• Trigger
  New Application Progress Stage Changed

  Triggers when an application moves to a different stage.

• Trigger
  New Application Submitted

  Triggers when an application is submitted.

• Trigger
  New Contact

  Triggers when a contact is created.

• Trigger
  New or Updated Application

  Triggers when an application is created or changed.

• Trigger
  New or Updated Application Item

  Triggers when an item of the chosen application is added or changes status (submitted, approved, completed).

• Action
  Approve Application Item

  Approves an application item.

• Action
  Assign a New Stakeholder to Role

  Adds a stakeholder to a role on an existing application.

• Action
  Close Application

  Closes an application.

• Action
  Create Application

  Creates an application from a template and invites the contact to fill it in.

• Action
  Create Company

  Creates a company.

• Action
  Create Contact

  Creates a contact.

• Action
  Create Tag

  Creates a tag.

• Action
  Delete Application

  Deletes an application.

• Action
  Delete Contact

  Deletes a contact.

• Action
  Find Applications

  Returns applications matching a status, contact email, external ID or keyword.

• Action
  Find Companies

  Returns companies matching a keyword.

• Action
  Find Contacts

  Returns contacts matching an email or keyword.

• Action
  Get Application

  Returns one application by ID.

• Action
  Get Application Item

  Returns one application item with its content.

• Action
  Get Company

  Returns one company by ID.

• Action
  Get Contact

  Returns one contact by ID.

• Action
  Get Template

  Returns one application template by ID.

• Action
  List Application Items

  Returns the items (documents, forms, tasks) of an application.

• Action
  List Tags

  Returns the team's tags.

• Action
  List Team Members

  Returns the team's users.

• Action
  List Templates

  Returns the application templates.

• Action
  Reopen Application

  Reopens a closed application.

• Action
  Submit Application

  Submits an application on the client's behalf.

• Action
  Update Application

  Updates an application's title, stage, deadline, external ID or contact details.

• Action
  Update Contact

  Updates a contact.

• Action
  Update Form Field

  Sets the answer of one field in a form item of an application.

• 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.