How to Create and Manage Custom Tables

How to Create and Manage Custom Tables

How to Create and Manage Custom Tables in Delivra

Creating a custom table in Delivra allows users to extend their contact data and better manage structured information. This section provides a step-by-step guide to creating and managing custom tables efficiently.

Steps to Create a Custom Table

  1. Navigate to Settings Dashboard.

  2. Select Data Setup > Custom Tables. This menu provides access to the custom tables section, where you can create, modify, and manage additional data tables.

  3. Click Create Custom Table. This action will start the process of setting up a new table.

  4. Choose between a Standard Table or a Custom Table. Standard tables include predefined structures suited for common use cases, while custom tables provide flexibility to define unique data structures.

  5. Name your table. Choosing a descriptive name will help identify the table’s purpose and make it easier to manage in the future.

  6. Select the relationship type (One-to-One, One-to-Many, etc.). Understanding the correct relationship type ensures the table functions as intended.

  7. Define fields by manually entering names and selecting field types. Fields represent the columns in your table and should be named logically based on the type of data they will store.

  8. Upload a CSV file if needed. If you have pre-existing data, you can import it using a CSV file to populate your new table.

  9. (One-to-Many) Set the Primary Key carefully. If you are using a One-to-Many table, then you will need to select a primary key. The primary key uniquely identifies each record in the table, so selecting an appropriate key (such as Order Number instead of Email Address) is crucial.

  10. Click Save. Once saved, fields cannot be edited but additional fields can be added later.

Managing Custom Tables

  • Ensure correct administrator permissions. Only users with appropriate permissions can create and modify custom tables, so it’s essential to verify user access levels.

  • Consult your Client Success Manager before making changes. Making changes to a custom table can impact workflows, segmentation, and automation; consulting an expert can prevent disruptions.

  • Keep tables simple. When dealing with complex data relationships, consider using additional tables to keep your tables from becoming difficult to manage.

    • Related Articles

    • Using Custom Tables in Delivra

      Custom tables solve various data challenges, allowing businesses to store and organize information effectively. By leveraging custom tables, companies can improve data management, enhance segmentation, and personalize marketing efforts. Key Use Cases ...
    • Introduction to Custom Tables in Delivra

      Custom tables in Delivra provide a flexible way to store and manage structured data beyond the default contact record. This article introduces the concept of custom tables, their benefits, and when they should be used. What is a Custom Table? A ...
    • Understanding Table Relationships in Delivra

      Custom tables in Delivra support different types of relationships based on data needs. Choosing the right table relationship is crucial for ensuring efficient data retrieval and management. Table Relationships One-to-One Relationship In a one-to-one ...
    • Populating your Custom Tables with data

      Importing data into custom tables is essential for keeping records up to date and integrating data from external sources. This section covers different import methods and best practices. Import Methods CSV Imports: This manual method allows users to ...
    • Using Many-to-Many Relational Tables in Delivra

      Sometimes your data is more complex and multiple records in each table can relate to multiple records in another table. This is where Many-to-Many relationships can help. Many-to-many relationships make use of a junction table to help relate your two ...