Connect My Music Staff and SQL Server

Both apps 32My Music Staff 21SQL Server 11

• Trigger
  Attendance Taken

  Triggers when attendance is taken or edited for a calendar event.

• Trigger
  New Email

  Triggers when a new email message is created.

• Trigger
  New Invoice

  Triggers when a new invoice is created (manually or by auto-invoicing).

• Trigger
  New SMS

  Triggers when a new SMS message is created.

• Trigger
  New Student

  Triggers when a new student is added to your My Music Staff account.

• Trigger
  Payment Added

  Triggers when a payment is recorded in a Family Account.

• Trigger
  Student Added to Event

  Triggers when a student is added to an event on the calendar.

• Trigger
  Student Updated

  Triggers when a student's profile information is updated.

• Action
  Add Calendar Event

  /calendar/event (body CalendarEventInputItem) — creates a calendar event with its student attendees, which creates Attendance records for each student.

• Action
  Add Payment

  Records a payment in the Family Account

• Action
  Add Student

  Adds a new student to your My Music Staff account.

• Action
  Find All Parents

  Finds all parents based on Family ID or on search text.

• Action
  Find Attendance Records

  Searches attendance records by date range, student, teacher, event, or status. Returns matching records with a total count.

• Action
  Find Event

  Finds an event based on Event ID.

• Action
  Find Parent

  Finds first Parent based on Family ID or on search text.

• Action
  Find Student

  Finds students based on Student ID or on search text.

• Action
  List Lesson Notes

  Returns a student's past lessons, newest first, with the attendance status and the lesson notes written for the student, the parent and the teacher.

• Action
  List Student Repertoire

  Returns the pieces assigned to a student with each piece's progress status (Recommended, Requested, In Progress or Completed) and the dates it was started and completed.

• Action
  Search Repertoire

  Searches your studio's repertoire library by title or composer, instrument and genre, and returns the matching pieces.

• Action
  Search Students

  Searches your students by name, email, family or status and returns the matching students with their family details.

• Action
  Update Student

  Updates a student's details, such as, status (Active, Trial, Lead, Waiting, Inactive), name, email, phone, birthday, etc.

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

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