Flow Connect Help
Roadmap
  • ℹ️This is Flow Connect
    • Overview
    • Technical overview
      • System requirements
    • What's new?
      • Change log
  • ▶️quick start
    • Create an application
    • Create an admin access group
  • 🔁working with Connect
    • Connect to systems
      • Connector agents
        • Add agent group
        • Install agent manager
        • Add agent
        • Manage agent
      • Connectors
        • IFS Applications 10
        • Oracle
        • Microsoft SQL Server
        • Send Email
        • REST
          • Microsoft Graph API
          • Infor M3 REST
            • Obtaining Infor ION API file
            • Configure REST Connector with ION API file
          • IFS Cloud
            • IAM Client Registration
            • Obtaining end-point info from IFS Cloud
            • Configure REST Connector for IFS Cloud
      • Redirect URIs
    • Create and design
      • Application packages
      • Applications
        • Create
        • Design
        • Test
        • Commit
      • Portal Pages
        • Create Portal Page
        • Design Portal Page
        • Commit Portal Page
      • Components
        • Create component
        • Manage component
      • Modules
        • Create module
        • Manage module
      • Automations
        • Functionality
        • Create Automation
        • Manage Automation
        • Creating Access Key
    • Deploy
      • Environments
      • Deploy
    • Use
      • On mobile devices
      • In web browser - Web client
      • In web browser - Portal
    • Share
      • Share Applications
    • User administration
      • Users
        • Invite a new user
        • Manage users
      • User groups
        • Create user groups
        • Manage user groups
      • Access
        • Manage access
  • ⏸️Reference
    • How-to guides
      • Create User Step controls
        • Header
        • Static text
        • Labelled static text
        • Link
        • Image viewer
        • Text input
        • Numeric input
        • Date input
        • Time input
        • Check box input
        • Binary option input
        • List selection input
        • List multi-selection input
        • Menu selection input
        • Data grid
        • Calendar control
        • Image selection input
        • List presentation
        • Camera Input
      • Dependent controls in User step
        • Variable source
        • Expression source
        • Control visibility (condition to hide)
      • Configure SSO for Microsoft Entra
    • Reference
      • Clients
        • Settings
        • My data
      • Designer
        • Controls
          • Header
          • Static text
          • Labeled static text
          • Link
          • External app launcher
          • Image viewer
          • Text input
          • Numeric input
          • Date input
          • Time input
          • Check box input
          • Binary option input
          • List selection input
          • List multi-selection input
          • Menu selection input
          • Data grid
          • Calendar
          • Image selection input
          • List presentation
          • Camera input
          • File gallery
          • GPS location input
          • Signature capture input
          • Item creation sub task
          • Check list sub task
          • Verb sub task
        • Steps
          • Start
          • User interaction
          • External system
          • Decision
          • Assertion
          • HTTP requests
          • Assignment
          • Table
          • Event listener
          • Checkpoint
          • Script
          • Annotation
          • End
          • Local data resource
      • Portal
        • Design items
          • Portlets
            • Accumulation chart
            • Base chart
            • Circular gauge
            • Custom content
            • Data tree
            • Document viewer
            • Filter
            • Kanban
            • KPI card
            • Link
            • My apps
            • Record
            • Rich text
            • Table
          • Container
          • Common portlet configuration
            • General
            • Events
            • Data
            • Custom buttons
            • Style
        • Portal settings
          • Branding
          • Page
          • Navigation
        • Profile
        • Portlet actions
        • Cache
        • Input to Start Step
      • Diagnostic mode
      • FlowScript
        • Walkthrough
          • Introduction
          • Expressions and programs
          • Anatomy of a program
          • Variables
          • Simple types
          • Nullable types
          • Records
          • Sequences
          • Other types
          • Arithmetic
          • Other expressions
          • Queries
          • Conditionals and loops
          • Function definitions
          • Built-in functions
          • DateTime module
          • Seq module
          • HTTP module
          • CSV module
          • JSON module
          • Trace module
          • Record module
          • XML Module
          • Custom modules
          • Custom Types
          • Appendix: Subtyping rules
          • Appendix: Escape sequences
          • Appendix: Type checking errors
      • Flowscript Copilot
      • Glossary
    • Flow Connect Downloads
      • Install Flow Connect Designer
    • Migrate from Flow Classic
      • Portal - migrate from Flow Classic
      • Classic vs. Connect Comparison Guide
