# 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
```