Connect NeonCRM and SQL Server

Both apps 34NeonCRM 23SQL Server 11

• Trigger
  New event

  Triggers when a new event is created in NeonCRM.

• Trigger
  New event registration

  Triggers when someone registers for the chosen NeonCRM event.

• Action
  Add campaign

  Creates a fundraising campaign in Neon CRM and returns its id.

• Action
  Add event

  Creates a new event in Neon CRM with its name, dates, location and registration settings, and returns the new event's id.

• Action
  Add event registration

  Creates a registration for a NeonCRM event on behalf of an account, optionally with tickets, attendees and payments.

• Action
  Add membership

  Creates a membership for a Neon CRM account at the chosen membership level and term.

• Action
  Add pledge

  Creates a pledge for a NeonCRM account, with its amount, fund, campaign and other gift details.

• Action
  Create Account

  Creates an individual account in Neon CRM with its primary contact details and address, and returns the new account's id.

• Action
  Create Activity

  Creates an activity (task, call, meeting) in Neon CRM, optionally linked to an account, event, grant or prospect.

• Action
  Create Donation

  Creates a donation for a Neon CRM account, with optional fund, campaign, tribute, payment and custom field details.

• Action
  Get account

  Returns one Neon CRM account (individual or company) by its id, including contact details, addresses and custom fields.

• Action
  Get donation

  Returns a single donation by its ID, including amount, date, donor account, fund, campaign, payments and donation custom fields.

• Action
  Get event

  Returns a single event by its ID, including dates, location, category and financial settings.

• Action
  Get event registration

  Returns one event registration, including its tickets, attendees, payments and registrant custom fields.

• Action
  Get membership

  Returns a single Neon CRM membership, including its level, term, dates, fee, status, payments and membership custom fields.

• Action
  Link Individual Account to Company Account

  Links an individual account to a company account as a contact, optionally setting title, department, employment dates and primary-contact status.

• Action
  List campaigns

  Returns every fundraising campaign in your Neon CRM account with its id, code, name and status.

• Action
  Update activity

  Updates an existing activity in NeonCRM. Only the fields you fill in are changed.

• Action
  Update Company Account

  Updates an existing company account in Neon CRM, changing only the details you fill in.

• Action
  Update donation

  Updates an existing donation in NeonCRM, changing only the details you supply.

• Action
  Update event

  Updates an existing NeonCRM event, changing only the details you fill in.

• Action
  Update Individual Account

  Updates an individual account in Neon CRM, changing only the details you fill in.

• Action
  Update membership

  Updates an existing membership in Neon CRM, changing only the fields you fill in.

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