Formula Field
Last updated
Last updated
Label Field • The first input field allows you to specify the Label of the column. • Enter a meaningful name, such as “Total Price” or “Area Calculation”, to indicate the purpose of this column. This label will appear as the header for the column in the table view.
Type Field • The second dropdown menu is used to select the Type of data for the column. • Choose Formula to enable calculations or derived values based on fields within the table.
Formula Configuration • Once Formula is selected, two multi-select input fields are displayed. • These allow you to choose two fields from the table that will be used for the formula. • A button is provided to define the operation to be performed between the two fields: • Addition, Multiplication, or other predefined operations.
Code Editor Toggle • At the end of the configuration, there is a Switch Input labeled “Code Editor”. • Turning on the switch enables a code editor, allowing you to write a custom formula or script for more advanced calculations.
Functionality Example • For example, you can select the Price and Quantity fields, then click the Multiply button to create a formula column that calculates the total price.
