
make.md is part of a personal quest for a digital system to organize my life. As tech is more pervasive and easily accessible than ever, more and more of the aspects of work and life can now be organized digitally, freeing up mental and physical clutter. However, most of the way to keep track of our information is in different apps with data either on the cloud or different formats with no way to connect them. Overtime, the interface and format changes and habits and workflows are broken while important memories and documents becomes inaccessible.

After moving through multiple systems and with some spare time, I created what needed for my personal digital system and found that many in the community was looking for the exact same thing and facing the same problems. We designed the system with three principles in mind to what we think the perfect system needs to have.

---

### Principles of make.md

**Remove barriers between data**
Data that you have for any part of your system should be readable and useable by any other part of your system. Instead of data living in silo and specific formats and relying on yet another set of tools for integration, make.md removes those barriers and allow information to be in one place.

**Making over context switching**
One of the primary reasons for digitalizing our data is that we can keep information organized and accessible without cluttering our mind and physical spaces. When we introduce new interfaces, syn-tax and barriers, it takes our mind out of what we want to spend our time on. make.md prioritizes intuitive interfaces and natural modes of interaction over coding and scripting.

**Fully customizable workspace**
Your life and workflows are unique. Whether you have specific ways of organizing information, different tastes in style, your digital workspace should reflect that. make.md comes with a set of easy-to-use workspaces that are completely customizable to your workflow and style.

---

The more time we spend our lives digitally, the more intentional we should be in how our workspace is designed. Just like our physical homes and workspaces, the environment we work in matters and reflects in the work we do and the lives we live.

We love discussing and learning more about your ideal workspace in our community, come join the discussion https://www.make.md/community


But why.md

### Installing make.md
make.md is currently available as a Obsidian Community Plug-ins. In the Obsidian app, goto Settings -> Community Plug-ins in the vault you want to use make.md and then install make.md

Installing make.md.md

### Object

- Object types allow you to create nested properties that can be used to store more complex data structures. You can use most of the basic property types in an object type. Each row will conform to the same object type. You can also use a multi object type to create a list.

---
### Special

- Special properties are complex properties that you can add to manage your data
- Special Properties:
	- Repeat: The repeat type is a preset defined type for use in calendar views to define how an event repeats itself. You can directly 

---
### Relations

- Relations allow you to create relationships between two contexts. 
- Setup a relation by choosing the context you want to create a relation with
- Use two way to add the property in both contexts in sync

---
### Aggregate

- Aggregate allows you to look up a property from related data and aggregate it into one value.
- Select a relation property to calculate the aggregate from
- Select the property from the related context to calculate
- Select one of the aggregate by formulas - See [[../../../References/Aggregate]] in References

---
### Formula

- Formulas allow you to calculate a value based on other properties in the context using a formula.
- Formula is composed of a set of functions and has access to metadata of the items.
- Setup a formula by pressing Edit Formula
- Use the formula helper inside the editor or see the reference at [[../../../References/Formula]] References



Advanced Properties.md

Visualize your contexts with different views that tailor to your data and workflow. 
- Each view opens up new use cases for your needs.
- You can define which context a view comes from, this allows you to 

---
### Customizing your Context View

- Select different view layout for your context by clicking the Layout button and selecting the view
- You can save views by pressing the + button in the view selector, adding a new view will duplicate the current view.
- Edit the view options in the configure options
	- Rename the context view
	- Change options for that view

---
### Table View

- Table view lets you organize and manage your data in a table. Each column represents a single property and every row represents an item. 
- You can add a property in your table by clicking the +
- Resizing the Column
	- You can resize the columns by dragging and resizing the size of your columns
- Column Order
	- You can reorder your columns by dragging and dropping into the order you want
- Hiding Columns
	- You can hide any column by clicking and then hiding
-  Calculating an Aggregate Value
	- See an aggregate of the values in each column by 

---
### Kanban Board

