Linked Records


In viaSocket Tables, the Linked Records feature stands out for enhancing data organization and relationship management. Linked Records allow users to link tables, this feature not only streamlines data management but also unlocks numerous benefits for users seeking efficient and organized workflows.

                   

 

Benefits of Linked Records:

  1. Relationship Creation: Using linked records, users can create connections between different data points in different tables.  This capability is invaluable for organizing complex datasets where information is interconnected. 
  2. Streamlined Data Access: Instead of sifting through multiple tables or documents to find associated data, Linked Records provide a centralized hub where interconnected information is easily accessible. This streamlines workflows and reduces the time spent navigating through datasets, thereby boosting productivity.
  3. Enhanced Cooperation: By giving team members a common platform to work with connected data, linked records promote cooperation. This collaborative environment promotes transparency and facilitates communication, leading to better outcomes for teams.
  4. Data Consistency: Linked Records promote data consistency by ensuring that changes made to linked information are reflected across all associated records. Users can rely on Linked Records to keep their data synchronized and up-to-date, minimizing the risk of discrepancies or errors.

How to Use Linked Records:

First, users need to add a new column to their existing record, then select Link in the property type box. 

  • Choose table_2 to establish the connection with, then select the prebuilt autonumber column of that table. Now users can view the data in the linked table by using Lookup property type.
  • Click on add another column, select Lookup property type and then choose the column that will be linked with the table_1.
  • Now users can view the contents of another table, by entering the autonumber of table_2 in the linked records column in table_1.

By enabling users to establish relationships between records in different tables, this feature empowers users to unlock the full potential of their data, leading to more informed decision-making and improved productivity. Whether managing projects, tracking sales, or maintaining customer relationships, Linked Records provide a robust framework for organising and leveraging interconnected data effectively.