Custom Tables
Purpose: To show you how to add a custom table in your BambooHR account.
Important: If you have the Core or Pro package, you can create custom tables using our custom table builder, as described in this help guide.
If you have the Advantage package, the Account Owner or Full Admin user can submit a request to our Customer Support team to add a custom table. Before submitting a request, please review our guidelines to ensure your request meets them and includes all necessary information for the customization. Interested in upgrading your package? Click here for more information!
A custom table tracks historical changes or multiple lines of data that are currently relevant to an employee. A custom table can include any of the field types listed here, except for the section header, multiple selection list, and information fields. You can add a custom table through the employee profile or Settings > Custom Fields & Tables.
Need customization ideas? BambooHR offers several customization options for storing your data and creating a system that can help you track the information that is important to your company and your employees. Watch this video for some ideas on what you can track in BambooHR.
Add a custom table
Custom tables can only be added to Personal, Job, Benefits, Training, and custom tabs.
Employee profile
On the employee profile, select which tab you want to add a custom table to. On the specified tab, click Customize Layout and then *Add Custom Table from the dropdown menu.
*If you select Reorder Fields, you will also be able to add a custom table within the Manage Fields & Tables pop-up box.
Custom table builder
Within the custom tab builder, you will first need to determine if you want the table to store and track information in a general or historical layout. Our Standard vs. Historical Tables help guide has more information about these two table types. After making your selection, click Create a New Table.
The General Layout option will open the custom table builder with several settings you can use to create your custom table.
- *Table Name: Add a name for the custom table.
- Employee Tab: This will tell you which tab on the employee profile the custom table will appear on. If you want to change the tab, simply click Change and select a new tab.
-
Columns: This section is where you can add as many columns as needed to the custom table. Click Add to create a new column.
- Name: Each column will have a header name. Add a name for the column.
- Type: Select which field type should the column be (e.g., Date, Multiple Answers, etc.). Then, click Done to save the new column.
- Sort by: The two dropdown menus will allow you to determine how you want information sorted in the custom table. Options in first the dropdown menu will include any of the columns you added. Depending on the column you select, determine in which order the information should be sorted—A to Z, Z to A, Oldest first, or Newest first.
- Preview: A preview of the custom table will appear next to the settings. This feature dynamically updates to reflect any changes or additions you make in the custom field builder. Please note that the data displayed is solely for preview purposes and will not appear once you publish the custom table.
- Acknowledgment: It is important to acknowledge your responsibility in creating the custom table by ensuring that it is not a duplicate, privacy issue, or legal no-no. If you have more questions, please reach out to our Customer Support team.
- Save: Once all the table settings look correct, click Save to add the custom table. Your employees will not have automatic access to the table, allowing you to determine who can view the table information through access level settings.
*Please note the system will prevent the addition of a custom table that has the same name as an existing standard or custom table in your account.
If using the Historical Layout option, two settings will be different from the General Layout option—Columns and Sort By. The Columns section will automatically add a date column since the table will sort information in chronological order. Because of its default setting, you cannot delete the date column, but you can edit the column name. Sort By only provides the option to sort information by Oldest first or Newest first based on dates entered in the custom table.
The following are more settings you can use to create your custom table.
- *Table Name: Add a name for the custom table.
- Employee Tab: This will tell you which tab on the employee profile the custom table will appear on. If you want to change the tab, simply click Change and select a new tab.
-
*Columns: This section is where you can add as many columns as needed to the custom table. Click Add to create a new column.
- Name: Each column will have a header name. Add a name for the column.
- Type: Select which field type should the column be (e.g., Date, Multiple Answers, etc.). Then, click Done to save the new column.
- Sort by: The two dropdown menus will allow you to determine how you want information sorted in the custom table. Since you are creating a historical table, the only options in the first dropdown menu will be date columns. In the next dropdown menu, determine in which order the information should be sorted—Oldest first or Newest first.
- Preview: A preview of the custom table will appear next to the settings. This feature dynamically updates to reflect any changes or additions you make in the custom field builder. Please note that the data displayed is solely for preview purposes and will not appear once you publish the custom table.
- Acknowledgment: It is important to acknowledge your responsibility in creating the custom table by ensuring that it is not a duplicate, privacy issue, or legal no-no. If you have more questions, please reach out to our Customer Support team.
- Save: Once all the table settings look correct, click Save to add the custom table. Your employees will not have automatic access to the table, allowing you to determine who can view the table information through access level settings.
*Please note the system will prevent the addition of a custom table that has the same name as an existing standard or custom table in your account.
Grant access to a custom table
Once you add a custom table, it will not be automatically visible to employees. The only users who have automatic access are Full Admin users and Account Owners. If you need to grant users access to the table, navigate to Access Levels, select the specific access level and click Access Level Settings.
Under "See about Themselves," find the custom table under its applicable tab. Depending on the access level you are viewing, access options include No Access, View Only, Edit—Approval Required, and Edit.
In the example above, I added a custom table named "Certifications" to the Job tab, and it is automatically set to No Access for employee access level users. I can either edit users' access to the whole table or specific fields within the table.
Edit or archive a custom table
To edit or archive a custom table, navigate to Custom Fields & Tables and select the tab with the custom table. Then, hover your cursor over the table name to view two options.
1. Edit
Click on the pencil icon to open the custom table builder for editing.
If you want to delete a column that has data stored, a warning message will appear. Deleting a column from a custom table will erase all associated data for that column. Once you proceed with the deletion, data will be rendered irrecoverable. You must confirm the deletion by typing Delete and then clicking Yes, Delete [Column Name].
A dialog box will appear if you edit a list of options with associated data within a column. The highlighted number next to a list option indicates how many employees have it assigned to them. In the example above, one employee has the list option "Project Management" assigned to them in the Certifications table on their employee profile.
Within the dialog box, the system will ask you if you want to change the list name from this point and forward it in BambooHR, preserving the history OR change the list name everywhere in BambooHR, including the history. Before you determine this setting, we highly recommend reviewing this help guide for more information.
2. Archive
Archiving a custom table will remove the table from anywhere it appears, but all of its data will be saved in your account. Click on the file box to archive the custom table. You will need to confirm the action by clicking Yes, Archive this Custom Table. For how to restore an archived table, please review the following section.
If preferred or required, you can submit a custom table request. With each request, our Customer Support team considers if the requested table would be user-friendly and set you up for long-term success in BambooHR. Please note that we may not be able to fulfill your customization request if it would not provide a great user experience or would put your data at risk. The following examples are what we will not create customizations for:
- Usernames and passwords
-
Full credit card numbers
- We only store the last four digits.
- Bank PIN
- Custom Social Security or personal identifying numbers
- Custom Time Tracking tabs and fields
- Custom Performance tabs and fields
-
Custom development work
- BambooHR does not provide custom development work to alter your account.
-
Editing existing standard fields tables
- We need to keep those consistent for filtering purposes.
Our Customer Support team can add custom tables upon request from a Full Admin user or the Account Owner. When making a request, it is important to provide our Customer Support team with the following information:
Example
I would like to add a custom table titled "Beneficiaries" to the Benefits tab of my account to better manage and track the beneficiaries designated by employees for various benefits. This table will help us organize this information with the following fields:
- Employee Name
- Beneficiary Name
- Relationship
- Benefit Tyle
- Percentage
- Contact Information
- Notes/Comments