- Quickly create a kanban board using the Card View and Grouping By the property.
- Contexts comes with a set of views to visualize and edit your data. The default view is a list view and you can change that view into table view, board view, calendar views.

---
### Calendar View

- Calendar views lets you view a specific context in a month, week or day view. 
- In order for a context to work as a calendar, it will need a start and end properties with Date type and an optional repeat property.
- You can change the hour which your day view and week view by changing the start and end hour, enter a value between 0-24 to set the hour.
- Adding Events
	- Drag and dropping a path into the month view or day view allows you to directly pin the item to the space and set the time. In the day/week view, you can also click and drag to create an event. In the month view, double click to create an event.
- Editing Events
	- Drag and drop events up and down or resize the event to change the time duration.
- Repeating Events
	- You can set repeat interval for an event by setting a property to store the repeat information. The property type for repeat is an object type with a specific set of properties which can be added in the Special type.



Context Views.md

Contexts define a set of properties and views for any space. 
- Contexts are great for specific projects, types of information like media library or across your system as an organization system

---
### Creating a context

- Each space comes with a context, you can add properties directly to the context and it will be associated with all of your notes. 
- You can find the context view inside the space view.

---
### Context properties

- Choose one of the following properties which each gives you unique ways to represent your data both visually and systematically.
- Context Property Types
	- Text
		- Any text you want
	- Number
		- Enter any integers or decimal numbers
	- Date
		- Choose a date from the date picker and customize the format to display it in
	- Options
		- A list of options that can be selected through dropdown
		- Support for multiple values
	- Yes/No
		- Toggle between a checkbox
	- Link
		- A link to a note
	- Image
		- Choose an image in your workspace or online to show in your context
	- Aggregate, Object, Relation and Formula
		- See Advanced Properties
- Some properties support multiple values, check the Multi to allow multiple values

---
### Import your data to a context

- Adding an existing property will automatically import the data to your context
- Use the add existing option when adding a new property to add one or multiple properties at once.

---
### Customizing Properties

1. Open the Context Properties
2. Toggle which properties you want to display
3. Drag and drop the order you want to display the properties in

---
### Search, Filter and Sort your Context

- Quickly find your data with a combination of search, filter and sorting.
- Easily search from the search bar in your contexts and to search through all your properties.
- Add filters based on different properties in your context. 
	- Each property type offers different fitlers, use a combination of filters to create the view you're looking for.
- Select the sort by in the options menu and select the field you want to sort by.


Contexts.md

You can combine context properties from a tag context, combining a context allows you to automatically add all the properties from the existing context to your current space. 

---
### Applying a Tag Context

- Right-clicking on a folder and choose Apply to Items in Folder -> Apply Tags to add or remove applied tag contexts
- By connecting contexts together, you can build a connections between different spaces.

Tag Contexts.md

The context feature lets you organize information and efficiently manage the data inside your notes through databases. With contexts, you can effortlessly connect related notes and create structured, dynamic collections of your ideas, research, and projects. This documentation will guide you through setting up, using, and customizing Contexts in make.md to optimize your note-taking experience.

---

## Context Basics

Contexts define a set of properties and views for any collection of notes whether it's in a folder, tag or a space depending on your form of organization. 
- Folder contexts are great for focused folders like projects. 
- Tag context are great for organizing the same type of notes across your notes such as media library. 
- Define a set of properties for all the notes in the folder or tag
- Search, filter and group data to find the information you need

**Main Articles**
[[./Contexts.md|Contexts]]

---

## Context Views

Visualize the data in your context by customizing and creating views
- Visualize your notes in a table, calendar, list or kanban board
- Save different filtered views of your data

**Main Article** 
[[./Context Views.md|Context Views]]

---

## Advanced Properties and Tag Contexts

Use advanced properties and tag contexts to calculate and connect your contexts
- Use formulas to calculate data, relation to connect data and object to create advanced data structures
- Applying a tag to your context allows you to automatically add all the properties from the existing context to your current space. By connecting contexts together, you can build a connections between different spaces.

