Category

Creating a Child Grid using Workflow

You can create a grid within a form, this grid is named as the Child Grid. Typically, this is done by connecting two spreadsheets, having some column values in common, using Object DNA. However, you can now create a Child Grid entirely using a workflow. This workflow is then connected to the respective form.

Building the workflow

Pass the values you want to display on the child grid to a workflow consisting of a Get Parameter Block, Spreadsheet Filter Block, Clear Output Block, and a Custom Output Block.

Use the Spreadsheet Filter Block to filter and display only the desired data on the child grid.

Use the following syntax to enter data in the Output Data field of the Custom Output Block:

ESCUP
"ss":"spreadsheet shortcode",
"data":{filter block name}, 
"editable":"true"
ESCDOWN


Here

  • “cardssprabhisbsa6350e83d5b639” represents the shortcode of the spreadsheet used in the Spreadsheet Filter Block
  • “rows” represents the Filter Block name
  • “editable”:”true” displays an editable spreadsheet as shown in the screenshot below:

  • “editable”:”false” displays a read-only grid as shown in the screenshot below:


In addition, you can enter
“readonlycolumns”:”column name”: to set a specific column in the grid as read-only

“hide”:”true”                                    :  to hide the child grid for specific user roles

“emptyrows”:”false”                        :  to hide empty rows in the spreadsheet

“sstab”:”true”                                 :  to display spreadsheet tabs

 

Consider the example below:

 

Here, the columns “Currency” and “BankName” are set as read-only, spreadsheet tabs “Add Row”, “Refresh”, and “Wrap Text” are displayed, and empty rows in the spreadsheet are hidden.

 

You can set alias names for the child grid column names. For this, add a Set Variable Block before the Custom Output Block as shown in the screenshot below.

Label the Set Variable Block as Column Alias. Enter child grid column name in the field Variable and alias name in the field Value as shown in the screenshot below.

Enter “alias”:{set variable block name} in the Output Data field of the Custom Output Block.

 

Here, the child grid column names are shown as defined in the Set Variable Block.

Connecting the workflow to the form

  • Open the Form Builder page.

  • Click DNA Container.
  • Enter a title and select the workflow from the dropdown list.

  • Click Update.