Connect Bloomerang and SQL Server

Both apps 23Bloomerang 12SQL Server 11

• Trigger
  New Constituent

  Triggers when a new constituent (individual or organization) is added in Bloomerang.

• Trigger
  New Interaction

  Triggers when a new interaction (call, email, meeting or other touchpoint) is logged in Bloomerang.

• Trigger
  New or Updated Constituent

  Triggers when a constituent is added or changed in Bloomerang.

• Trigger
  New Task

  Triggers when a new task is created in Bloomerang.

• Trigger
  New Transaction

  Triggers when a new transaction (donation, pledge or recurring gift) is recorded in Bloomerang, including its designation line items.

• Trigger
  New Transaction Payment

  Triggers once for each donation, pledge payment or recurring donation payment in a new Bloomerang transaction, so a split payment fires once per line item.

• Action
  Create Constituent

  Creates a new individual or organization constituent in Bloomerang, with optional primary email, phone and address.

• Action
  Create Donation

  Records a donation for a Bloomerang constituent, split across up to 10 fund designations.

• Action
  Create Interaction

  Logs a new interaction (a call, email, meeting or other touchpoint) on a Bloomerang constituent.

• Action
  Create Task

  Creates a new task in Bloomerang, optionally tied to a constituent and assigned to a user.

• Action
  Find Constituent

  Searches Bloomerang constituents and households by name, email or other text and returns the matches.

• Action
  Update Constituent

  Updates an existing Bloomerang constituent. Only the fields you fill in are changed.

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