SQL server

When you use forms.app as the trigger (“New Form Submission”) and SQL Server as the action in Zapier, your workflow becomes streamlined: a form submission in forms.app → Zap triggers → a new row (or update) is created in your SQL Server database with the form’s data. This lets you capture form responses directly into your database for reporting, analytics, storage, or other workflows.
 

According to Zapier’s help documentation, the SQL Server app supports actions like “Create Row”, “Update Row”, and triggers like “New Row” or “New or Updated Row”.

What you’ll need

• A forms.app account (to create your form and collect responses)
   
• A Zapier account (to build the integration from forms.app → SQL Server)
   
• A Microsoft SQL Server database instance (version 2012 or newer) that is accessible from outside your network and allows remote connections.
   
• Connection details & permissions: host/IP, port (default 1433), database name, user credentials, firewall/whitelist settings (Zapier’s IP addresses need access)
   

Why use it?

By integrating forms.app with SQL Server, you can:

• Automatically log each form submission into your SQL Server database.
   
• Keep a centralized repository of your form responses (and other connected data) for querying, analysis, or workflows.
   
• Trigger downstream processes (such as dashboards, business logic, ETL) based on real-time form submission data.
   

5 Steps to Set Up Microsoft SQL Server + forms.app Integration

1. In your forms.app dashboard, create and publish your form so that submissions will trigger “New Form Submission” in Zapier.
    
2. Click the “Use This Integration” button here or find Microsoft SQL Server by going to the Connect tab after creating your form.
    
3. In Zapier, select an action such as “Create Row” (or “Update Row” if appropriate) → connect your SQL Server database by entering host, port, database name, username, password, schema, etc. (Learn more about SQL Server on Zapier)
    
4. Map the fields from your form submission (for example: Name, Email, Message, Date, Custom Field) into the corresponding columns of your SQL Server table so the data lands correctly.
    
5. Test your Zap with a sample form submission → check your SQL Server table to confirm the row appears correctly → once successful, turn the Zap ON. From then on, every new form submission will automatically be inserted/updated in SQL Server.
    

With the integration of forms.app and Microsoft SQL Server, you can automate your data-capture workflow.