This can quickly become tedious and repetitive and incur needless, manual errors. Say you need to edit Customer John Simond's name, you would need to edit his name throughout each job record that includes this customer's name field. Each job record includes the Customer N ame, Phone, and Email fields to display the customer's information. Using connection fields to connect records can also save a significant amount of time when editing existing information.įor instance, if you are tracking your Customers and Jobs with a traditional spreadsheet, this is how your Jobs spreadsheet may appear:Īs you can see in the image above, there are three jobs, each with the same customer, "John Simonds". To automate and expedite updating existing information Using connection fields to connect records will save you invaluable time when adding new records and it can also reduce errors that come from repeated manual data re-entry. With a traditional spreadsheet, you would have to re-enter the company's information from scratch every time you add new contact. Doing so would enable you to save a significant amount of time when adding new information because every time you add a new contact you can simply select the company that the new contact works while simultaneously viewing all that company's information. Using connection fields to connect records saves a significant amount of time when adding new information.įor instance, if you would like to track all your contacts and the companies they work for, you can create a Contacts data table and a Companies data table and use a connection field to connect the records within both data tables. To automate and expedite adding new information Let's explore some of the key benefits of using connection fields to connect your records. Connections are what empowers you to take your data to the next level and what supercharges your data for faster and easier summarizing, tracking, calculating, reporting, and automation of all your business information. While Tadabase does an excellent job of storing your data, your data can't do much just sitting there in storage. The ability to connect records reflects the core power of database applications and the primary reason why businesses seek database applications over traditional spreadsheets. Unlike spreadsheets, r ecords within data tables can be connected to records within other data tables using a Connection Field. Now that we've explained the similarities between a data table and a spreadsheet, let's explain how a data table and a spreadsheet differ and how these differences outline the very reasons why it is essential to use database applications over traditional spreadsheets. To sum the comparison of how Tadabase structures data similarly to spreadsheets, users can think of data tables as spreadsheets, fields as columns, and records as rows. In this way, records in a data table in Tadabase are similar to rows in a spreadsheet. Just as each row in a spreadsheet displays the collection of columns to form a single Customer record, a record in a Tadabase data table displays the collection of fields to form a single Customer record as well. Similarly in Tadabase, a data table titled Customers would contain fields including First Name, Last Name, Email, and Gender, and the collection of these fields define the Customers data table. Each column refers to a basic item of information that describes a customer, and the collection of these columns defines the Customers spreadsheet. In a spreadsheet titled Customers, there may be columns including First Name, Last Name, Email, and Gender. Click here to learn more about fields.Ī data table is a collection of common fields, similar to how a spreadsheet is a collection of common columns. Each item of information is referred to as a field, and all fields grouped together form a Companies data table. A Data table is a collection of fields that comprise a common group.įor instance, a Companies data table would consist of a collection of basic information that would define each company, including Company Name, Company Address, Company Website, etc.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |