Microsoft Excel + mfr - field service management

Create new jobs in mfr - field service management from updated rows in Microsoft Excel

Enhance your field service organization process with this convenient workflow. When there's an updated row in the Microsoft Excel spreadsheet, a new job is generated in mfr - field service management. This integration aids your team in effectively distributing tasks, staying current, and boosting productivity.

When this happens...
Updated Row
Triggers when a row is added or updated in a worksheet.
TriggerPolling
automatically do this!
Create Job
Creates a new Job in mfr. Jobs always have a job description and can be created from a job template.
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 NameRequired
- Column Headers
Action
Write

- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search or write

- Appointment Type
Trigger
Instant
Try It
New Location (Service Location)
Triggers when new location (service location) is available.
Trigger
Instant
Try It
- Service Request StateRequired
Trigger
Instant
Try It
- Appointment typeRequired
- Duration [Minutes]Required
- Start date timeRequired
- End date time
- Appointment description
- Username of techncianRequired
Action
Write
- Customer First NameRequired
- Customer Last NameRequired
- Company Id
- Company Address
- Company Postal
- Company City
- Company note
- Company note
Action
Write
- Job IdRequired
- Report definition Code (e.g. R-212)Required
Action
Write
- Job NameRequired
- Job Id
- Customer IdRequired
- Job Description
- Location Id (Service location)
- Job Template
- Project Id
- TargetTime
- StartDateTime
- EndDateTime
- MFR Username
- Produktliste
Action
Write
- FilenameRequired
- FileRequired
- Job IdRequired
Action
Write
- ServiceObject Id
- ServiceObject Name
Action
Search
- Username
Action
Search

- 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
- TitleRequired
- Column Headers
- Zap Step Id
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 NameRequired
- Column Headers
Action
Search or write
New Customer
Triggers when new customer is created.
Trigger
Instant
Try It
New Job
Triggers when new job was created.
Trigger
Instant
Try It
- Entity Id (Job)Required
- Entity typeRequired
- TagRequired
Action
Write
- Customer NameRequired
- Company Id
- Company Address
- Company Postal
- Company City
- Company note
- Main contact first name company
- Main contact last name company
- Main contact phone number
- Main contacts email
Action
Write
- ItemType NameRequired
- ItemType IdRequired
- Price
- Costs
- ItemType description
- ItemType EAN
Action
Write
- Location NameRequired
- Location Id
- Company Id
- AddressRequired
- Zip code
- City
- Country
- Contact First Name
- Contact Last Name
- Location Note
- Contact Telephone
- Contact Email
Action
Write
- Entity Id (Job)Required
- Entity typeRequired
- TagRequired
Action
Write
- Item Name / Id
Action
Search
- ServiceRequest Id
- ServiceRequest State
- Expand
- Customer
- ServiceObject Id
Action
Search
- Expands
- ServiceRequest IdRequired
Action
Search

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