ConditionalVisibility

new-products-promo

Automation inspiration

database-automation-00-hero

Device Magic

Fulcrum

JobNimbus

Jotform

Whenever you need to handle complex information, such as payment information or signatures, a data collection tool will get the job done better than traditional form builders.

Collecting complex data? Here's how to automate it with Zapier

Keep track of everything that happens with the data from your forms by having Zapier log each change with this Fulcrum-Google Sheets integration. It will trigger whenever a Fulcrum record changes status, automatically sending the information to Google Sheets where a new row will be added for you.

Fulcrum is a mobile data collection tool that allows users to easily design custom forms and quickly conduct field data collection on Android and iOS. Fulcrum works in connected and disconnected environments.

Record Created

Record Deleted

Record Updated

Project Create

Record Create

Record Update

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Google Sheets

Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.

New Spreadsheet Row (Team Drive)

Triggers when a new row is added to the bottom of a spreadsheet.

New Spreadsheet Row

Triggers when a new spreadsheet is created.

New Spreadsheet

Triggers when a new row is added or an existing row is updated in a spreadsheet. Optimized for Team Drive.

New or Updated Spreadsheet Row (Team Drive)

Triggers when a new row is added or modified in a spreadsheet.

New or Updated Spreadsheet Row

Triggers when a worksheet is created in a spreadsheet.

New Worksheet

Find up to 500 rows based on a column and value as line items.

Lookup Spreadsheet Rows (Advanced)

Find Worksheet

Return up to 500 rows as a single JSON value or as line items.

Get Many Spreadsheet Rows (Advanced)

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.

Lookup Spreadsheet Row

Finds or creates a specific find worksheet.

Find or Create Worksheet

Find or Create Row

Create a new column in a specific spreadsheet.

Create Spreadsheet Column

Create a new row in a specific spreadsheet.

Create Spreadsheet Row

Create one or more new rows in a specific spreadsheet (with line item support).

Create Multiple Spreadsheet Rows

Creates a new worksheet by copying an existing worksheet.

Copy Worksheet

Creates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.

Create Spreadsheet

Creates a new worksheet in a Google Sheet.

Create Worksheet

Clears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.

Clear Spreadsheet Row(s)

Deletes the selected row(s) from the spreadsheet. This action removes the row(s) and all associated data.

Delete Spreadsheet Row(s)

Format Spreadsheet Row

Update Spreadsheet Row

Update one or more rows in a specific spreadsheet (with line item support).

Update Spreadsheet Row(s)

Custom Actions (Beta)

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

API Request (Beta)

Add rows to Google Sheets when new Fulcrum records change status

Do you want to organize FastField form submissions in a spreadsheet? With this integration, you can just tell Zapier what fields in what form should populate your data and you're done. Now every time a user in your account submits a form, the selected fields will be sent to a new row in your Google Sheets spreadsheet automatically.

FastField Mobile Forms is a flexible platform to efficiently capture custom form data using smartphones and tablets.

FastField Mobile Forms

Triggers when a new Form is submitted to FastField.

New Form Submission

Sends a Form to one or more users, with the option of pre-populating Form Fields. The Form appears in the users inbox in the FastField Mobile App.

Create Form Dispatch

Replaces an existing FastField Global List with a Global List in a xlsx or csv file.

Update Global List

Replaces an existing FastField Lookup List with a Lookup List in a xlsx or csv file.

Update Lookup List

Save new FastField mobile form submissions to Google Sheets spreadsheet rows

It's often useful to archive your form submissions into Google Sheets as a backup, or for other purposes. This integration saves each new Magpi data record, like each completed form, as a new row in a Google Sheet.

Magpi is a full-featured and easy to use mobile data collection and messaging system, allowing online or offline data collection from any mobile device. Collect data using iOS, Android, or Symbian apps, or using SMS from any device.

Magpi

Delete Trigger

Triggers when a new record is added to a Form.

New Record

Update Record

Add new Magpi data to Google Sheets

It's often useful to archive your form submissions into Microsoft Excel as a backup, or for other purposes. This integration saves each new Magpi data record, like each completed form, as a new row in an Excel worksheet.

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. 

Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Microsoft Excel

Triggers when a new row is added to a worksheet in a spreadsheet.

New Row

Triggers when a new row is added to a table in a spreadsheet.

New Row in Table

Triggers when a new worksheet is added to a spreadsheet.

Triggers when a row is added or updated in a worksheet.

Updated Row

Finds a row by a column and value. Returns the entire row if one is found.

Find Row

Finds any rows that match a specific value in a given column.

Find Row(s)

Adds a new row to the end of a worksheet.

Add Row

Adds one or more rows to the end of a worksheet (with line item support).

Add Row(s)

Adds a new row to the end of a specific table.

Add Row to Table

Update Row

Add new Magpi data to Microsoft Excel

Can't afford to waste time copying all those form entries yourself? Set up this Device Magic-Google Sheets integration and Zapier will capture every single one. Triggered from then on by any new submissions on Device Magic, the automation will add all the responses to a new row on Google Sheets every time.

