Connect SQL Server to JobTread

Both apps 31SQL Server 11JobTread 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 SQL Server database.

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected SQL Server database.

• Action
  Add Row

  Add one row to a table on the connected SQL Server 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 SQL Server database and returns every row it matches.

• Action
  Find Row via Custom Query

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

• Action
  Run Custom Statement

  Runs a statement you write against the connected SQL Server 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.

• Action
  Assign Access

  Grants a team member access to a JobTread record such as a job, so they can see and work on it.

• Action
  Create Comment

  Creates a comment on a JobTread record such as a job, customer or vendor, optionally as a reply to another comment.

• Action
  Create Customer

  Creates a new customer account in your JobTread organization.

• Action
  Create Customer Contact

  Creates a contact person on a JobTread customer account.

• Action
  Create Job

  Creates a job in JobTread at an existing customer location, optionally copying costs or tasks from another job and setting budget line items and custom fields.

• Action
  Create Location

  Creates a location (job site address) for a JobTread customer. A location is required before a job can be created for that customer.

• Action
  Create Task

  Creates a task or to-do on a JobTread job, customer/vendor account, or organization.

• Action
  Create Vendor

  Creates a new vendor account in your JobTread organization.

• Action
  Create Vendor Contact

  Creates a contact person on a vendor account in JobTread.

• Action
  Find a Customer

  Finds customers in your JobTread organization by exact name and returns the matching customer records.

• Action
  Find a Job

  Finds jobs in your JobTread organization by job name or job number and returns the matches.

• Action
  Find a Location

  Finds JobTread locations in your organization by exact name and returns the first match plus all matches.

• Action
  Find a Membership

  Finds a team member's membership in your JobTread organization by the user's name, returning the membership with its user and role.

• Action
  Find a Vendor

  Finds vendors in a JobTread organization by exact name and returns the first match along with all matches.

• Action
  Import Task Template

  Copies the tasks from a JobTread task template onto a job or other target, scheduled from an optional start date.

• Action
  Query API

  Runs any JobTread Pave query or mutation you write and returns the raw result, for reading or changing data the other JobTread actions don't cover.

• Action
  Update Customer

  Updates an existing customer in JobTread, such as its name, tax status or custom field values.

• Action
  Update Location

  Updates an existing location's name, address, contact, tax settings or custom fields in JobTread.

• Action
  Update Vendor

  Updates an existing vendor in JobTread, including its name, tax settings and custom field values.

• Action
  Upload Files

  Uploads a file from a public URL into JobTread and attaches it to a job or other record.

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