Connect PostgreSQL and Streamtime

Both apps 35PostgreSQL 10Streamtime 25

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

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected PostgreSQL database.

• Action
  Add Row

  Adds a new row.

• Action
  Delete Row

  Delete the rows in a table whose chosen column equals a value.

• Action
  Find Row

  Finds a row in a table via a lookup column.

• Action
  Find Rows via Custom Query

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

• Action
  Find Row via Custom Query

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

• Action
  Update Row

  Updates an existing row.

• Trigger
  Company Created

  Triggers when a new company is created in Streamtime.

• Trigger
  Company Updated

  Triggers when a company in Streamtime is created or any of its details change.

• Trigger
  Job Activity

  Triggers when a new activity entry (comment, post or update notification) is added to a Streamtime job.

• Trigger
  Job Comment Created

  Triggers when a new comment is posted on a Streamtime job.

• Trigger
  Job Created

  Triggers when a new job is created in Streamtime.

• Trigger
  Label Added

  Triggers when a label is added to a specific Streamtime record (job, quote, invoice, company, contact, etc.), or when a new master label is created for a label type if no record is chosen.

• Trigger
  Quote Approved

  Triggers when a quote is approved in Streamtime.

• Trigger
  Quote Sent

  Triggers when a quote is sent to a client in Streamtime.

• Action
  Add Label

  Adds a label to a job, quote, invoice, logged expense, company, contact, user or job group in Streamtime.

• Action
  Create Company

  Creates a new company (client or supplier) in Streamtime.

• Action
  Create Contact

  Creates a new contact under a company in Streamtime.

• Action
  Create Expense

  Creates a logged expense against a job in Streamtime.

• Action
  Create Job Comment

  Adds a comment to a Streamtime job's activity feed.

• Action
  Create Job Post

  Creates a post in a job's activity feed in Streamtime.

• Action
  Create Personal ToDo

  Creates a personal To Do (a time entry not attached to any job) for a Streamtime user on a given date.

• Action
  Find Branch

  Finds Streamtime branches whose name or external name matches the given branch name.

• Action
  Find Company

  Finds companies in Streamtime that match a search filter, such as a company name.

• Action
  Find Contact

  Searches Streamtime contacts matching a filter and returns the matching contacts.

• Action
  Find Expense

  Finds logged expenses in Streamtime that match a search filter, such as a supplier, job or date condition.

• Action
  Find Invoice

  Finds invoices in Streamtime that match a search filter, such as an invoice number, company or status.

• Action
  Find Job

  Finds jobs that match a search filter, such as a job name or status condition.

• Action
  Find Quote

  Searches Streamtime quotes matching a filter and returns the matching quotes.

• Action
  Find User

  Finds users in your Streamtime organisation by email address or display name.

• Action
  Get ToDo

  Returns a single Streamtime To Do (logged time entry) by its id, including its date, minutes, notes, status and costs.

• Action
  List Job Activity Entries

  Returns the activity entries (comments, posts and update notifications) on a Streamtime job, optionally limited to one activity type.

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