Format Column Types

Table grids are a powerful way to display data in a tabular format in your DronaHQ applications. You can fetch data from sheets, SQL, and NoSQL databases using various connectors. This document explains how to enhance your data presentation in Table Grid Controls and Detail View Controls using the Format Data feature.

Using Format Data for Detail View Control

When using a Detail View Control, you can format your data using the Format Data feature. This feature allows you to format data based on the column type, making it easy to present data in a user-friendly manner.

Formatting Data for Detail View

1. To use the Format Data feature, first bind the data source to your Detail View Control.

2. Select the columns you want to display and configure any necessary filters.

3. Click on Bind Data, then select Format Data to access the Column Format settings.

Bind Detail View Control

4. In the Column Format settings, add the column names you want to format.

Format Data config

5. For each column, select the appropriate column type and apply the desired formatting. Click Apply to save your changes.

6. Once you've added formatting to your selected columns, click Finish.

7. When you run your form, you'll see the formatting applied to the selected columns in the Detail View Control.

Using Format Data with Table Grid Control

The Format Data feature can also be used in Table Grid Controls to format data fetched from various data sources. Here's how you can use Format Data with a Table Grid Control:

1. Configure your Table Grid Control and select the data source, e.g., a DB connector.

2. Under the Bind Data, you'll find the Format Data button. Click on it to access Column and Row Formatting options.

Bind Table Grid Control

Column Format

1. In Column Format, add the column names that represent the keys from your data sources.

2. Select the Column Type based on the data type in your columns and apply the desired formatting. Click Apply to save your changes.

3. You can apply various formatting options, such as adding icons, background colors, text colors, and more based on the column type.

4. Conditional formatting can be applied based on the value of another column, allowing for dynamic formatting.

Format Data config

5. Once you've added formatting to your selected columns, click Finish.

Certainly, here is the information about the Color Scale conditional formatting for Table Grid Controls presented in the requested format:

Color Scale Conditional Formatting

1. Source Column: In order to apply Color Scale conditional formatting, the data type of the source column must be a Number.

2. Unique ID: This is the source column you want to apply the Color Scale formatting to.

3. Preview: View the color gradients before saving.

4. Format Rules:

   • Min Value: 0
   • Mid Value: 0
   • Max Value: 100

The Color Scale conditional formatting option allows you to visually represent numeric data variations using a gradient of colors. In this example, the "unique_id" column is used, and the color scale is configured to span from 0 to 100. The color assigned to each value within this range gradually changes, creating a visual representation of data distribution. This can be helpful for identifying data trends and patterns in your Table Grid Control.

Color Scale

Row Color

You can also apply conditional formatting to rows in a Table Grid Control. Specify conditions based on operators for different data types and change row colors based on the row values.

Row Color Formatting

When you run the form, the formatting for both columns and rows will be applied as per the conditions specified.

Importing Formatting

To save time and effort, you can import formatting that you've applied in other Detail View or Table Grid Controls within your catalog. Here's how to do it:

1. Click Import and select the control from which you want to import the format.

Import Formatting

2. All the relevant columns and formatting will be automatically filled based on the imported control.

By importing formatting, you can streamline the formatting process for large datasets.

caution

If there is a column mismatch, you'll need to apply the formats manually.

Pushing Limits on Data Formatting

For a comprehensive description of the formatting options using the Format Data feature, refer to this article.

Enhance your data presentation by adding a progress bar to percentage type data.

1. Select the column containing percentage data.

2. Go to Format Options and specify the limit for formatting.

3. Set the minimum and maximum limit values.

4. Toggle the switch to display the progress bar.

By default, the progress bar's color indicates values below the minimum limit in red, within the range in blue, and above the maximum limit in green.