Others

How to Assign Staff Based on Custom Fields in Microsoft Bookings

Rana Garcia Oct 10, 2026 870 views

Question details

The user wants to know if Microsoft Bookings can automatically route and assign specific staff members based on a value selected by the customer in a custom field, such as a specific region.

How to Assign Staff Based on Custom Fields in Microsoft Bookings

Product: Microsoft Bookings
Device & OS: not provided
Scenario: Configuring staff assignment logic for a booking page to direct customers to the correct personnel based on customized form inputs.
Observed behavior: Microsoft Bookings does not natively support automatic staff assignment tied directly to custom field selections.

Before you start

Ensure you have Administrator access to the Microsoft Bookings calendar and familiarize yourself with the current services and staff list configurations.

Solution 1Recommended

Create Separate Services for Each Custom Field Option

Since native custom field routing isn't supported, creating distinct services for each region or category allows you to pre-assign the correct staff members to each service.

This is the most straightforward workaround. Instead of asking the customer to select their region from a dropdown custom field within a single service, you create a unique service for each region. Customers will select the service that applies to them right from the main booking page.

Add a new service

Navigate to the Services page in your Microsoft Bookings dashboard and click on 'Add new service'.

Name the service by category

Name the service based on the specific region or custom criteria (e.g., 'Initial Consultation - North Region').

Assign specific staff

In the Assign staff section, select only the staff members who are responsible for that specific region or category.

Save and repeat

Click 'Save changes' and repeat this process for all other regions or custom field values you need to accommodate.

Create Separate Services for Each Custom Field Option

Clearer Customer Experience: This method ensures customers always get scheduled with the correct staff member without needing complex backend automation.

Solution 2

Automate Staff Assignment Using Power Automate

Build a custom workflow using Microsoft Power Automate to process bookings and update assignments based on submitted form data.

Solution 3

Manually Reassign Staff After Booking

Allow customers to book without specific staff, and have an administrator manually assign the correct staff member based on the custom field response.

Free Microsoft Office alternative

Boost Your Productivity with WPS Office

While Microsoft Bookings handles your scheduling needs, you may need a reliable office suite to process exported booking data, analyze regional reports, and draft customer communications. WPS Office provides a free, lightweight, and fully compatible alternative to Microsoft Office for all your document and spreadsheet tasks.

1. Download the installer: Visit the official WPS Office website and download the free installation package for your operating system.
2. Install WPS Office: Run the installer and follow the simple on-screen instructions to set up the software on your device.
3. Open booking reports: Export your booking data from Microsoft Bookings as a TSV/Excel file, and open it instantly in WPS Spreadsheet for fast analysis.

Seamlessly open, edit, and save Microsoft Excel (.xlsx) files to analyze your exported booking data.Free and lightweight alternative to heavy productivity suites.Familiar, easy-to-use interface ensures a seamless migration with no learning curve.All-in-one suite featuring Writer, Spreadsheet, Presentation, and advanced PDF tools.

Frequently Asked Questions

Can customers choose their preferred staff member in Microsoft Bookings?

Yes. You can enable this by going to the Services settings in your Bookings dashboard and toggling on the 'Allow customers to choose a specific person for the booking' option.

How do I add custom fields to a Microsoft Bookings page?

Navigate to the Services tab, select your specific service, and click on 'Custom fields'. From there, you can add text questions or drop-down questions to collect customized information from your clients.

Can I export Microsoft Bookings data to Excel?

Yes, you can export up to 120 days of booking data. Click on 'Export 120 day view using a TSV file' from the Bookings home page. This file can be easily opened and analyzed in Microsoft Excel or WPS Spreadsheet.

Office Quick Solutions