---
title: "DSFIRST"
url: "https://help.formsfly.com/en/article/dsfirst"
language: "en"
last_updated: "2024-11-12T10:13:44.143Z"
---

# DSFIRST

Gets first column value in the given Data Source, optionally filtering rows by formula.

### Syntax

`**DSFIRST(dsId, columnIndex, 'optionalFilterFormula')**`

### Example

```plaintext
DSFIRST('STAFF', 2) gets 3rd column's first value

Add a filter formula using {{this[column]}} to refer to columns.
DSFIRST('STAFF', 2, '{{this[5]}} = "BOB"') first of 3rd column where 6th column = BOB
```

### Notes

Refer to the Data Source by it's External Id (from the Data Source -> Settings page).   
Refer to the column by it's zero-based index.

### Related 

[DSCOUNT](https://help.formsfly.com/en/article/dscount), [DSSUM](https://help.formsfly.com/en/article/dssum), [DSAVG](https://help.formsfly.com/en/article/dsavg), [DSMAX](https://help.formsfly.com/en/article/dsmax), [DMIN](https://help.formsfly.com/en/article/dsmin), [DSLAST](https://help.formsfly.com/en/article/dslast)