Connect PostgreSQL to AFrame

Both apps 30PostgreSQL 10AFrame 20

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

• Action
  Add contact note

  Adds a note to an existing contact in AFrame and returns the created note.

• Action
  Add event

  Creates a new event (date or appointment) on an AFrame transaction, with a fixed date or a date calculated from another transaction date.

• Action
  Add task

  Creates a new Task in AFrame, assigned to a team member and optionally linked to a transaction or contact.

• Action
  Add transaction attachment

  Creates a new attachment entry (a file placeholder or a web link) on an AFrame transaction.

• Action
  Add transaction note

  Adds a note (or showing / price-change activity) to an existing AFrame transaction.

• Action
  Add transaction participant

  Adds a participant to an AFrame transaction in a given role, either linking an existing contact, creating a new contact inline, or holding the role as a placeholder.

• Action
  Create Contact

  Creates a new Contact in your AFrame team, with name, company, emails, phones, addresses and categories.

• Action
  Create Transaction

  Creates a new Transaction in AFrame for a property address, with optional prices, key dates, assigned team members and custom field values.

• Action
  Find contacts

  Searches AFrame contacts by name, company, team, email, categories, or created/edited date range and returns the matching contacts (up to 100).

• Action
  Find tasks

  Returns tasks matching the given status, due/completion dates, transaction, contact or assignee filters (up to 100).

• Action
  Find team members

  Finds team members in your AFrame team by name, email, role, type or active status.

• Action
  Find transactions

  Searches transactions by ID, stage, property address, or created/edited date range and returns the matching transactions (up to 100).

• Action
  Get contact

  Returns a contact's details, including name, emails, phones, addresses, owners and categories.

• Action
  Get contact note

  Returns a single contact note by its ID, including its content, type, date and any attached file details.

• Action
  Get Event

  Returns one event (a date or appointment such as a closing date) on a transaction.

• Action
  Get transaction

  Returns a single AFrame transaction by its ID, including its status, property details, participants and custom field values.

• Action
  Get Transaction Note

  Returns a transaction note by its ID, including its content, activity date, contact details and visibility settings.

• Action
  Update contact

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

• Action
  Update task

  Updates an existing AFrame task, changing only the fields you fill in, and returns the updated task.

• Action
  Update transaction

  Updates an existing AFrame transaction's property address, status, assigned team members, prices, dates and commission. Only the fields you fill in are changed.

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