Airtable + mfr - field service management

Create new records in Airtable for new appointments in mfr - field service management

Streamline your field service management tasks by connecting mfr and Airtable through this workflow. When a new appointment is scheduled within mfr, a record is instantaneously created in Airtable. This efficient process fosters better appointment tracking and overall management, eliminating the need for manual data entry. Enhance your operational efficiency with this seamless automation.

When this happens...
New Appointment
Triggers when a new appointment is created.
TriggerInstant
automatically do this!
Create Record
Creates a new record with auto-populating fields.
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

- 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
- Service Request IDRequired
- Current Owner Email
- Current Owner ID
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

- Original Service Request IDRequired
- Follow-up Job Name
- Follow-up Job Description
- Job Template ID
- Service Request Type
- Clone Comments
- Clone Undone and Failed Steps
- Clone Items
- Clone All Steps
- Clone Documents
- Clone Tags
- Clone Open Appointments
- Project Id
- StartDateTime
- EndDateTime
- MFR Username
- Product List
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
- Time Event TypeRequired
- Duration [Minutes]
- Start Date Time
- End Date Time
- Description
- Username of TechnicianRequired
- Service Request ID
- Appointment ID
- Longitude
- Latitude
- Driving Distance
- Corrected Time
- External ID
- Is Approved
Action
Write
- Service Request IDRequired
- Job Name
- Job Description
- Job State
- Current Owner Email
- Target Time (minutes)
Action
Write
- FilenameRequired
- FileRequired
Action
Write
- Company Id
- Company Name
Action
Search
- ServiceObject Id
- ServiceObject Name
Action
Search
- Username
Action
Search
- BaseRequired
- TableRequired
- Limit to View
- Include attachment content
Trigger
Polling
Try It
- BaseRequired
- TableRequired
- RecordRequired
- CommentRequired
Action
Write
- Cache Copy
- BaseRequired
- TableRequired
Action
Write
- BaseRequired
- TableRequired
- Help Text
- Primary lookup fieldRequired
- Secondary lookup field
Action
Write
- BaseRequired
- TableRequired
- RecordRequired
Action
Write
- BaseRequired
- TableRequired
- Number of RecordsRequired
Action
Write
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search type
- Search Formula
- Limit to View
Action
Search
- BaseRequired
- Search KeywordRequired
- Search In
Action
Search
- Search KeywordRequired
Action
Search
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search type
- Search Formula
- Limit to View
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
- 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
- Offer ID
- Service Request ID
- 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
- Entity Id (Job)Required
- Entity typeRequired
- TagRequired
Action
Write
- FilenameRequired
- FileRequired
- Job IdRequired
Action
Write
- Service Request IDRequired
- Dispatch Date
- Maximum Results
- Search Radius (km)
- Include Subcontractors
- Preferred Technician ID
- Exclude Technician IDs
- Return Only Best Match
Action
Search
- Item Name / Id
Action
Search
- ServiceRequest Id
- ServiceRequest State
- Expand
- Customer
- ServiceObject Id
Action
Search
- Expands
- ServiceRequest IdRequired
Action
Search
- Help Text
- BaseRequired
- TableRequired
- Last modified time columnRequired
- Limit to view
- Include file contents?
Trigger
Polling
Try It
- BaseRequired
- TableRequired
Action
Write
- NameRequired
- Workspace IDRequired
- Number of TablesRequired
Action
Write
- BaseRequired
- Table NameRequired
- Table Description
- Primary Field Name
- Primary Field Type
Action
Write
- BaseRequired
- TableRequired
- RecordRequired
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- BaseRequired
- TableRequired
- Record IDRequired
Action
Search
- BaseRequired
- Table IDRequired
Action
Search
- BaseRequired
Action
Search

About Airtable

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.

Learn more