Connect Altoviz and SQL Server

Both apps 35Altoviz 24SQL Server 11

• Trigger
  Contact

  Triggers when a contact is created, updated or deleted.

• Trigger
  Customer

  Triggers when a customer is created, updated or deleted.

• Trigger
  Product

  Triggers when a product is created, updated or deleted.

• Action
  Create Contact

  Creates a new contact.

• Action
  Create Customer Family

  Creates a new customer family.

• Action
  Create Draft Sales Invoice

  Creates a new draft sales invoice.

• Action
  Create Product Family

  Creates a new product family.

• Action
  Create Receipt

  Creates a new receipt.

• Action
  Create Sales Credit

  Creates a new sales credit.

• Action
  Create Sales Quote

  Creates a new sales quote.

• Action
  Create Supplier

  Creates a new supplier.

• Action
  Delete Contact

  Delete an existing contact.

• Action
  Delete Customer

  Delete an existing customer.

• Action
  Delete Receipt

  Delete an existing receipt.

• Action
  Delete Sales Credit

  Delete an existing sales credit.

• Action
  Delete Sales Invoice

  Delete an existing draft sales invoice.

• Action
  Delete Sales Quote

  Delete an existing sales quote.

• Action
  Delete Supplier

  Delete an existing supplier.

• Action
  Download Purchase Invoice

  Download a purchase invoice.

• Action
  Get Settings

  Returns the Altoviz account's application settings (company, accounting, sales, VAT, e-invoicing, emailing, general and social settings).

• Action
  Update Customer

  Update an existing customer.

• Action
  Update Product

  Update an existing product.

• Action
  Update Receipt

  Update an existing receipt.

• Action
  Update Supplier

  Update an existing supplier.

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