Data table

A table contains a list of items of the same type—like people, ideas, or objects. If your app is tracking different types of items, it'll probably make sense to have multiple tables. For example, an app for a sales pipeline could have separate tables for sales leads, companies, and deal opportunities, whereas an app for planning a wedding could have separate tables for potential venues, attendees, and wedding registry items.

Each row that you see in the grid is called a record. A record is an individual item in a table and could be many different things: for example, if you're making a table of tasks that need to be completed, then each row in your table is a task; if you're brainstorming a list of new ideas, then each row in your table is a new idea.

The columns of the tables are called fields. Each field has a special field type that determines what kind of rich information you can put in it, like long text notes, drag and drop file attachments, checkboxes, dropdown select options, and more. You can add a new field by clicking the ‘+’ button in the header row.

If you change a field with existing cell values into a new field type, Nodezap does its best to convert those existing cell values to the new type.

• Text: The text field is best for short, unique pieces of text, such as the names of your friends, the names of your cats, or the names of your friends' cats.
• Number: The number field type is a field type designed to hold numbers. The number field type is a general-purpose field type for most numerical values, like the number of chairs of a particular type your furniture business has in stock, or the distance in kilometers from one city to another city.
• Boolean: A boolean field is useful for true/false values within a record.
• Date: A date field allows you to easily enter a date and optionally a time into a cell. When editing a date-time, you will be presented with a calendar widget that makes it easy to select a specific date.
• Attachment: An attachment field is a type of field that allows you to attach one or more files directly to your records.
• Collaborator: The collaborator field allows you to select one or more names from an automatically generated dropdown list of all the collaborators with whom your app is shared.
• Object: An Object field type allows you to save JSON/object values within a record. An object is a standalone entity that holds multiple values in terms of properties and methods.
• Array: Ann array field type allows you to save an array of any type. An Array is a Linear data structure that is a collection of data items stored in contiguous memory locations.
• Single Select: The single-line text field is best for short, unique pieces of text, such as the names of your friends, the names of your cats, or the names of your friends' cats. The options of these can be only defined by the widgets using these data tables.
• Multi-Select: A multi-select field is similar to a single select field; it allows you to select predetermined options from a list. Unlike a single select field, however, you can select as many options as you'd like per cell. However, in the data table, multi-select fields are just an array of strings. The options of these can be only defined by the widgets using these data tables.

In the day-to-day world, data is not always centralized. That is to say, there are a lot of sources that generate data. These data can be utilized effectively only when all the data is available as one data source. The most common form of data we see is in CSV files.

CSV upload feature helps you combine data from different sources into your single data table. Once your data is uploaded, it can be used in your application.

We see a lot of challenges when it comes to data integration since different data sources use different terminologies for the same information. We provide a very simple and elegant way to specify the alias while importing the data.