Build custom forms to capture important data through your mobile device with Device Magic. Save time, get better data, and automate your business.

Triggers when your form receives a new submission.

New Submission

Dispatches a Form to a target Device.
This is only available to trial and enterprise organizations.

Dispatch Form

Add new rows to Google Sheets from new Device Magic form submissions

It's useful to copy your Magpi new data as a backup, or for other purposes, but doing so manually takes time. This integration can do that for you automatically: After being activated, it will save each new Magpi data record (i.e. each completed form) as a new row in a MySQL database, keeping them all safe and accessible.

MySQL is a premier database used in millions of production environments around the world. Easily plug your MySQL database into any web service.

MySQL

New Column

Triggers when new rows are returned from a custom query that you provide. **Advanced Users Only**.

New Row (Custom Query)

New Table

Triggers when a new row is added or modified.

New or Updated Row

Finds a row in a table via a lookup column.

Finds multiple rows in a table via a custom query you control.

Find Multiple Rows via Custom Query

Finds a row in a table via a custom query you control.

Find Row via Custom Query

Create MySQL rows from new Magpi data submissions

Tired of copying form data into your records by hand? Zapier can help with that. This Zoho Forms-Airtable integration, once active, will automatically log every new Zoho Form response into your Airtable of choice, ensuring you have a perfect record of every different answer.

Zoho Forms is a free online form builder that lets you create custom forms, receive responses by email, and collaborate with your team.

Zoho Forms

Triggers when a new form entry is submitted.

New Form Entry

Organize anything with Airtable, a modern database created for everyone. Airtable is a fast and flexible way to create tables to keep track of anything, from sales leads to vacation planning to inventory management.

Airtable

Triggers when a new record is created or new or existing records when first added to a selected view.

Triggers when a record is created or updated.

New or Updated Record

Find Many Records (Advanced)

Find Record

Find or Create Record(s) (With Line Item Support)

Find or Create Record

Creates a new record with auto-populating fields.

Create Record

Create up to 10 new records (supports line items).

Create Records (Advanced)

Find and update an existing record, or create a new one.

Create or Update Record

Delete Record

Add new Zoho Forms submissions to Airtable as records

A backup can prevent tragedy, but sometimes we're too busy to take care of it manually. The good news is that Zapier can set things up for you: After being activated, this integration will save each new Magpi data record (i.e. each completed form) as a new row in a SQL Server database, keeping them all safe and accessible.

SQL server (or MS SQL) is a top of the line database geared for the cloud

SQL Server

Create SQL server rows from new Magpi data submissions

Want a simple way to gather data on the field from your clients, and then immediately have that info saved to Evernote? This integration will let you do just that with your Device Magic forms.

Evernote is a powerful note taking application that makes it easy to capture ideas, images, contacts, and anything else you need to remember. Bring your life's work together in one digital workspace—available on all major mobile platforms and devices.

Using Evernote for work? See Evernote Business.

Evernote

Triggers when a new note is created in or moved to a notebook.

New Note

Triggers when a new notebook is added to Evernote.

New Notebook

Triggers when a new reminder with a date is added to a notebook.

New Reminder

Triggers when a specific tag is added to a note in Evernote.

New Tag Added to Note

Search for a note by title, optionally limited by notebook and tags.

Find a Note

Search for a tag by title, optionally limited by notebook.

Find a Tag

Find or Create Note

Find or Create Tag

Tag Note

Appends content to an existing note by title inside Evernote (it will be created first if it doesn't exist).

Append to Note

Creates a new note in a notebook for Evernote.

Create Note

Create Notebook

Creates a new tag inside Evernote. Limited to 10,000 tags in your account.

Create Tag

Save Device Magic Forms to Evernote

Forms are the best way to collect leads, but that still leaves a lot of manual work to do on your part. This integration automatically creates a new Salesforce contact record using data collected in the field, whether by using a Magpi app or by SMS. You can select exactly which parts of the collected data get copied into the new Salesforce contact. 

Salesforce is a leading enterprise customer relationship manager (CRM) application.

Salesforce

Triggers when a new Attachment is added to a case.

New Case Attachment

New Contact

Triggers when a field is updated on the object specified. It will output the old and new field values.

New Field History Tracking Event

Triggers when an attachment, note, or content document is added or updated on any record of the specified Salesforce object.

New or Updated File on Record

New Lead

Triggers when a new outbound message is received in Salesforce.

New Outbound Message

Triggers when a record of the specified Salesforce object (ie. Contact, Lead, Opportunity, etc.) is created.

Triggers when a field of your choosing (ie. email address, status) is updated on any record of a specified Salesforce object (ie. Contact, Lead, Opportunity, etc.).

Updated Field on Record

Triggers when any record of the specified Salesforce object (ie. Contact, Lead, Opportunity, etc.) is updated.

Updated Record

Finds Child Records for a given Parent ID, and returns the Child records as line-items.

Collecting complex data? Here's how to automate it with Zapier

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.