Calculated Field

This tutorial shows how to create a grid ready to export PDF reports and print friendly report pages. It also shows how to perform a specific calculation within a grid.

Creating a new Grid

1. Create a new grid application using the customer table.

2. Open the toolbar menu.

3. Select First, Previous, Next, Last, Row Limit, PDF and Print Align to center on the top toolbar.

Creating the calculated field

4. Open the Fields folder and click on the New field option.

5. Enter 1 for the quantity attribute and click Next.

6. Choose Text for the Type attribute and set Status to Name and Label, then click Create.

Field calculation in the OnRecord event

7. Open the Events folder and click the OnRecord option.

8. Add the following code to the selected event:

if({CreditLimit} ≪= 2000) {
{Status} = "Low";
sc_field_color ("Status" "# AA0000");
{Status} = "High";
sc_field_color ("Status" "# 0000AA");

9. Click the Run button on the toolbar.

Tutorials in the same category

Tutorial: Saving Report Views

In this example, we will see the options available for the end user to store, in session or in a...

Tutorial: Grid with modal filter.

This tutorial will show how to configure a query filter to display in a modal window, using the res...

Export Option

To export different types of files we must carry out the following steps: 1 - Create a Grid ...

Integration with WhatsApp

To integrate WhatsApp with ScriptCase, we will be using a specific API called Chat-API, it is a...

Comment this post