Connect folk and SQL Server

Both apps 38folk 27SQL Server 11

• Trigger
  Company Added

  Triggers when a new company is created or added to a group.

• Trigger
  Company Custom Field Updated

  Triggers when a company custom field (for example tag, status, text, assignee) is updated.

• Trigger
  Company Removed

  Triggers when a company is deleted from the workspace or removed from a group.

• Trigger
  Company Updated

  Triggers when a company basic field (like name, email or URL) in a group is updated.

• Trigger
  Deal Added

  Fires when a new deal is created.

• Trigger
  Deal Removed

  Fires when a deal is deleted from a pipeline.

• Trigger
  Deal Updated

  Fires when a deal is updated (stage change, field update).

• Trigger
  Person Added

  Triggers when a new person is created or added to a group.

• Trigger
  Person Custom Field Updated

  Triggers when a person custom field (for example tag, status, text, assignee) is updated.

• Trigger
  Person Removed

  Triggers when a person is deleted from the workspace or removed from a group.

• Trigger
  Person Updated

  Triggers when a person basic field (like first name, job title, email or URL) in a group is updated.

• Action
  Create Company

  Creates a company in folk, optionally adding it to a group and setting that group's custom fields.

• Action
  Create Deal

  Creates a deal in a folk group, optionally linked to companies and people, and sets that deal type's custom fields.

• Action
  Create Group

  Creates a group in folk. A default "All people" table view is added to the group automatically.

• Action
  Create Note

  Creates a note on a folk person, company or deal. Optionally posts it as a reply to an existing note.

• Action
  Create Person

  Creates a person in folk, optionally adding them to a group and setting that group's custom fields.

• Action
  Create Reminder

  Creates a reminder on a folk person, company or deal, scheduled with an iCalendar recurrence rule.

• Action
  Delete Company

  Deletes a company from folk by its id.

• Action
  Delete Person

  Deletes a person from folk by their id. This also removes their custom fields, notes and associations.

• Action
  Find a Company

  Searches folk companies by name, email or website and returns the matches, with the first one broken out for easy mapping.

• Action
  Find a Person

  Searches folk people by email, full name or phone and returns the matches, with the first one broken out for easy mapping.

• Action
  Get a Company

  Fetches one folk company by id, including its custom field values.

• Action
  Get a Note

  Fetches one folk note by id, with its text, author and the record it is attached to.

• Action
  Get a Person

  Fetches one folk person by id, including their custom field values.

• Action
  List Groups

  Returns the groups in the folk workspace, with each group's id, name and visibility.

• Action
  Update Company

  Updates a folk company. Only the fields you fill in are changed; list fields such as emails replace the whole list.

• Action
  Update Person

  Updates a folk person. Only the fields you fill in are changed; list fields such as emails replace the whole list.

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