Table grid control

The Table grid control is a Display control that is used to fetch the data from a Sheet and display the contents of the sheet to the user.

table grid control

Properties

UI Properties

table grid ui properties

  • Label : Label is the text that is displayed above the control and helps the user to understand the purpose of the Table Grid Control.

  • 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 “list” 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.

  • 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 state that the LOOKUP returns will be cached and the user will be able to see this state of the field even when 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 control from the view.

Control Properties

control properties

  • Display map option: This lets you toggle on or off the Map view to display your details. If you set the Display map option ON, then you can choose the Default view as List view or Map view.

    display map option

  • Click Event: This is used to set the event that occurs when you click on a record in the list or map view. There are two options for Click Event that you can select based on your use case. They are as follows:

    1. Navigation: If you select the click event as Navigation, you can choose from the Navigation types as Navigation (with Validation) and Navigation (without Validation). So when you are navigating with validation to another page, the navigation will be restricted till the time valid data is entered and vice versa when the Navigation is set without validation. Then provide the page to Navigate to and the Transition type as slide to left, slide to right, etc.

      Navigation event

    2. Selection: If you select the click event as Selection, you can choose from Single Select or Multi-Select from the list options which would enable single or multiple selections of rows from the table grid.

      selection type
      Now when you set the click event as Selection, there are a few actions that can be added that would be performed. You can see the Action Config properties. Here you can provide the Actions to be added. You can add up to 5 actions. Actions can be added only in the Selection event.

  • Show Detailed view: You can toggle on or off to display the Detailed view of your sheet data. Whenever you click any of the records it would display the row data as a detailed view.

  • Allow Pagination: This allows you to enable pagination for your data. When you allow pagination some more properties would be added to your list of properties.

Properties

  • Theme: This lets you choose the color of the Container box. You can either enter a custom hex code value or use one from the available themes in the builder.

  • Search placeholder: It is a prompt that gives a hint to the user as to what has to be done. It is present in the field and is overridden when the user interacts with the control.

  • Control Height: Allows you to set the height of the control manually or can be adjusted automatically. With Manual setting you can provide the Visible Rows, OffSet and Page limit. If you have selected as Auto, the height is adjusted as per the data fetched into the table grid control.

  • Visible Rows: When you select the Control Height as Manual you can select the number of rows that would be displayed at a time on the page.

  • Visible columns: Allows you to select the number of columns that would be visible. By default all are displayed as per the screen size.

  • Max column width and Min column width (in px): Allows you to set the minimum and maximum width of the columns in pixels.

  • Offset: Is the index value of the record / row. If you set the offset as 0(zero) then the records are displayed from the first record as per your visible rows. However if you set it to 10 then the record number 11 would be displayed first.

  • Page Limit: Is the maximum number of records shown on the page during pagination. So if you have set the visible rows as 3 and Page limit as 10 you can see 3 rows in the table grid at a time, but there will be 10 records in the grid which can be viewed by scrolling down.

  • Group data: Enable or disable grouping of data in an accordion view.

  • Accordion view: If you enable Grouping of data, it can be grouped and displayed as All Open, All close, or First Open from group.

Display

These are the properties to set what buttons would be displayed for the Table grid control like Search, Add, Delete, Update and so on to enable those actions on the data fetched.

Action config

To add a custom action, you can add a Action Text and select a color for the Action Text. Now to further define the action to be taken, click Actions button. The list of actions is opened where you can select your action number and define the steps. Steps could include Communication actions like call, email, sms, Navigation actions like OpenURL, navigate to screen, ExitApp, Submission actions like Call workflow, Delay, Reset pages, Validate pages, Confirm popup, and Call API. The Custom Actions can also be defined to initiate actions other than those mentioned earlier.

The Actions can be viewed whenever you choose a record as the action will be linked to the selection event. So select any row and click on the download action button as seen in the illustration below. You can view the actions you have added.

How to Use a Table Grid Control?

Start with selecting the Table Grid Control from the Display section of the Controls Menu.

The Table Grid Control will then appear on the screen in the builder, you can then set all the above properties as per your requirements.

You can use the data option to bind data to Table Grid Control. You can learn more about validations here. There are four ways in which you can bind data.

  1. Sheet : This allows you to get value from a sheet and display it in the control.

  2. Logged In User: This allows you to select properties for the Logged In user like UserName, UserMail that would be the data for the table grid

  3. API: This allows you to fetch data using the Key values from the selected API.

  4. Custom Formula::This can be used to apply formulas and use the output of those formulas to set the control. You can learn more about formulas here.

Preview

Without Pagination

With pagination

To further understand how to use the Table grid control you can go through the article here and have a look at the following video.