**Main Article**
[[./Tag Contexts.md|Tag Contexts]]
[[./Advanced Properties.md|Advanced Properties]]



Lists and Databases

Use stickers, color and covers to label the items in your workspace.

---
### Stickers

- You can assign stickers to your notes and folders by
	- Click on the sticker in the Navigator to choose a sticker
	- Opening a note/folder and clicking Add Sticker at the top
- Assign default stickers to all items in a folder by right-clicking and choosing Apply to Items -> Default Sticker

---
### Colors

- Assign a color by right clicking an item in your Navigator and click Color to select a color

---
### Cover Image

- Open a note/folder and click on Add Cover
- Reposition the cover image by clicking Reposition and dragging to the position you want

---

**Related Settings**
Stickers - Turn stickers on and off in your workspace
Index SVG - Use SVG icons in your workspace to use as Stickers
Edit Stickers in Navigator - Shortcut to quickly edit stickers in the Navigator

Labels.md

You can find the Navigator in the Navigator tab on the top left of the sidebar. 
- Open folders and tags to focus on
- Search your workspace
- Organize your files and folders

---
### Focuses

- Focuses are an easy to use and intuitive way to focus on specific parts of your work
- Opening a Folder/Tag in a Focus
	- Click + Open inside your focus and select a folder/tag to focus.
- Reordering Focuses
	- Drag and drop your waypoints to reorder them
- Removing a Folder/Tag from Focuses
	- Right-click on a item inside your focus and click Remove from Focus

---
### Searching your Workspace

- Open Blink using a hotkey or clicking on the Search icon in your workspace
- Searching with Blink
	- Blink can search and allow you to instantly edit your Notes and Contexts, just type in what you're looking for and your note/context will be loaded

---
### Ordering Items in a Folder/Tag

- Reorder in any space by drag and dropping to the specific you want.

---
### Hiding Items

- Right click any file or folder and select hide to hide them from the navigator and any spaces they're in.
- Unhiding Files and Folders
	- In the Main Menu, select the Manage Hidden Files option and remove any files or folders that are hidden from the list to unhide them.

---
### Pinning

- Notes and spaces can be pinned to a space so you can quickly access them. 
- There are many ways to pin to a space.
	1. Directly clicking pin to space in the Space View / Flow Editor
	2. Right-clicking a note an clicking pin to a space
	3. Right-click on the space and click Add Pin
	4. Drag and drop a note/space into the space while holding shift


Navigator.md

The overview is a special view that turns your workspace into a three panel space. When you have the overview open, clicking on any folder or tag will now open that in the overview which then you can select the note or folder you want to open.

---
### Using the Overview

- Open the overview by selecting Open Overview from the Main Menu in the Navigator
- Click a folder inside the Navigator to open it in the overview


Overview.md

Use tags to organize your information, you will be able to see all the tags you have in your workspace in the Tags space. Individual tags will also have its own space in which you will see any items tagged.

---
### Using Tag Spaces

- Search for the Tags space to add to a Focus or pin to a folder
- Inside the Tags space, you will you will see a list of all your tags.
- You can rename tags or delete them which will apply the changes to all your notes.

Note: Customization for tags are also stored in your workspace in the Tags folder

---

**Related Settings**
Tag Space - Toggle whether tag spaces are enabled

Tags.md

## Navigating your Workspace

Use the Navigator and Overview to easily organize your spaces to streamline your workflow and focus.
- Navigate, create and organize your Spaces in an easy to use drag-and-drop interface.
- Focus on the project, tasks, vacation plan at hand without being distracted.
- Use the blink search to quickly skip through your notes.
- The overview lets you use a 3-panel view to quickly navigate through your folders.

**Main Articles**
[[./Navigator.md|Navigator]]
[[./Overview.md|Overview]]

---

## Folders and Tags

Use your existing folders and tags with features built to help you organize.
- Create lists of notes and spaces based on your work instead of your folder structure, bring items from across your entire system.
- Use live search to automate pinning folders based on certain criteria.
- Easily manage and navigate your tags as tag spaces.

