# Dashboard

The dashboard provides access to all enabled forms, allowing you to utilize the form functionalities based on your permissions.

You can view all data accessible according to your permissions here.

**Features**

* **Adjust Fields:** Hide/show fields, change fields to files (share a 10-minute link with others), use formulas, and link forms.
* **Filtering:** Filter data based on values.
* **Sorting:** Sort data by updates or new rows, by time or numbers (text sorting not supported yet).
* **Grouping:** Group data by total, distinct count, sum, max, min, average. Keywords can group by keyword, numbers by range, dates by year/month/day.

**Linked Fields**

You can link fields with other forms.

#### Example Formula:

Currently, formulas include the following. Fields can only be used within the same row, not across rows.

* **IF Condition**:

```javascript
IF(!{{bool}}, 'go', 'stop') // If bool=false, go; otherwise, stop
```

* **ABS**: 

```
ABS({{value}}) //Absolute e.g. ABS(-9) output 9
```

* **MAX/MIN/SUM/AVERAGE**:

```
MAX({{price1}}, {{price2}}, {{price3}}) // Find the maximum value (at least two numbers)
MIN({{price1}}, {{price2}}, {{price3}}) // Find the minimum value (at least two numbers)
SUM({{price1}}, {{price2}}, {{price3}}) // Sum of values (at least two numbers)
AVERAGE({{price1}}, {{price2}}, {{price3}}) // Average of values (at least two numbers)
```

* **SQRT**:

```
SQRT({{value}}) // Square root
```

* **RAND**:

```
RAND() // Output a number between 0 (inclusive) and 1 (exclusive)
```

* **Logical and Arithmetic Operators**:

```
+, -, *, /, >, =, <, ^ // Addition, subtraction, multiplication, division, greater than, equal to, less than, exponentiation
```

* **Mathematical Operations**:

```javascript
{{price}} * {{quantity}}
```

* **Date Operations**:

```javascript
DATETIME_DIFF('day', {{start}}, {{end}}) // Days between start and end
DATETIME_FORMAT({{start}}, 'yyyy-MM-dd') // Formats date
TODAY() // Today's date
WEEKDAY({{start}}) // Day of the week (1=Monday, 7=Sunday)
DAY({{start}}) // Day of the month
MONTH({{start}}) // Month
YEAR({{start}}) // Year
```


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs-en.dmflow.chat/dashboard.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.