Connect QuickBase and Runn

Both apps 47QuickBase 23Runn 24

• Trigger
  New or updated record

  Polling trigger. Fires for each record added or modified in the specified Quickbase table, ordered by Date Modified. Records are deduped by their Record ID# (field 3).

• Trigger
  New record

  Polling trigger. Fires for each new record added to the specified Quickbase table, ordered by Record ID#. Records are deduped by their Record ID# (field 3).

• Action
  Add app

  Creates a new Quickbase application in the connected realm, optionally with a description, app variables and security properties.

• Action
  Add field

  Creates a new field in a Quickbase table, optionally with display settings, type-specific properties and per-role permissions.

• Action
  Add table

  Create a new table in a QuickBase app.

• Action
  Delete app

  Delete a QuickBase app by id.

• Action
  Delete field

  Delete one or more QuickBase fields from a table.

• Action
  Delete records

  Delete records from a Quickbase table that match a query (Quickbase query language in the where clause).

• Action
  Delete table

  Deletes a table from a Quickbase app, including all of the data within it.

• Action
  Get app

  Get the properties of a Quickbase application by its app ID.

• Action
  Get field

  Get a single QuickBase field by id.

• Action
  Get report

  Get metadata for a single QuickBase report.

• Action
  Get table

  Get the properties of a single Quickbase table by table ID and app ID.

• Action
  Get table fields

  List all fields (columns) for a Quickbase table, including field IDs, labels, and types.

• Action
  Get tables for app

  List all tables belonging to a Quickbase application.

• Action
  Insert or update records

  Insert new records or update existing ones in a Quickbase table. Pass data as an array of record objects keyed by field ID. Include the table's key field (or record ID field 3) to update; omit to insert.

• Action
  List reports

  Lists all reports defined on a Quickbase table.

• Action
  Query records

  Query records from a Quickbase table. Optionally pass select (array of field IDs), where (Quickbase query language), sortBy, groupBy, and options (skip/top).

• Action
  Run formula

  Runs a Quickbase formula against a table (and optionally a record) and returns the result as text.

• Action
  Run report

  Run a Quickbase report by report ID and table ID and return its result rows.

• Action
  Update app

  Updates an app's name, description, app variables and/or security properties. Properties left blank stay unchanged.

• Action
  Update field

  Updates the properties and per-role permissions of an existing field in a Quickbase table. Properties left blank stay unchanged.

• Action
  Update table

  Update an existing QuickBase table's properties.

• Trigger
  New Assignment

  Triggers when a new assignment is created in Runn, optionally limited to one person, role or project.

• Trigger
  New Client

  Triggers when a new client is created in Runn.

• Trigger
  New Contract

  Triggers when a new contract is added to a person in Runn.

• Trigger
  New Holiday Group

  Triggers when a new holiday group is added to your Runn account.

• Trigger
  New Person

  Triggers when a new person is added in Runn.

• Trigger
  New Project

  Triggers when a new project is created in Runn.

• Trigger
  New Rate Card

  Triggers when a new rate card is created in Runn.

• Trigger
  New Role

  Triggers when a new role is created in Runn.

• Trigger
  New Skill

  Triggers when a new skill is created in Runn.

• Trigger
  New Team

  Triggers when a new team is created in Runn.

• Trigger
  New User

  Triggers when a new user is added to your Runn account.

• Action
  Assign a Manager

  Adds a Runn user as a manager of a person or placeholder, keeping any managers they already have. Returns the updated person.

• Action
  Create Assignment

  Creates an assignment that schedules a person or placeholder on a project in a role for a date range, with the same number of minutes on each working day.

• Action
  Create Client

  Creates a new client in Runn with a name and, optionally, a website and links to external systems.

• Action
  Create Contract

  Adds a new contract to a person in Runn, setting their role, dates, employment type, cost and working hours.

• Action
  Create Person

  Creates a person in Runn, along with their first contract (role, employment type, cost and working hours).

• Action
  Create Project

  Creates a project in Runn for a client, optionally setting its budget, pricing model, rate card, team and managers, or duplicating it from an existing template project.

• Action
  Create Role

  Creates a role in Runn, with optional default hourly cost, standard charge-out rate and external references.

• Action
  Create Skill

  Creates a new skill in Runn that can be assigned to people and placeholders.

• Action
  Create Timesheet (Actual)

  Records the time a person actually spent on a project for one day, creating the actual or overwriting an existing one for the same date, person, project, role and workstream.

• Action
  Find Client

  Returns Runn clients whose name contains the text you enter (case-insensitive), with each client's id, website, archived status and external references.

• Action
  Find Person

  Finds people in Runn by email, first name, last name or external id, returning every match and the first matching person.

• Action
  Find Project

  Returns the projects whose name contains the text you give (ignoring case), optionally narrowed by external ID or last-modified date.

• Action
  Find Role

  Finds roles in Runn whose name contains the text you give, ignoring case. Returns the matching roles, how many matched, and the first match.

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