This page is for data modellers who want to display data on a screen in a grid.

Overview

PhixFlow can display any Table data as a grid on GUI screens. This page will show you how to add data as a grid to any screen. It will go through a worked example of creating a grid of employees from various companies.

Creating an Employees Grid

Once you have a screen created it is simple to add any data to it. To add data:

1. Click 

   Insert excerpt
   _table_list _table_list nopanel true

    
2. Drag and drop the desired table onto the screen. In this instance, the Employees table is dragged onto a screen.
3. PhixFlow then asks how to display the data using:
4. Click Grid 
5. The attribute picker should then appear. Drag and drop the attributes to display directly onto the grid.

Marking Columns as Editable

By default all grid attributes are read only. Grids can be made editable by

1. Click on the attribute column header to open its property editor
2. Open Grid Settings

3. Untick Read Only

   Info
   Strings, Bigstrings, Integers, Floats and Decimals allow users to type to change its value Dates and Datetimes have a date picker to change its value Display name attributes will automatically appear as a drop down. Selecting a different value, e.g. Company, will automatically update the ID stored in the foreign key attribute

   
   

Saving data

To save changes to editable attributes

1. Right click on a grid and Show the view configuration
2. Open the Advanced section
3. Tick Auto Save
   This will automatically save any changes made to the grid. An action can be added as a save action below this field if required.

Drop downs

Any attribute can have a drop down added for a user to select a value. See View Attribute. 

More Information

• Filtering and Sorting Grids and Charts
• Formatting and Styling Grids and Charts
• Relational Views
• Actions on Grids and Charts
• For a complete list of view properties and their functions see View.