Connect OnePageCRM and SQL Server

Both apps 31OnePageCRM 20SQL Server 11

• Trigger
  Closed Sales Cycle

  Triggered when a sales cycle is closed — a deal is marked won or lost.

• Trigger
  Completed Next Action

  Triggered when a next action is marked done in OnePageCRM.

• Trigger
  New Call

  Triggered when a phone call is logged in OnePageCRM.

• Trigger
  New Contact

  Triggered when a new contact is created in OnePageCRM.

• Trigger
  New Deal

  Triggered when a new deal is created in OnePageCRM.

• Trigger
  New Next Action

  Triggered when a new next action is created in OnePageCRM.

• Trigger
  New Note

  Triggered when a new note is added to a contact in OnePageCRM.

• Trigger
  Updated Contact

  Triggered when a contact is created or changed in OnePageCRM.

• Trigger
  Updated Deal

  Triggered when a deal is created or changed in OnePageCRM.

• Action
  Close Sales Cycle

  Closes a deal in OnePageCRM by marking the sales cycle won or lost, with an optional close date and note.

• Action
  Create Call

  Logs a phone call against a contact in OnePageCRM, with notes, the number dialed, the outcome and an optional recording link.

• Action
  Create Contact

  Creates a contact in OnePageCRM, including your account's own custom fields.

• Action
  Create Deal

  Creates a deal against a contact in OnePageCRM, with an amount, expected close date and notes.

• Action
  Create Next Action

  Adds a next action (a to-do) against a contact in OnePageCRM, with an optional due date and assignee.

• Action
  Create Note

  Adds a note to a contact's timeline in OnePageCRM.

• Action
  Find Contact

  Finds a contact in OnePageCRM by email address, or by searching names and companies, and returns the first match plus every match.

• Action
  Find Deal

  Finds a deal in OnePageCRM by contact, status or name, and returns the first match plus every match.

• Action
  Find User

  Finds a user in your OnePageCRM account by email address or name, and returns the first match plus every match.

• Action
  Update Contact

  Updates a contact in OnePageCRM, including your account's own custom fields. Anything you leave blank keeps its current value.

• Action
  Update Deal

  Updates a deal in OnePageCRM. Anything you leave blank keeps its current value.

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