# Defining and Editing Field Formulas

> Sisense makes it easy to edit custom tables. You can use SQL to customize the fields contained within a custom table.

*Source: https://docs.sisense.com/main/SisenseLinux/editing-field-formulas.htm*

---

Last updated: June 11, 2026

|  |  |
| --- | --- |
| [Tier](https://www.sisense.com/pricing/#pricing) | [Deployment](https://docs.sisense.com/main/SisenseLinux/introduction-to-sisense-cloud-managed-services.md#ComparisonofManagedCloudandSelfHosted) |
| Launch     Grow    Enterprise | Cloud     On-Prem |

Sisense makes it easy to edit custom tables. You can use SQL to customize the fields contained within a custom table.

When you edit a custom table, any changes you make are saved when you click **Save** unless the
expression did not successfully parse. In this case, you are prompted to save a draft of the invalid expression.

![Invalid expression](https://docs.sisense.com/main/Resources/Images/invalid-expression_661x228.png)

If you save the invalid expression, Sisense continues to use the last valid expression that was saved when building
an ElastiCube, but the next time you open a preview of the table, the invalid expression will be displayed. This
allows you to continue building working ElastiCubes while letting you save incomplete expressions for later.

If you wish to display the last valid expression, you can click the **Refresh** button in the menu bar
and then press **Save**.

![Refresh button](https://docs.sisense.com/main/Resources/Images/refresh-button.png)

**To edit a custom table's SQL expression:**

1. Select the custom table you want to edit and click ![8 6v7preview](https://docs.sisense.com/main/Resources/Images/8-6v7preview6.png).

   ![Preview](https://docs.sisense.com/main/Resources/Images/preview_240x248.png)

   The custom table area is displayed
2. Enter SQL statements to access tables and fields that exist in the schema. See related topics for more details on
   [SQL Quick Reference](https://docs.sisense.com/main/SisenseLinux/sql-reference.md) and [Data Functions for Custom Tables and Fields](https://docs.sisense.com/main/SisenseLinux/functions-overview.md).
3. To view results based on the SQL statement, click ![8 6v7preview](https://docs.sisense.com/main/Resources/Images/8-6v7preview7.png).

   **Note:**

   At least one build including the relevant base table must have been completed in order to preview results.
4. Click **Save** to save your changes.