Connect Oracle Database and Sortd for Gmail

Both apps 37Oracle Database 12Sortd for Gmail 25

• Trigger
  New Column

  Fires when a new column appears on an Oracle table you choose.

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

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected Oracle user's own schema.

• Action
  Add Row

  Add one row to a table on the connected Oracle 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 Oracle database and returns every row it matches.

• Action
  Find Row via Custom Query

  Runs a SELECT statement you write against the connected Oracle database and returns the first row it matches.

• Action
  Run Custom Statement

  Runs a statement you write against the connected Oracle 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.

• Trigger
  New Task Created

  Triggers when a new task is created on the chosen Sortd board.

• Trigger
  Task Archived

  Triggers when a task on the chosen Sortd board is archived.

• Trigger
  Task Assigned

  Triggers when a task on the chosen Sortd board is assigned to the given team member.

• Trigger
  Task Completed

  Triggers when a task on the chosen Sortd board is marked complete.

• Trigger
  Task Moved to List

  Triggers when a task arrives on the chosen Sortd list, whether created there or moved in.

• Action
  Add comment

  Adds a plain-text comment to a Sortd task, with optional @email mentions of board members.

• Action
  Add company

  Creates a CRM company in a Sortd team, with optional type, stage, company details and tags.

• Action
  Add contact

  Creates a CRM contact in a Sortd team, optionally linked to an existing or new company.

• Action
  Archive task

  Archives a Sortd task, moving its card off the board into the board's archive.

• Action
  Assign a Task

  Assigns a Sortd task to a member of its board and returns the updated task.

• Action
  Complete Task

  Marks a Sortd task as complete and returns the updated task.

• Action
  Create Task

  Creates a new task on a Sortd list and returns it.

• Action
  Create Task From Gmail Thread

  Creates a Sortd task from a Gmail thread (title defaults to the email subject) and returns it.

• Action
  Delete task

  Deletes a Sortd task. The task stops appearing in boards and lists but can be recovered; linked email threads are left intact.

• Action
  Find contacts by criteria

  Searches a Sortd team's CRM contacts by text, contact type and stage, returning the matching contacts.

• Action
  Get a Lists Tasks

  Returns the tasks on a Sortd list.

• Action
  Get task

  Returns a single Sortd task, including its board and list, status, assignee, due date, linked email threads and custom-field values.

• Action
  List boards

  Returns all boards owned by a Sortd team, with each board's id, name and type.

• Action
  List lists

  Returns the task lists (columns) on a Sortd board.

• Action
  Mark Task as Incomplete

  Reopens a completed Sortd task and returns the updated task.

• Action
  Move a Task to a New List

  Moves a Sortd task to another list (on the same or another board) and returns the updated task.

• Action
  Send email

  Composes and sends a new email from the connected Sortd user's Gmail mailbox, optionally onto an existing thread.

• Action
  Unassign Task

  Clears the assignee on a Sortd task and returns the updated task.

• Action
  Update contact

  Updates an existing CRM contact in Sortd, changing only the fields you fill in.

• Action
  Update task

  Updates a Sortd task — its title, notes, next step, due or planned date, colour, status, assignee, deal details or custom-field values. Returns the updated task.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.