DataScope Forms + Microsoft Excel

Assign tasks in DataScope Forms for updated rows in Microsoft Excel

Upgrade your data management process with this workflow. When a row is updated in Microsoft Excel, the changes swiftly translate into a new assignment in your DataScope Forms. Experience a fluent transition of data alterations without the need for manual intervention. This integration solves the problem of monitoring and reassigning tasks due to data updates, thus enhancing efficiency and time-management.

When this happens...
Updated Row
Triggers when a row is added or updated in a worksheet.
TriggerPolling
automatically do this!
Assign Task
Create a new tasks assigned to specific form and user.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- TableRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- Column IndexRequired
- Apply To
- Header Preservation
Action
Write

- Plan Restrictions
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
Action
Write

- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- RowRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- Row IDRequired
- No Match Copy
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search or write
- Form
Trigger
Instant
Try It
Findings: New Finding
Triggers when a finding is created. Only one active Zap per account.
Trigger
Instant
Try It
- FormRequired
Trigger
Instant
Try It
- Form
Trigger
Instant
Try It
- Form
Trigger
Instant
Try It
- Form Status
- Form Name
- Form Code
Action
Write
- Data TemplateRequired
- Emails to notify
Action
Write

- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- TableRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Trigger Column
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- RangeRequired
- Apply To
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- Row IDRequired
- Apply To
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- New NameRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- RangeRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Search or write
Findings: Changed Status
Triggers when a finding changes its status. Only one active Zap per account.
Trigger
Instant
Try It
- FormRequired
Trigger
Instant
Try It
- Form
Trigger
Instant
Try It
- Form
Trigger
Instant
Try It
- Form NameRequired
- User EmailRequired
- Location Name
- Location Address
- Task Instructions
- Task Date
- Assign ID
- Hours to Perform Task
- Location Phone
- Location Code
- Location Email to Notify
- Company Name
- Company Legal ID
- Latitude
- Longitude
- Make this task mandatory (All users must answer to the task)
- Allow the task to be answered after the due date has been reached
Action
Write
- Form NameRequired
- From CodeRequired
- Question NameRequired
- Question ValueRequired
Action
Write

About DataScope Forms

DataScope Forms is a mobile solution to automate your operation. Collect data offline, manage field teams and share business insights.

Learn more

Related categories

Forms & Surveys

Similar apps

Zapier Interfaces

App Builder, CRM (Customer Relationship Management), Forms & Surveys, Zapier

About Microsoft Excel

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.

Learn more