Airtable + Simpro

Create or update Airtable records when new jobs are added in Simpro

Keep your records updated effortlessly with this workflow. Whenever a new job emerges in Simpro, it will activate an immediate creation or update of a record in Airtable. This automation provides a seamless and efficient way to ensure consistency between your project management and record keeping processes, reducing manual data entry and the risk of errors.

When this happens...
New Job
Triggers when a job is created.
TriggerInstant
automatically do this!
Create or Update Record
Updates an existing record if one exists, otherwise creates a new record.
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

What does this mean?

New Company Customer
Triggers when a company customer is created.
Trigger
Instant
Try It
New Individual Customer
Triggers when an individual customer is created.
Trigger
Instant
Try It
New Job
Triggers when a job is created.
Trigger
Instant
Try It
New Quote
Triggers when a quote is created.
Trigger
Instant
Try It
New Schedule
Triggers when a job, lead, quote or activity schedule is created.
Trigger
Instant
Try It

New Site
Triggers when a site is created.
Trigger
Instant
Try It
- Company NameRequired
- Preferred Techs
- Phone
- Do Not Call
- Alt Phone
- Address
- City
- State
- Postal Code
- Country
- Address
- City
- State
- Postal Code
- Country
- Customer Type
- Tags
- Part Tax Code
- Discount Fee
- Notes
- Customer Profile
- Customer Group
- Account Manager
- Currency
- Account Name
- Routing No
- Account No
- Payment Method
- Credit Limit
- On Stop
- Vendor Order No Required
- Archived
- Sites
- Email
- EIN
- Website
- Fax
- Company Number
Action
Write

- Title
- Given NameRequired
- Family NameRequired
- Preferred Techs
- Phone
- Do Not Call
- Alt Phone
- Address
- City
- State
- Postal Code
- Country
- Address
- City
- State
- Postal Code
- Country
- Customer Type
- Tags
- Part Tax Code
- Discount Fee
- Notes
- Customer Profile
- Customer Group
- Account Manager
- Currency
- Account Name
- Routing No
- Account No
- Payment Method
- Credit Limit
- On Stop
- Vendor Order No Required
- Archived
- Sites
- Email
- Cell Phone
Action
Write
- CustomerRequired
- SiteRequired
- Cost CenterRequired
- Customer Contact
- Additional Contacts
- Site Contact
- Description
- Notes
- Salesperson
- Project Manager
- Technicians
- Date Issued
- Due Date
- Validity Days
- Order No
- Name
- Stage
- Year
- Month
- Percent
- Status
- Tags
- Auto Adjust Status
- Catalog
- Billable Status
- Estimated Time
- Fit Time
- Base Price
- Markup
- Sales Tax Code
- Sell Price
- Quantity
- Income Account
- Type
- Rate
- Markup
- Sales Tax Code
- Time (Hours)
- Income Account
- Type
- Billable Status
- Description
- Estimated Cost
- Markup
- Estimated Time
- Sales Tax Code
- Actual Cost
- Actual Cost Date
- Sell Price
- Quantity
- Income Account
- Prebuild
- Billable Status
- Estimated Time
- Fit Time
- Base Price
- Markup
- Sales Tax Code
- Sell Price
- Quantity
- Income Account
- Service Fee
- Billable Status
- Fit Time
- Base Price
- Markup
- Sales Tax Code
- Sell Price
- Income Account
Action
Write
- NameRequired
- Address
- City
- State
- Postal Code
- Country
- Address
- City
- State
- Postal Code
- Billing Contact
- Contact
- Title
- Given Name
- Family Name
- Email
- Work Phone
- Cell Phone
- Fax
- Position
- Preferred Notification Method
- Public Notes
- Private Notes
- Zone
- Preferred Technicians
- Customers
- STC Zone
- VEEC Zone
Action
Write
- ID
- Order No
- Name
Action
Search
- ID
- Name
- Address
- City
- State
- Postal Code
- Country
Action
Search
- ID
- Phone
- Cell Phone
- Alt Phone
- Email
Action
Search
- ID
- Email
- Work Phone
- Cell Phone
- Alt Phone
- Title
- Given NameRequired
- Family Name
- Fax
- Department
- Position
- Notes
Action
Search or write
- ID
- Company NameRequired
- Phone
- Alt Phone
- Email
- EIN
- Website
- Fax
- Company Number
- Preferred Techs
- Do Not Call
- Address
- City
- State
- Postal Code
- Country
- Address
- City
- State
- Postal Code
- Country
- Customer Type
- Tags
- Part Tax Code
- Discount Fee
- Notes
- Customer Profile
- Customer Group
- Account Manager
- Currency
- Account Name
- Routing No
- Account No
- Payment Method
- Credit Limit
- On Stop
- Vendor Order No Required
- Archived
- Sites
Action
Search or write
- BaseRequired
- TableRequired
- Limit to View
- Include file contents?
Trigger
Scheduled
Try It
- BaseRequired
- TableRequired
Action
Write
- BaseRequired
- TableRequired
- Lookup FieldRequired
- Secondary Lookup Field
Action
Write
- BaseRequired
- TableRequired
- RecordRequired
Action
Write
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search for Exact Match?
- Search Formula
- Limit to View
- Include file contents?
- Max Records
Action
Search
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search for Exact Match?
- Search Formula
- Limit to View
- Include file contents?
- Max Records
Action
Search or write

