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... Feature in 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!
Boost.space includes a feature called the Key Column. This feature allows you to merge data from various sources into a single itemItems are rows in records (order/request/invoice/purchase...) in the database, creating 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.. It allows for the combination of data from different sources into a single record in the database. This is done by selecting a Key Column that the system will use to merge the data. One unique aspect of this feature is that 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., providing you with flexibility to customize according to your needs.
Key Column and Import/Export Processes
The Key Column plays a vital role during the import and export processes in Boost.space. When you import or export data, the Key Column is used to map your data to the correct columns in Boost.space. This ensures that your data is accurately reflected in the system, reducing the possibility of errorsService is unavailable due to a failure, a service responds with unexpected data or the validation of input data fails. or mismatches.
Example of Using the Key Column
Let’s consider an example with contacts. If you choose email as your Key Column, the system will check if an email is already present in Boost.space before creating a new record. So if you attempt to create a contact with the email [email protected], Boost.space will check if a contact with that email already exists. If it does, the new information will be merged with the existing record. If it doesn’t, a new record will be created.