Add, Edit, or Delete Options in a Dropdown List
How do I add, edit, and delete an option in a dropdown list?
Purpose: To teach you how to manage your options for list fields.
List fields allow you to set up the options available for selection. For example, you want your employees to select their t-shirt size. For a T-Shirt Size field, you can set up the options as Small, Medium, Large, etc., which will keep the list clean and consistent. (Custom fields are only available in the Advantage, Core, and Pro packages.)
This ability is useful for list fields on the Job tab as the options are important filters in the system. Therefore, keeping options for each list field clean and consistent helps you avoid errors when filtering reports, company announcements, etc.
Employee fields
You can manage options for a list field by navigating to Settings > Employee Fields. The first section includes all standard list fields, and the second section includes all custom list fields.
Select to which list field you would like to add options. Type in your new option and click Add. Next time you update this field on an employee profile, you will see the new option in the field's dropdown list.
There are a few things to note about some of the list fields available on the Employee Fields page:
- Employment Status: If you have ACA tracking enabled in your account, you will need to select the ACA status when creating a new employment status. Additionally, you can edit an employment status field to add the FTE (full-time equivalent) for the associated employment status. 1.0 is equal to one full-time worker.
- Job Title: If you are located in the United States, you can set up EEO categories for each of your job titles. These categories will show up in the EEO-1 report and the EEO Details report.
- Location: When adding new locations, you will need to enter the address details for each location. If a location is remote, you can check the box next to "This location is for remote employees," and you will no longer need to enter address details. Instead, the address will appear as "Remote Location."
You can also add new options when updating a list field on an employee profile. Select Add New Option in the dropdown list and add the new option immediately.
To edit options for a list field, hover over an option and click on the pencil icon. When editing an option, you will need to determine how the change should occur (see below).
Change for future but leave history alone
If you pick Change for future but leave history alone, the edit will only apply to future changes to the field. Historical data for this option will remain as the previous option.
In the example above, I changed the Customer Success option to Customer Experience under the Department field. Then, I selected Change for future but leave history alone. This setting means the Customer Success option will no longer appear as an option for the Department field. However, if an employee had the Customer Success option selected in the past, the option will remain in the list under the Department field for that employee.
Change anywhere it is used, including history
When editing the list value, determine how the change should occur. If you pick Change anywhere it is used, including history, the edit will apply to future changes and past historical data. Historical data for this list value in this field will change to the new list value.
In the example above, historical data listed as Customer Success will now change to Customer Experience. All future changes to this field will have the Customer Experience option in the list, and the Customer Success option will no longer be in the list.
Select which list field you would like to delete an option from. Hover your cursor over the option you would like to delete and click on the trash can icon.
If you currently have an employee assigned to this option, you cannot delete it. Instead, you will need to update the employee's information before deleting the option.
If there are no employees assigned to the option, you will need to confirm the deletion. Type Delete and then click Yes, Delete Department. The system will then archive the option, meaning its historical data will remain, but the option will not be available for selection.
If you need to add back the option, enter the original name of the option when adding it to the list field. The system will automatically unarchive the option.
The system will archive a deleted option, and it will remain in the employee's history on their employee profile. The option will still be visible in reporting if it remains in the history.
When you delete a option from a list field, it is no longer an active option. You can filter the report by the archived option when creating or editing the report, but once you run the report, the option will not show since it is no longer active in the account.
In the example above, I am deleting the UX department. The system will archive it, but it will remain in the history for current and previous employees of the UX department.
I ran a historical report with the Department field included, and the report showed employees who were part of the UX department (archived option) in the past.
However, the Department filter does not include the UX department because it is now an archived option.
To filter the report by the UX department, I will need to edit the report and add the archived option before running the report again.
After editing the report to include the archived option (UX department), I was able to run the report again and see the filtered results (see below).