Company Customer Updated
Triggers when a company customer is updated.
Trigger
Instant
Try It
Individual Customer Updated
Triggers when an individual customer is updated.
Trigger
Instant
Try It
Job Updated
Triggers when a job is updated.
Trigger
Instant
Try It
Quote Updated
Triggers when a quote is updated.
Trigger
Instant
Try It
Schedule Updated
Triggers when a job, lead, quote or activity schedule is updated.
Trigger
Instant
Try It
Site Updated
Triggers when a site is updated.
Trigger
Instant
Try It
- Title
- Given NameRequired
- Family Name
- Email
- Work Phone
- Fax
- Cell Phone
- Department
- Position
- Notes
- Alt Phone
Action
Write
- CustomerRequired
- SiteRequired
- Cost Center
- Customer Contact
- Additional Contacts
- Site Contact
- Order No
- Name
- Description
- Notes
- Date Issued
- Due Date
- Due Time
- Tags
- Salesperson
- Project Manager
- Technician
- Stage
- Status
- Response Time
- Auto Adjust Status
Action
Write
- StaffRequired
- Date
- Start TimeRequired
- End TimeRequired
- Schedule RateRequired
- Notes
- Locked
- Type
Action
Write
- ID
- Email
- WorkPhone
- CellPhone
- AltPhone
Action
Search
- ID
- Staff
- Date
- Type
Action
Search
- ID
- Company Name
- Phone
- Alt Phone
- Email
- EIN
- Website
- Fax
- Company Number
Action
Search
- ID
- Order No
- Name
Action
Search
- ID
- NameRequired
- Address
- City
- State
- Postal Code
- Country
- Address
- City
- State
- Postal Code
- Billing Contact
- Contact
- Title
- Given Name
- Family Name
- Email
- Work Phone
- Cell Phone
- Fax
- Position
- Preferred Notification Method
- Public Notes
- Private Notes
- Zone
- Preferred Technicians
- Customers
- STC Zone
- VEEC Zone
Action
Search or write
- ID
- Phone
- Cell Phone
- Alt Phone
- Email
- Title
- Given NameRequired
- Family NameRequired
- Preferred Techs
- Do Not Call
- Address
- City
- State
- Postal Code
- Country
- Address
- City
- State
- Postal Code
- Country
- Customer Type
- Tags
- Part Tax Code
- Discount Fee
- Notes
- Customer Profile
- Customer Group
- Account Manager
- Currency
- Account Name
- Routing No
- Account No
- Payment Method
- Credit Limit
- On Stop
- Vendor Order No Required
- Archived
- Sites
Action
Search or write
- BaseRequired
- TableRequired
- Help Text
- Which timestamp field should this Zap use to check for updates?Required
- Limit to View
- Include file contents?
Trigger
Scheduled
Try It
- Cache Copy
- BaseRequired
- TableRequired
Action
Write
- BaseRequired
- TableRequired
- RecordRequired
Action
Write
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search for Exact Match?
- Search Formula
- Limit to View
Action
Search
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search for Exact Match?
- Search Formula
- Limit to View
Action
Search or write

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 Help

Related categories

Databases

Similar apps

About Simpro

Simpro is a field service and job management software package. Optimize workflow processes & field service operations for trade businesses.

Help

Related categories

Project Management

Related Zap Templates

Create records in Airtable for new sites in Simpro

Manage new or updated Airtable records by creating schedule blocks in Simpro

Airtable + Simpro

Create or update Airtable records when new jobs are added in Simpro

New Company Customer

New Individual Customer

New Job

New Quote

New Schedule

New Site

Create Company Customer

Preferred Techs

Phone

Do Not Call

Alt Phone

Address

City

State

Postal Code

Country

Address

City

State

Postal Code

Country

Customer Type

Tags

Part Tax Code

Discount Fee

Notes

Customer Profile

Customer Group

Account Manager

Currency

Account Name

Routing No

Account No

Payment Method

Credit Limit

On Stop

Vendor Order No Required

Archived

Sites

Email

EIN

Website

Fax

Company Number

Create Individual Customer

Title

Preferred Techs

Phone

Do Not Call

Alt Phone

Address

City

State

Postal Code

Country

Address

City

State

Postal Code

Country

Customer Type

Tags

Part Tax Code

Discount Fee

Notes

Customer Profile

Customer Group

Account Manager

Currency

Account Name

Routing No

Account No

Payment Method

Credit Limit

On Stop

Vendor Order No Required

Archived

Sites