/
/
See late and unscheduled Salesforce field work in one list
For dispatchers who want overdue and unscheduled work orders, and the parts they need, found before the visit, by asking their AI assistant.
On this page
Connector
Connect Salesforce, pick your AI tool and paste the prompt.
The problem
Field work that slips without anyone noticing
Field work slips when work orders sit in Salesforce without an appointment, or appointments pass their due date unnoticed. Dispatchers piece the backlog together from separate views, and parts needs surface only when a technician arrives without them.
Without PopdockAI
- Check the work order view and the appointment view separately
- Spot past due appointments by scrolling
- Find work orders with no appointment by hand
- Learn about missing parts on site
With PopdockAI
- Open work orders and appointments due in 30 days are read
- Past due and unscheduled items are flagged
- Parts needed are summed by product
- Read only, and it says so when nothing is open
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Show the field service backlog, optionally for account `{account-name}`, and flag what is late or unscheduled.
**Step 1: Pull open work**
* Call `salesforce-get-work-order` with `account-name.contains` set to `{account-name}` when given, `max-records` 500. Keep those whose status-category is not Completed, Closed or Canceled.
* Call `salesforce-get-service-appointment` with the same account filter and `due-date.to` set to 30 days from today.
**Step 2: Flag**
* Appointments past their due date and not completed.
* Appointments with no scheduled start.
* Work orders with no appointment (match appointment parent-record-id to work-order-id).
* For the flagged work orders, call `salesforce-get-work-order-line-item` with `work-order-id` to list the products and quantities needed.
**Step 3: Report**
* Counts by status and priority.
* A table of flagged items: work order number, account, subject, priority, status, due date, scheduled start, flag.
* Parts needed across the flagged work orders, summed by product.
**Rules & Guidelines:**
* This prompt is read-only. Do not call any write tool: `salesforce-add-account`, `salesforce-add-contact`, `salesforce-add-lead`, `salesforce-add-opportunity`, `salesforce-add-case`, `salesforce-add-task`, `salesforce-add-asset`, `salesforce-add-campaign`, `salesforce-update-account`, `salesforce-update-contact`, `salesforce-update-lead`, `salesforce-update-opportunity`, `salesforce-update-case`, `salesforce-update-task` or `salesforce-update-asset`.
**Validation:**
* If nothing is open, say so and stop.Who it's for
One answer, three teams that use it
Dispatchers
See what needs scheduling today
Get the late and unscheduled work in one list instead of piecing it together from two views.
Which Salesforce work orders have no service appointment yet, and which appointments are past due?
Field service managers
Keep the backlog under control
Counts by status and priority show where field work is slipping.
Review the field service backlog for the next 30 days by status and priority.
Parts coordinators
Order parts before the visit
See the parts needed for flagged work orders, summed by product, ahead of time.
What parts do the late and unscheduled work orders for Northwind Traders need?
How it works
What PopdockAI does when you ask
You optionally name an account, and your AI assistant reviews the open field service backlog. It flags what is late or unscheduled and changes nothing.
01
Ask
You optionally name an account.
02
Read
It reads open work orders and appointments due in the next 30 days.
03
Flag
It flags past-due and unscheduled appointments and work orders with none.
04
Report
You get counts, flagged items and parts needed by product.
What PopdockAI provides
The tools behind the answer
Ready made tools for Salesforce and one secure connection to your AI tool. No code, no exports.
salesforce-get-work-order
salesforce-get-service-appointment
salesforce-get-work-order-line-item
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
Late and unscheduled work in one list, parts included
Related use cases
More ways to put this data to work
Add Salesforce campaign members to a Constant Contact list
Ask your AI to add Salesforce campaign members to a Constant Contact list and it adds only the new people after you confirm, excludes unsubscribes and leaves consent unset unless you say otherwise.
Learn More
Add Salesforce campaign members to a Drip campaign
Ask your AI to add Salesforce campaign members to a Drip campaign and it skips existing and unsubscribed people, flags a paused campaign or double opt-in, and adds people only after you confirm.
Learn More
Add Salesforce campaign members to a Mailchimp audience
Ask your AI to add Salesforce campaign members to a Mailchimp audience and it adds new people as pending for double opt-in, skips anyone already there, and writes only after you confirm.
Learn More
Advance a Salesforce opportunity
Ask your AI to advance a Salesforce opportunity and it sanity checks the stage change and close date, updates only changed fields after you confirm, and offers a follow-up task.
Learn More
Capture a new Salesforce lead
Ask your AI to add a lead to Salesforce and it checks existing leads, contacts and accounts first, then creates the lead or updates the existing one only after you confirm.
Learn More
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.