**Main Articles**
[[./Tags.md|Tags]]

---

## Labels

Give individuality to each of your notes and spaces so you can quickly recognize them
- Apply stickers, colors and aliases to your notes and spaces to quickly identify them
- Use cover photos to style your notes

**Main Articles**
[[./Labels.md|Labels]]



Organizing Files

Each space has its own view which can be customize, you can choose one of the views provided or create your own (coming soon). The default view is the folder note, a powerful way to use your notes.

---
### Folder Note

- The default view for a space view
- The folder note allows you to use your notes as folders to create nested notes.
- You can turn a note into a folder note by right-click on a note and click Transform into Folder

---
### Reseting a View

- Reset the view back to the default one by clicking the more options beside the Add Property
- Click Reset View to change back to the default

Space Views.md

- The Space View gives you full control of how you interact with all your Spaces. 
- You can add interactivity with buttons and links. 
- You can create custom layouts with groups and columns. 
- You can add custom styles with custom colors, fonts and sizes. 
- Connect context views, flow views from anywhere in your system. 

---
### Opening your Space View

- Find the space you want in the navigator and directly open the space view

---
### Adding Blocks to your Space View

- Hover over any block and press + to add a block below it
- Blocks help you customize using existing notes and layouts
	- Note - Add a note block and have it show up in your Space View
	- List View - Add a list view of your context database, change the source to connect data from another context
	- Divider - Dividers give you a quick visual way to separate different parts of your space view. 
	- Image - Add a resizable image to your space
	- Button - Add buttons that lets you quickly perform actions right from your Space. 
	- Label - Use a text label to create headings or titles for your space
	- Sticker - Use a sticker to label or decorate
	- Rating - Show a rating value as a series of stickers
	- Toggle - Show a collapsible toggle
	- Progress - Visualize progress between two values

---
### Adding a Link

- Drag and drop a link from your context views into the space to directly add a link

---
### Setting up actions for a button

1. Select the button from the add view
2. Give your button a label and an icon
3. Select the type of action you want (Run Command or Open Link currently available)
4. Select which command or link you want the button to run/goto


Spaces.md

You can customize the layout and the style of your blocks using the block editor.

---
### Styling your Blocks

 - Customize the blocks by clicking the more options button when you hover over it.
 - You can customize by changing:
	 - Size, margins and paddings
	 - Border and background color
	 - Font color
 - In sizing mode, you can also resize by dragging the edges of the block

---
### Creating Multi-Column Layout

- Layout the different frames in your spaces into columns. 
- Drag and dropping into the right side of another frame will automatically create a new column.

---
### Creating Custom Layouts

- Create custom group blocks which you can customize to the style you want
- Select multiple blocks by holding shift and clicking the select button.
- Select one of the grouping options to create the group
- You can customize the group with style options

Styling and Layout.md

Each space can be customized to suite your workflow. You can also create spaces that combine information across your system to create dashboards.

---

## Spaces

- Spaces are a customizable view for your folders or tags
- Use the intuitive block editor to add and edit your blocks including lists, buttons, images and more

**Main Article**
[[./Spaces.md|Spaces]]

---

## Space Views

- You can choose one of the views to display your view as
- The folder note is the default space view and allow you organize notes as nested notes

**Main Article**
[[./Space Views.md|Space Views]]

---

## Styling

- Customize the layout and style of your blocks using the block editor
- Using drag and drop and a series of intuitive editors, create any layout or style you want

**Main Article**
[[./Styling and Layout.md|Styling and Layout]]



Personalizing your Spaces

Under the hood, make.md runs as an engine that both keeps your information organized as well as turns the information into visualizations and workflows. This note goes into some of the architectural aspects of how make.md is designed for those interested.

---
### Superstate

The superstate is how information in your vault is kept connected and ensures quick access to information during runtime. When you start make.md, the superstate initiates and indexes all the files and notes you need for your workspace. As you work in your system, the superstate reacts and updates its connections so that links are automatically updated. The cached superstate is stored so that when you launch your vault again, the index loads immediately.
### Paths and Spaces

