The Key Column Feature in Boost.space
Boost.spaceA platform that centralizes and synchronizes company data from internal and external sources, offering a suite of modules and addons for project management, CRM, data visualization, and more. Has many features to optimize your workflow! includes a powerful feature called the Key ColumnIn Boost.space, the Key Column is a designated field that uniquely identifies records within a space. It is essential for data consolidation, as it determines how data from various sources is merged into a single record. For instance, selecting 'email' as the Key Column ensures that any incoming data with the same email address updates the existing record rather than..., which enables data from various sources to be merged into a single itemItems are rows in records (order/request/invoice/purchase...) in the database. This creates a unified and consistent recordIn Boost.space, a record is a single data entry within a module, like a row in a database. For example, a contact in the Contacts module or a task in the Tasks module..
How the Key Column Works
The Key Column feature is primarily used for data consolidationA Boost.space feature that merges data from multiple sources, allowing integration of diverse datasets into a unified view. Using API token prioritization, it determines which data sources overwrite others, ensuring accuracy and consistency across your system.. By selecting a Key Column, the system knows how to merge data from different sources into a single record in the database.
Key Benefits of the Key Column:
- Flexibility: You can choose a different Key Column for each spaceIn Boost.space, a space is a subunit within a module that helps organize and categorize data, ensuring clarity even with large volumes. For example, within the Contacts module, you might have spaces like "Client Database" or "Supplier Database." Access to each space is restricted to users who have created it or have been granted access. based on your needs.
- Data Integrity: Avoids duplication by merging your recordsIn Boost.space, a record is a single data entry within a module, like a row in a database. For example, a contact in the Contacts module or a task in the Tasks module..
Key Column and Import/Export Processes
The Key Column is crucial during the import and export processes:
- Importing Data:
- Maps imported data to the corresponding columns in Boost.space using the Key Column.
- Ensures accurate merging or creation of records.
- Exporting Data:
- Uses the Key Column to organize and structure exported data, maintaining consistency across systems.
This process minimizes errorsService is unavailable due to a failure, a service responds with unexpected data or the validation of input data fails. and ensures seamless integration between Boost.space and external systems.
Example of Using the Key Column
Let’s look at a real-world example with contacts:
- You set Email as your Key Column for a contact space.
- When you add a new contact with the email
[email protected]:- If the email already exists, Boost.space will merge the new data with the existing record.
- If the email doesn’t exist, a new record will be created.
This functionality ensures that duplicate records are avoided while maintaining a unified database.
Conclusion
The Key Column is an essential feature for managing data in Boost.space. By consolidating records, preventing duplication, and ensuring accurate imports/exports, it enhances data integrity and streamlines your workflows.
Start using the Key Column today and experience the benefits of a unified database!
If you will need any help along the way please contact us at [email protected]