Connect Humanity and SeaTable

Both apps 37Humanity 22SeaTable 15

• Trigger
  Approved Leave Requests

  Triggers when a leave request is approved or an approved leave request changes.

• Trigger
  New/Updated Employees

  Triggers when an employee is added or an existing employee is updated.

• Trigger
  New/Updated Time Entries

  Triggers when a time entry is created or updated in the last day.

• Trigger
  Published Shifts

  Triggers when a shift in the next 30 days is published or a published shift changes.

• Trigger
  Published Shifts by Employee

  Triggers when a published shift in the next 30 days that has employees assigned is created or changes.

• Action
  Assign Leave Type to Employee

  Enables a leave type for an employee, optionally setting how many days they are entitled to.

• Action
  Assign Positions to Employee

  Assigns positions to an employee, and optionally removes positions from them.

• Action
  Assign Skills to Employee

  Assigns a skill to an employee in Humanity, optionally with an expiration date and reminder.

• Action
  Create Shift

  Creates a new shift in a Humanity schedule (position), optionally assigning an employee to it.

• Action
  Create/Update Employee

  Creates a new employee, or updates an existing employee when their ID is given.

• Action
  Create/Update Location

  Creates a new location, or updates an existing location when its ID is given.

• Action
  Create/Update Position

  Creates a new position, or updates an existing position when its ID is given.

• Action
  Create/Update Skill

  Creates a new skill, or renames an existing skill when its ID is given.

• Action
  Create/Update Time Entry

  Creates a new time entry (timeclock record), or updates an existing one when its ID is given.

• Action
  Delete shift

  Deletes a shift from the Humanity schedule, optionally including the rest of its repeating series.

• Action
  Find Employee

  Finds a employee by its Humanity ID and returns its details.

• Action
  Find leave requests

  Returns leave requests in a date range, optionally filtered by status and employee.

• Action
  Find locations

  Finds locations and remote sites in Humanity, optionally by name, ID, type or last update time.

• Action
  Find Position

  Finds a position by its Humanity ID and returns its details.

• Action
  Find shifts

  Returns the shifts scheduled within a date range, optionally narrowed to specific employees, positions, locations or skills.

• Action
  Find timeclocks

  Returns timeclock records, optionally filtered by date range, employee, position, status or last update.

• Action
  Update shift

  Updates an existing shift's times, position, title, notes, location or staffing needs.

• Trigger
  New or Updated Row

  Triggers when a row is added to or changed in a SeaTable table.

• Trigger
  New Row

  Triggers when a new row is added to a SeaTable table.

• Action
  Add column

  Adds a new column to a SeaTable table, optionally after a given column, and returns the created column.

• Action
  Add row link

  Links rows in one table to rows in another table through a link column in a SeaTable base.

• Action
  Add table

  Creates a new table, with the columns you specify, in a SeaTable base.

• Action
  Create Row

  Adds a new row to a table in a SeaTable base.

• Action
  Delete Row

  Deletes a row from a table in a SeaTable base.

• Action
  Find Many Rows (With Line Item Support)

  Finds every row (up to 1,000) in a SeaTable table whose column equals a value.

• Action
  Find Row

  Finds the first row in a SeaTable table whose column equals a value.

• Action
  Get base metadata

  Returns the structure of a SeaTable base: its tables, columns, views and settings (no row data).

• Action
  Get row

  Returns one row of a SeaTable table with all its column values, by row ID.

• Action
  Lock Row

  Locks a row in a SeaTable table so it cannot be edited.

• Action
  Run SQL query

  Runs a SQL statement (SELECT, UPDATE, DELETE, or INSERT) against a SeaTable base and returns the resulting rows and column metadata.

• Action
  Unlock Row

  Unlocks a locked row in a SeaTable table so it can be edited again.

• Action
  Update Row

  Updates the column values of an existing row in a SeaTable table.

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