Everything in make.md is represented as an unique path. For example, when working in Obsidian, that path is the relative path from your vault root. Notes, folders, tags, tables, views and blocks all have their individual paths so that they can be linked from another part of your vault. The superstate reads through all your paths and keeps track of which paths are connected to other paths, which spaces they are in and etc. Spaces, contexts and views also keep track of their own information, for example, commonly used views are cached so they can render as soon as you open them. 
### Contexts

Contexts are SQLite database files for each of your folder or tag that stores the schema and data for each of your folders. Each context is stored with the folder under the .space config folder. When you make edits to the data or add additional items to the folder, your context database is automatically updated. 
### Views

In order to make sure that you are able to customize your workspace without any code, make.md comes with its own view compositor system. Each folder or tag comes with a main view which is defined by a series of subviews called frames. Each frame can be a context view, a note view, an image, a group or another predefined frame. There are a set of predefined frames that are built to compose your views quickly such as buttons, cards, tabs, list view items and more.

---
### Data Storage

Make.md stores configurations for spaces, contexts and views inside of the .space folder of each folder. These files are not created by default so only the folders you customize will contain these folders. For markdown files, properties are stored directly in the frontmatter of the file while for non-markdown files, it's stored inside the context database file.

Under the Hood.md


### make.md helps you organize and personalize your notes, files and data to create a personal systems for your life, work and school.

Learn more on why we build make.md - [[./But why.md|But why]]
Install make.md to get started - [[./Installing make.md.md|Installing make.md]]
Learn more about the implementation - [[./Under the Hood.md|Under the Hood]]

---

## 🗃️ Organizing Files

make.md comes with an easy-to-use user interface to organize your files and notes for your workspace.

- Keep the important parts of your workspace in focus using the Navigator
- Visually label with stickers, colors and banner
- Use the overview to quickly navigate your workspace
- Organize using folders and tags

Main Section - [[./Organizing Files/Organizing Files.md|Organizing Files]]

---

## 🧩 Lists and Databases

Organize data and information into lists and databases, make.md comes with a fully feature database.

- Store data in a structured format
- Visualize using views like tables, galleries, calendars and more.
- Search, sort, filter and group information
- Create relationships and use formulas to calculate values

Main Section - [[./Lists and Databases/Lists and Databases.md|List and Databases]]

---

## 🍱 Personalizing your Spaces

Personalize your spaces to adapt to your workflow and style.

- A block based system for making your workspace interactive and customized
- Use templates to automate your workflow

Main Section - [[./Personalizing your Spaces/Personalizing your Spaces.md|Personalizing your Spaces]]


Getting Started


| Name                 | Type   | Description                                                                              |
| -------------------- | ------ | ---------------------------------------------------------------------------------------- |
| Values               | any    | All values from the selected property of each related item                               |
| Sum                  | number | Sum of all numbers in the property                                                       |
| Average              | number | Average of all numbers in the property                                                   |
| Median               | number | Median of all numbers in the property                                                    |
| Count                | any    | Number of items                                                                          |
| Count Values         | any    | Total of all items in the related property for the items                                 |
| Count Uniques        | any    | Total number of unique items in the related property for the items                       |
| Percentage Empty     | any    | Percentage of properties that are empty                                                  |
| Percentage Not Empty | any    | Percentage of properties that are not empty                                              |
| Min                  | number | The smallest number in the related property of all the items                             |
| Max                  | number | The largest number in the related property of all the items                              |
| Range                | number | The range of number in the related property of all the items                             |
| Empty                | any    | The number of items that are empty                                                       |
| Not Empty            | any    | The number of items that are not empty                                                   |
| Earliest             | date   | The earliest date in the related property of all items                                   |
| Latest               | date   | The latest date in the related property of all items                                     |
| Date Range           | date   | The difference between the latest and earliest date in the related property of all items |


