2022-06-30
New QUERY Field
![](https://jestor.com/wp-content/uploads/2022/06/ezgif.com-gif-maker-47.gif)
Leverage SQL to add advanced functions to your table.
– Built-in IDE for fast development.
– Use data from any table in Jestor.
– Validate and test your code before implementing it.
How to create
To create a Query field:
- On table mode, go to the last table header with a “+”, press (F) or click on the “+” on the upper right and this will open the field creation page
![](https://jestor.com/wp-content/uploads/2022/06/0eb5633-how_to_create_a_field_on_jestor-1024x353.png)
- Just look for the “Query” option and click on it
- Choose the name of your field
- Select a return type
![](https://jestor.com/wp-content/uploads/2022/06/122dffc-Screen_Shot_2022-06-30_at_09.49.03.png)
- Enable or disable Dark mode
- Expand the box and type your function
- Then click on Run to test your query
![](https://jestor.com/wp-content/uploads/2022/06/fa0a6ce-Screen_Shot_2022-06-30_at_09.50.10.png)
?
You can delete or edit by clicking on the table header name and choosing one of the options
Here’s the complete documentation: https://docs.jestor.com/docs/query-field