Dashboard control

The Dashboard Control is a composite control that is used to provide a graphical presentation of data including tags and a progress bar.

Dashboard control is commonly used to show data for scenarios like daily sales of a store, overall earnings and rating thereof of a restaurant or even for websites for local search of businesses, sites like the ones that are aggregating sites like Trivago and so on. There you are displaying data fetched from different sources, rating in the form of a tag. Progress bar indicating progress on a certain parameter and so on.

Properties

UI properties

  • Label: Label is the text that is displayed above the container box and helps the user to understand what they are supposed to write.

  • Properties: These properties help you customize the Label by changing the text size, weight ( Light, Normal, Bold, Extra Bold, X Extra Bold), alignment (Left, Center, Right, Justified) and color of the label.

  • Type: The Type field is automatically generated depending upon the type of control used. In this case, it is a “dhq_dashboard” type.

  • Unique Name: A Unique Name is used to uniquely identify a control in your App. Every control that is added on the screen gets an auto-generated Unique Name on the basis of the Label name given to the control. Being a composite control there are unique names for Header, Tag, Title, Footer, and Progress bar percent controls respectively.

  • Tooltip: This allows you to add the Tooltip text that would provide a hint to the user for providing input. The Tooltip icon would be visible if you switch on the Show tooltip icon toggle property available below.

  • Description: Is the description that you can add for your controls. The Description would only be visible if you switch on the Show Description toggle property available below.

  • Show Tooltip Icon: This allows you to toggle switch ON or OFF to show or hide the tooltip icon where the tooltip text would appear.

  • Show Description: This allows you to toggle switch ON or OFF to show or hide the Description text.

  • Hidden : The hidden option helps you to hide the field from the user. This might help to perform some computation you don’t want the user to see or if you want to show certain fields only when a specific condition is met/not met.

  • Caching : When the caching option is selected and if a LOOKUP formula is applied to this control, the value that the LOOKUP returns will be cached and the user will be able to see this value in the field even when the user accesses the microapp later with no connectivity. This option is required when you want your app to be accessible in offline mode as well and getting the latest data from the sheets always is not critical.

  • Hide Label : This option hides the label of the field from the view.

  • Trigger Dependents: When you Disable Trigger Dependents, it helps you to reduce or optimize the unnecessary evaluation of the dependent control’s formula. For a detailed explanation refer to this article here.
    By default, Trigger dependents are enabled. However, in complex apps by switching it off, you would limit the evaluation in the dependent control and in turn ensure quicker response times.

Properties

dashboard properties card

Card

  • Border Radius: Specifies the radius which indicates the curved borders for the card.

  • Color: Is the border color of the card.

  • Shadow: Is the shadow that appears around the card.

  • Border: Is the toggle that specifies whether the border would be shown or not.

  • Tag: Is the toggle to switch the TAG ON or OFF.

  • Progress: Is the toggle to switch the Progress Bar or ON or OFF.

Progress Bar:

These properties can be seen if you have toggle switched ON the Progress Bar with the Progress property above.

  • Height : Is the height of the Progress bar
  • Filled color: Is the color of the bar indicating progress.
  • Empty Color: Is the empty area which indicates the pending progress.

Tag

dashboard properties tag

These properties can be seen if you have toggle switched ON the Tag with the Tag property above.

  • Border Radius: Specifies the radius which indicates the curved borders for the card.

  • Font size: Is the Font size of the Tag text.

  • Font weight: Is the font-weight of the Tag text

  • State: This is the state of Tag. The Tag can be Normal state, Negative, or Positive state. You can then specify the font color, background color and the icon if any to be used for the selected state.

  • Normal state: Is the above illustration these would be the properties for Font color, Background color, and Icon for the normal state.

    dashboard control
    The same properties would be set for the negative and positive state as well.

Text

The Card is primarily divided into header, title, and footer. The Properties are the properties specified for the respective Header, Title, and footer text. The alignment of the text is also specified.

How to Use Dashboard Control?

Start with selecting the Dashboard control from the Dashboard section of the Controls Menu.

The Dashboard Control will then appear on the screen in the builder, you can then set all the above properties as per your requirements. It is not an input control. However, it is a display control that provides an overview of say the data collected for a restaurant’s daily sales, their overall customer rating, and so on. You can use the Data option to bind data to the Dashboard Control. You can use the respective functions and formulas to represent data as required for each of the card elements namely the Header, Title, Footer, Tag, and Progress bar.

  1. Static Data: This is the data that does not change over the period of time. Such data is used to assign default values in fields in your application. The static data can be based on the data type i.e. Numeric, Text, and List type data. The Sparkline control accepts an array of numbers for populating the graph.

  2. Sheets: This allows you to fetch data from a sheet and display it in the fields. Select your sheet from the list and then select the columns to be used. You can also add filters and sort data.

  3. Controls: This allows you to get data from one of the App controls.

  4. Variables: This assigns the value of the variables defined in the app.

  5. Query string: This assigns the value returned by the Query string.

  6. LoggedIn User: You can display the properties related to the LoggedIn User like username, usermail, Admin, status, and so on. You can select a single property only. Select column and click Save.

  7. Connectors: This allows you to add a Connector and select the values returned by the respective Connectors. You can select multiple keys to display values in the detail view.

  8. Custom Formula: This can be used to apply formulas and store the output of those formulas in the detail view rows. You can learn more about formulas here.

Preview

dashboard preview