Aggregate.md

- You can also embed a context to let you easily maintain dynamic, data-driven notes that stay up-to-date with your database.

## Embedded Contexts
- Embedded Contexts lets you easily maintain dynamic, data-driven notes that stay up-to-date with your database.

### Embedding your Contexts
1. Open the Context you want to embed
2. Right click on the View in your Context and click "Copy Embed Link"
3. Open the Note you want to embed into
4. Paste the link into your notes where you want to embed

Contexts in your Notes

## Creating a Flow Block from Flow Menu
1. Create a new line in your notes where you want your Flow Block to be
2. Open the Flow Menu by typing your trigger key (/ by default)
3. Select Flow Block
4. Find the Note you want to connect

## Opening a Flow Block from Inline Link
1. Hover over the inline link you want to open flow block with
2. Based on your inline flow block settings
	1. If hover to open is on: Hold shift and click the link
	2. If hover to open is off: Click Open Flow from the menu

## Opening a Flow Block from Inline Embeds
1. Hover over the inline embed you want to open flow block with
2. Click the toggle flow button

Flow Blocks.md

## Creating Blocks with Flow Menu
1. Create a new line and type the hotkey ('/' by default) to open the Flow Menu
2. Select/search for the block you want to create

Flow Menu.md

## Opening the Flow Styler
1. Select the text in your note that you want to style
2. Use the styler to select the formating you want to apply

Flow Styler.md

- The inline context is where you can apply all the context properties for your note directly in the note itself.

## Editing Properties
- You can find the inline context at the top of your note and all the properties from the contexts will show up here. 
- You can also add new properties to your note or to the context by clicking Add Property.

Inline Context.md

- You can also embed a context to let you easily maintain dynamic, data-driven notes that stay up-to-date with your database.

## Embedded Contexts
- Embedded Contexts lets you easily maintain dynamic, data-driven notes that stay up-to-date with your database.

### Embedding your Contexts
1. Open the Context you want to embed
2. Right click on the View in your Context and click "Copy Embed Link"
3. Open the Note you want to embed into
4. Paste the link into your notes where you want to embed

Creating a New Table
- You can create tables just like your context tables but anywhere in your notes. 
- You can use the Flow Menu to create a table directly or add a table to your Folder context and embed it into your notes. 
- Inline tables come with all the features you get from a context table including views, sort and filter.

Inline List Views.md


Important: The basics features are being moved to https://github.com/Make-md/Obsidian-Basics

## Overview

Flow transforms your editor experience to enhance your note-taking by streamlining the process of viewing, editing, and styling your notes. Flow offers a range of powerful features, including:

## Activating Flow

To activate Flow, follow these steps:

1. Open Settings in the main menu and navigate to 'Make.md' in the sidebar
2. Scroll to the 'Flow' section
3. Toggle on the the Flow features you want to use

[[Flow Blocks]] - Seamless viewing and editing of connected notes
[[Flow Styler]] - Styling your notes with ease
[[Flow Menu]] - Quickly add formating to your content


Basics

Live search lets you create a customized filter of your system to find or connect your ideas, the filter will automatically update as your files change. 
## Adding a Live Search to a Folder
- You can add a live search directly to a folder, click the Add Live Search button under the options menu in Items property
- The search results automatically refresh everytime something changes in your system so that it's always up to date.
## Types of Filters
1. File Properties
	1. Folder
	2. Extension
	3. Path
	5. Sticker
	6. Alias
2. File Metadata
	1. Frontmatter
	2. Tags
	3. Contexts
	4. Spaces


Live Search.md


Experimental features in make.md are either currently in development, being redesigned or re-architected. The documentation will be finalized once they have been released.

- Live Search
- Basics
- Actions
- List Item Customization
- Templates


Experimental Features

