Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

This topic is for application designers who need to define data tables, attributes, properties and relationships.

Overview

The purpose of an application is to display data to users and to enable them to make changes to the data. 



  •  screen displays data in grids and charts → view
  • user adds, removes or changes the data - form fields, buttons which are wired to actionflows

How you set this up

  1. Load existing Data: 
    • Quick load from excel
    • Use analysis model to connect to databases or other external data
  2. Define data structure: Use ERDs define the logical structure of the data that your application using tables and relationships.  Understanding ERDs and Defining Data Structures using ERDs
  3. Compile views: Decide what your application users need to see. Set up views for these
  4. Connecting data to screens: Design s


Action types and table types - calclulate etc.

Transactional

  • changing individual or small numbers of records - transactional changes.
  • You can also bulk change. Use an analysis model for complex processing of large number of data records.
Sections on this page

You can:

  • either define an ERD before adding any data to PhixFlow. In this case you create the tables, attributes and relationships
  • or you can load data from external sources first. You can then drag tables into the ERD and simply add the relationships.

Getting Data in

  • loading data page to do??: New concept page
    • Enter data yourself
    • Load excel files
    • Use an analysis model
    • generate test data
      • API to import from a tool
      • using input multipliers

Seeing Data

If you are working with tables that have records, to see them:

  1. Click on a table in the ERD to open its properties.
  2. In the properties toolbar, click  More Options.
  3. Select View Chart (this should be default view!??).
  4. PhixFlow displays a grid showing all the data records.
Other pages in this topic

  • No labels