Data Table Templates

Data table templates allow you to create, save, and reuse table structures across multiple studies. This improves efficiency and ensures consistency when working with data tables in Benchling.

Accessing Data Table Templates

To access data table templates, follow these steps:

1. Open a study.
2. Navigate to the Data Tables page.
3. Click on the Templates tab to view all available templates.

There are two types of templates:

• Personal Templates: Created by you, only visible to you.
• Published Templates: Created and shared by an administrator, visible by everyone.

Creating a Data Table Template

To create a data table template, follow these steps:

1. Open or create a new data table.
2. Add columns and structure the table as needed using the Add Columns option.
3. Once satisfied with the structure, click Save as Template.
4. Enter a name for the template.
5. Click Save to store the template for future use.

Using a Data Table Template

To use a data table template, follow these steps:

1. Navigate to a study where you want to use a template.
2. Go to the Data Tables page and select Create New Data Table.
3. Choose Use a Template and select the desired template from the list.
4. Adjust Measurement Mappings if necessary.
   • Ensure the measurement options match between the template and the study.
   • Use the dropdown to select relevant measurement options if they differ.

5. Modify the Reference Date.
   • The system aligns data collection dates with the study’s start date.
   • Adjust the reference date if necessary to shift measurement or observation dates.

6. Select the animals to be included as rows.
7. Click Create to generate the new data table with the selected template.

You can also manually set each of the dates using a date picker.

Editing and Managing Templates

Editing a Template

To edit the name of a template, use the three-dot menu to the right of the template row. Templates cannot be directly edited. Instead, create a new template with updated settings and delete the old version if needed.

Publishing a Template (Admins Only)

To publish a template, follow these steps:

1. Navigate to the Templates tab.
2. Find the template to publish.
3. Click the three-dot menu next to the template.
4. Select Publish to make it available to the entire team.

.

Deleting a Template

To delete a template, follow these steps:

1. Open the Templates tab.
2. Click the three-dot menu next to the template.
3. Select Delete and confirm the action.

Additional Features

Filling Dose or PK Bleed Columns

To fill dose or PK bleed columns, follow these steps:

1. Use the Auto-Fill option to populate timestamps for dosing or PK bleed schedules.
2. Adjust intervals and start times as needed.
3. Overwrite existing timestamps if required.

Filling Missing Data

To fill missing data, follow these steps:

1. Select a column and apply missing timestamps only to empty cells.
2. This will fill with this sequence of timestamps from the first empty cell to the next cell with a timestamp value set.
3. This may need to be repeated multiple times to fill all empty timestamp cells.

Troubleshooting

• If measurement columns don’t align, check study-specific measurement options and adjust accordingly.
• If timestamps shift unexpectedly, verify the Reference Date settings.
• If templates are missing, confirm that they are either personal or published and accessible under the Templates tab.
• For further assistance, contact Benchling support.