| Function | Description | Category | Output Type | Inputs |
| ------------ | -------------------------------------------------------------------------------------- | -------- | ----------- | ------------------------------------------------------------------ |
| prop | Get the value of a property | Property | any | property: (text) |
| slice | Get a part of a text | String | text | text: (text) start: (number) end: (number) |
| if | If condition is true return the first argument else return the second | Logic | any | condition: (boolean) ifTrue: (any) ifFalse: (any) |
| ifs | If the first condition is true return the first argument else check the next condition | Logic | any | condition: (boolean) ifTrue: (any) ...: () ifFalse: (any) |
| empty | Check if a list is empty | String | boolean | value: (any) |
| length | Get the length of a list | List | number | list: (any-multi) |
| values | Get the number of values in a list | List | number | list: (any-multi) |
| uniques | Get the number of unique values in a list | List | number | list: (any-list) |
| substring | Get a substring of a string | String | text | string: (text) start: (number) end: (number) |
| startsWith | Check if a string starts with another string | String | boolean | string: (text) substring: (text) |
| contains | Check if a string contains another string | String | boolean | string: (text) substring: (text) |
| test | Test a string with a regex | String | boolean | string: (text) regex: (text) |
| match | Match a string with a regex | String | boolean | string: (text) regex: (text) |
| replace | Replace a string with another string | String | text | string: (text) search: (text) replace: (text) |
| replaceAll | Replace all occurences of a string with another string | String | text | string: (text) search: (text) replace: (text) |
| lower | Convert a string to lowercase | String | text | string: (text) |
| upper | Convert a string to uppercase | String | text | string: (text) |
| repeat | Repeat a string | String | text | string: (text) times: (number) |
| format | Format a value to string | String | text | value: (any) |
| toNumber | Convert a value to a number | Number | number | value: (any) |
| now | Get the current date | Date | date | |
| minute | Get the minutes of a date | Date | number | date: (date) |
| hour | Get the hours of a date | Date | number | date: (date) |
| day | Get the day of a date | Date | number | date: (date) |
| date | Get the date of a date | Date | number | date: (date) |
| week | Get the week of a date | Date | number | date: (date) |
| month | Get the month of a date | Date | number | date: (date) |
| year | Get the year of a date | Date | number | date: (date) |
| pad | Pad a number with text | String | text | number: (number) length: (number) text: (text) |
| range | Get the difference between the largest and smallest from a list of numbers | List | number | numbers: (number-multi) |
| latest | Get the latest date of a list of dates | Date | date | dates: (date-multi) |
| earliest | Get the earliest date of a list of dates | Date | date | dates: (date-multi) |
| dateRange | Get the date range of a list of dates | Date | number | dates: (date-multi) type: (text) |
| dateAdd | Add an amount to a date | Date | date | date: (date) amount: (number) type: (text) |
| dateSubtract | Subtract an amount from a date | Date | undefined | date: (date) amount: (number) type: (text) |
| dateBetween | Get the difference between two dates | Date | number | date1: (date) date2: (date) type: (text) |
| spaceItems | Get the items inside of a path | Path | link-multi | path: (text) |
| spaces | Get the spaces the path is inside of | Path | link-multi | path: (text) |
| timeStamp | Get the timestamp of a date | Date | number | date: (date) |
| at | Get an element at a specific index | List | any | list: (any-list) index: (number) |
| first | Get the first element of a list | List | any | list: (any-multi) |
| last | Get the last element of a list | List | any | list: (any-multi) |
| concat | Concatenate two lists | List | any-multi | list 1: (any-multi) list 2: (any-multi) |
| sort | Sort a list | List | any-multi | list: (any-multi) |
| reverse | Reverse a list | List | any-multi | list: (any-multi) |
| join | Turn a list into text separator | List | text | list: (text-multi) separator: (text) |
| includes | Check if a list includes a value | List | boolean | list: (any-multi) value: (any) |
| split | Split text into a list using a separator | String | text-multi | string: (text) separator: (text) |
| formatDate | Format a date into text | Date | text | date: (date) format: (text) |
| parseDate | Transform date from text | Date | date | date: (text) |
| find | Find an element in a list | List | any | list: (any-multi) condition: (boolean) |
| findIndex | Find the index of an element in a list | List | number | list: (any-multi) condition: (boolean) |
| filter | Filter a list based on a condition | List | any-multi | list: (any-multi) condition: (boolean) |
| map | Change all the values in a list based on a formula | List | any-multi | list: (any-multi) formula: (any) |
| some | Check if some elements in a list are true | List | boolean | list: (any-multi) condition: (boolean) |
| every | Check if every element in a list is true | List | boolean | list: (any-multi) condition: (boolean) |
| flat | Flatten a list of lists into a single list | List | any-multi | list: (any-multi) |
| path | Get the path object of a path | Path | link | path: (text) |
| let | Define a variable to use in a formula | Variable | any | variable: (text) value: (any) formula: (any) |
| lets | Define multiple variables to use in a formula | Variable | any | variable: (text) value: (any) ...: () formula: (any) |

