Connect Yay! Forms to SQL Server

Both apps 24Yay! Forms 13SQL Server 11

• Trigger
  New Response

  Triggers when a new response is submitted.

• Action
  Create Field

  Adds a new question field to a Yay! Forms form and returns the created field.

• Action
  Create Form

  Creates a new form in a Yay! Forms workspace and returns the created form, including its ID and public key.

• Action
  Delete Field

  Deletes one question field from a Yay! Forms form.

• Action
  Delete Form

  Deletes a Yay! Forms form along with its fields and responses.

• Action
  Get Form

  Returns one Yay! Forms form with its settings, theme, status and response counts.

• Action
  Get Form Stats

  Returns view, start and response counts for a Yay! Forms form, plus its completion rate and average time to complete.

• Action
  List Fields

  Returns every question field on a Yay! Forms form, in the order they appear.

• Action
  List Forms

  Returns the forms in a Yay! Forms workspace, one page at a time.

• Action
  List Responses

  Returns the responses submitted to a Yay! Forms form, one page at a time.

• Action
  List Workspaces

  Returns the Yay! Forms workspaces you have access to, with each workspace's id, name and plan.

• Action
  Update Field

  Updates one question field on a Yay! Forms form. Anything you leave blank keeps its current value.

• Action
  Update Form

  Updates a Yay! Forms form's details and settings. Anything you leave blank keeps its current value.

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