Items
In Skippet, you can organize your data in databases. Items are records in databases. When viewed in a table, items are simply rows.
For example: in a Projects database, each project corresponds to an item in the database.
Fields
You can save attributes about each item in fields. When viewed in a table, fields are simply columns.
At first, if you create a blank database by yourself (and not with Skippet’s generative AI), you start with just a Name text field, but you can quickly add as many fields as your data needs.
Directions: You can add fields to a view from the Fields section in the settings bar.
Field types
In Skippet you can create different types of fields most suitable for the information being stored.
There are many field types available in Skippet (and we are adding more as we go), and go from simple ones like text fields to advanced ones like related item fields.
For example: in a Projects database, each project item could have:
a Name text field to track the name of the project
a Status select field to track the status of the project
a Start date date field to track the start of the project
a Deadline date field to track the end of the project
a Notes page field to write notes about the project
Coming soon: for now, you can not change the type of a field after you publish it. Making the type always editable is a feature on our radar though, and we will work on an improvement soon.
Single-value field or multi-value list field
After picking a type and naming your field, you can set it to save multiple values by selecting the checkbox “Set as a list to save multiple values”:
checkbox unselected → the field can save only a single value
checkbox selected → the field is a list and can save multiple values
For example: in a Projects database, the Name would be a single-input text field whereas the Files could be a multiple-input file field to allow for multiple values since each project might be associated with more than one file.
Field settings
Last but not least, you can configure the settings of the field. Each field has different settings that change according to the chosen type, and let you further customize:
the behavior of the field
the format of the data saved in the field
For example: in a Projects database, the Deadline date field could save either a date or a date and a time, according to your needs.
Related item field
Related item fields are a special type of field that enables you to relate items to items from other views in Skippet, or to items from the same view. When you create a related item field you can pick which view you want to pull the items from.
For example: in a Tasks database, an Associated project related item field could show which project a task is assigned to.
View links and embeds
You can add view links or view embeds within a field. This allows you to easily access items from other views without switching contexts and leaving the current view. You can also set a filter to show just the right items from the source view based on your current view and its items.
For example: in a Clients database, you may want to see or navigate to all the projects done for a specific client.
What’s next?
You can view the items in your databases through different lenses, using different view types such as boards, calendars, or maps.