Formula.md


## Formulas and Aggregate Functions

[[./Formula.md|Formula]]
[[./Aggregate.md|Aggregate]]


References

<table>
<thead>
<tr>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
</thead>
<tbody>
<tr>
<td>Values</td>
<td>any</td>
<td>All values from the selected property of each related item</td>
</tr>
<tr>
<td>Sum</td>
<td>number</td>
<td>Sum of all numbers in the property</td>
</tr>
<tr>
<td>Average</td>
<td>number</td>
<td>Average of all numbers in the property</td>
</tr>
<tr>
<td>Median</td>
<td>number</td>
<td>Median of all numbers in the property</td>
</tr>
<tr>
<td>Count</td>
<td>any</td>
<td>Number of items</td>
</tr>
<tr>
<td>Count Values</td>
<td>any</td>
<td>Total of all items in the related property for the items</td>
</tr>
<tr>
<td>Count Uniques</td>
<td>any</td>
<td>Total number of unique items in the related property for the items</td>
</tr>
<tr>
<td>Percentage Empty</td>
<td>any</td>
<td>Percentage of properties that are empty</td>
</tr>
<tr>
<td>Percentage Not Empty</td>
<td>any</td>
<td>Percentage of properties that are not empty</td>
</tr>
<tr>
<td>Min</td>
<td>number</td>
<td>The smallest number in the related property of all the items</td>
</tr>
<tr>
<td>Max</td>
<td>number</td>
<td>The largest number in the related property of all the items</td>
</tr>
<tr>
<td>Range</td>
<td>number</td>
<td>The range of number in the related property of all the items</td>
</tr>
<tr>
<td>Empty</td>
<td>any</td>
<td>The number of items that are empty</td>
</tr>
<tr>
<td>Not Empty</td>
<td>any</td>
<td>The number of items that are not empty</td>
</tr>
<tr>
<td>Earliest</td>
<td>date</td>
<td>The earliest date in the related property of all items</td>
</tr>
<tr>
<td>Latest</td>
<td>date</td>
<td>The latest date in the related property of all items</td>
</tr>
<tr>
<td>Date Range</td>
<td>date</td>
<td>The difference between the latest and earliest date in the related property of all items</td>
</tr>
</tbody>
</table>

Name	Type	Description
Values	any	All values from the selected property of each related item
Sum	number	Sum of all numbers in the property
Average	number	Average of all numbers in the property
Median	number	Median of all numbers in the property
Count	any	Number of items
Count Values	any	Total of all items in the related property for the items
Count Uniques	any	Total number of unique items in the related property for the items
Percentage Empty	any	Percentage of properties that are empty
Percentage Not Empty	any	Percentage of properties that are not empty
Min	number	The smallest number in the related property of all the items
Max	number	The largest number in the related property of all the items
Range	number	The range of number in the related property of all the items
Empty	any	The number of items that are empty
Not Empty	any	The number of items that are not empty
Earliest	date	The earliest date in the related property of all items
Latest	date	The latest date in the related property of all items
Date Range	date	The difference between the latest and earliest date in the related property of all items