Connect Salesmsg and SQL Server

Both apps 25Salesmsg 14SQL Server 11

• Trigger
  Contact Updated

  Triggers when a contact in Salesmsg is created or updated.

• Trigger
  Missed Incoming Phone Call

  Triggers when an incoming phone call to your Salesmsg number is missed.

• Trigger
  New Contact

  Triggers when a new contact is created in Salesmsg.

• Trigger
  New Contact Opted-Out

  Triggers when a contact in Salesmsg is opted out of text messaging.

• Trigger
  New Phone Call Received

  Triggers when a new incoming phone call is logged in Salesmsg call history.

• Action
  Add Tag to Contact

  Adds an existing tag to a Salesmsg contact.

• Action
  Create Note

  Creates a note on a Salesmsg contact.

• Action
  Create or Update Contact

  Creates a Salesmsg contact for a phone number, or returns the existing contact with that number, setting name and email.

• Action
  Find Contact

  Finds contacts whose name, email or phone number matches a search term.

• Action
  Find Salesmsg Member

  Searches the members of your Salesmsg organization by name or email and returns the matches.

• Action
  Opt-Out a Contact

  Opts out a Salesmsg contact so they no longer receive messages from your local and toll-free numbers. Returns the updated contact.

• Action
  Phone Number Lookup (PhoneCheckr)

  Looks up a phone number and returns its formatted form, country, carrier and line type.

• Action
  Remove Tag From Contact

  Removes a tag from a Salesmsg contact.

• Action
  Send a Text Message (SMS / MMS)

  Sends an SMS or MMS text message to a phone number from one of your Salesmsg inboxes.

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