Connect Formstack and Oracle Database

Both apps 30Formstack 18Oracle Database 12

• Trigger
  New Form

  Triggers when a new form is created in the account.

• Action
  Copy Form

  Create a copy of an existing form.

• Action
  Create Folder

  Create a new form folder.

• Action
  Create Form

  Create a new form.

• Action
  Create Form Field

  Add a new field to a form.

• Action
  Create Submission

  Submit data to a form. Field values are passed as field_<id> keys.

• Action
  Create Webhook

  Create a webhook on a form that POSTs to a URL when a submission is received.

• Action
  Delete folder

  Delete a folder.

• Action
  Delete Form

  Delete a form by ID.

• Action
  Delete Submission

  Delete a submission by ID.

• Action
  Delete Webhook

  Delete a webhook by ID.

• Action
  Get Form

  Retrieve details for a single form by ID.

• Action
  Get form field

  Get one field on a form.

• Action
  List Form Confirmations

  List confirmation emails configured on a form.

• Action
  List Form Fields

  List all fields on a form.

• Action
  List form notifications

  List notification emails for a form.

• Action
  List Webhooks

  List webhooks configured on a form.

• Action
  Update folder

  Update a folder.

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