Maintenance tickets: contractor matched by area, dispatched, duplicates caught

The scenario takes a new request from SeaTable, matches a contractor by job type and area, dispatches the job by email and text via Mocean, and confirms to the tenant.

  • A contractor is assigned in seconds, not days
  • Repeat reports of the same issue don't become new tickets
  • The job is sent by email and text — it won't be missed
  • The tenant knows immediately that the request landed

How it works

To move data from SeaTable to Mocean automatically, use a ready-made scenario — no manual exports.

  1. Starts when: Watch for New Records
  2. Then: Search Duplicate tickets
  3. Then: Evaluate Duplicates
  4. Check: Duplicate?
  5. If yes: Update record
  6. Then: Send Duplicate Alert to Admin
  7. If no: Extract Postcode District
  8. Then: Search records
  9. Check: Check if Vendor Found
  10. If yes: Limit
  11. Then: Update Ticket with Assigned Vendor
  12. Then: Send Email to Vendor
  13. Then: Send SMS to Vendor (Twilio)
  14. Then: Send Confirmation to Tenant
  15. If no: Email to Admin - Alert
  16. If no: Send Holding Email to Tenant (Pending Assignment)
  17. If no: Update Ticket - No Vendor Found

You can launch this SeaTable + Mocean integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.