Connect Fulcrum and Oracle Database

Both apps 35Fulcrum 23Oracle Database 12

• Trigger
  Record Created

  Triggers when a new record is created in Fulcrum.

• Trigger
  Record Updated

  Triggers when a record is created or updated in Fulcrum.

• Action
  Add form

  Creates a new form (app) in Fulcrum with the fields, status options and settings you provide.

• Action
  Delete project

  Deletes a project from your Fulcrum account.

• Action
  Delete Record

  Deletes a Fulcrum record.

• Action
  Download PDF Report

  Downloads the PDF file of a generated Fulcrum report.

• Action
  Find Record

  Returns one Fulcrum record by its ID, with its field values and location.

• Action
  Find Records

  Returns Fulcrum records, optionally filtered by form, project and created or updated time.

• Action
  Generate PDF Report

  Generates a PDF report for a Fulcrum record, optionally from a report template.

• Action
  Get Form

  Returns one Fulcrum form (app) with its fields.

• Action
  Get Project

  Returns one Fulcrum project by its ID.

• Action
  List Forms

  Returns the forms (apps) in your Fulcrum organization.

• Action
  List memberships

  Returns the members of your Fulcrum organization, optionally limited to a form, project or layer.

• Action
  List photos

  Returns metadata for photos in your Fulcrum account, optionally limited to one record or app.

• Action
  List Projects

  Returns the projects in your Fulcrum organization.

• Action
  List record history

  Returns every saved version of a Fulcrum record, with who made each change and when.

• Action
  Project Create

  Creates a new Fulcrum project.

• Action
  Query Records

  Runs a SQL query against your organization's Fulcrum data and returns the rows.

• Action
  Record Create

  Creates a new record in a Fulcrum form.

• Action
  Record Update

  Replaces a Fulcrum record with the values given; fields not sent are cleared.

• Action
  Update form

  Updates an existing Fulcrum form's name, fields and settings. The whole field list is replaced with the elements you supply.

• Action
  Update project

  Updates the name and description of an existing Fulcrum project and returns the updated project.

• Action
  Update Record (Partial)

  Updates only the given fields of a Fulcrum record and leaves the rest unchanged.

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

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