Powered by GitBook
On this page
  • Prerequisite data
  • Add a data grid
  • Add configuration

Was this helpful?

  1. Reference
  2. How-to guides
  3. Create User Step controls

Data grid

This guide will take you through how to set up a data grid.

PreviousMenu selection inputNextCalendar control

Last updated 10 months ago

Was this helpful?

Prerequisite data

No connectors will be used in this example, but data from table steps will be utilized. Please download the file below; it will be used to import into the required table steps

Add a data grid

  1. Open an existing or create a new one in an and open it in the Designer.

    1. Add a User step.

    2. Add a Table step.

    3. Open the Table step and select Import File.

    4. Choose the semicolon separator and click OK.

    5. Select the "Data grid.csv" file downloaded in the prerequisite section above.

    6. Set the table variable name to "Articles" and click OK.

    7. Change the step name to "Articles". It's good practice to name steps after their content.

    8. Right-click on the "Articles" step, select Add data arrow, and connect it to the User step created in step 1.

  1. Open the User step.

    1. Add a Data Grid.

    2. In the Prompt, write "Choose an article".

    3. In the Source, choose the table "Articles".

    4. In the Columns, choose "Edit" to the far right.

  1. Choose "Add All Columns".

    1. Article column:

      1. Check the Hidden checkbox.

    2. Name column:

      1. Set the Size to Medium.

      2. In the Cell Color, write "{"GREEN"}".

    3. Description column:

      1. Set the Size Mode to Break.

    4. Cost column:

      1. Edit the Show as to Numeric.

    5. Discount column:

      1. Edit the Show as to Numeric.

      2. Check the Editable-checkbox.

    6. Add a new column, by pressing the + button in the top right corner.

      1. Set Show as to Computed.

      2. Check the Include in Output-checkbox.

      3. Set the Variable to "TotalPrice".

      4. In the Value Template, write "{isNull(Cost,0) - isNull(Discount,0)}"

      Flow engine cannot promise that the Qty-variable is not null. And you cannot multiply with nothing. By adding isNull, we tell the Flow engine what to do if it would be a null value.

      1. Set the Title to "Discounted price".

      2. Set the Cell Color to "{"#8cd3ff"}".

    7. Click OK to go back.

  1. Check the Allow add checkbox.

  2. Check the Allow Delete checkbox.

  3. Set the Row Selection Mode to Single Selection.

  4. Under Output, in Target Variable, write "chosenArticle".

  5. Click the Play button in the top right-hand corner to run the application in diagnostic mode.

Add configuration

When working with tables, connect offers a variety of possibilities to add configuration and style to make it look more suiting for your purpose.

  1. Go back to the Designer.

    1. Remove the cell colors from the Name and Total price columns.

    2. Under Appearance, change the Row Height to small.

    3. In the Item Style, open the editor by clicking the arrows to the far right.

    1. Add the code below.

    {case
        
        when Cost = 5 then '#65FFFF'
        
        when Cost = 20 then RGB(204,204,255)
        
        when Cost = 30 then 'GREEN'
        
        when Cost = 50 then '#EEA7F6'
        
        when Cost = 75 then RGB(204,255,204)
        
        when Cost = 100 then 'BLUE'
        
        when Cost = 250 then '#FDC096'
        
        else '' 
    
    end}
    1. Run the application in diagnostic mode again.

  2. Condition to hide

    1. In the Condition To Hide, write “{userId = “your user id”} (the user Id you log in to Connect with)

    2. Run the application in diagnostic mode again.

⏸️
application
application package
855B
Data grid.csv
The datagrid shows all articles, columns and the calculated price column. You can add a new row by pressing the + button above the data grid.
Once a row is marked, the Delete Row option becomes available.
The colors are now for each row, instead of the columns.
The data grid is now hidden since the condition is fulfilled.