---
title: "TOLIST"
url: "https://help.formsfly.com/en/article/tolist"
language: "en"
last_updated: "2024-11-04T09:19:08.574Z"
---

# TOLIST

Converts the given value to a List.

* * *

Syntax  
`TOLIST(value, 'optionaldelimiter', 'optionalFilterFormula')')`

### Example

```plaintext
 TOLIST({{myfield}})
 
 TOLIST({{myfield}}, 'STARTSWITH({{this}}, "B")')
 
 TOLIST('3,6,9,62', ',', '{{this}} > 5')
```

### Notes

The value must be text containing delimited List elements - e.g. 34|76|9

Second optional parameter is the delimiter character separating elements. Default is pipe character.

Third optional parameter applies a filter formula to the List elements gathered, leaving only elements that pass the condition. Use {{this}} to refer to the element value in formula.

### Related

[LIST](https://help.formsfly.com/en/article/list)  
[TOLIST (Multi-field)](https://help.formsfly.com/en/article/tolist-multi-field)