Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleSet some data properties


In the stream properties on the right, set:

  1. Basic Settings → Period to Transactional

    Expand
    titleWhy?

    By default, a stream is optimised for processing large volumes of data.  You are aiming to create a form for users to update individual data records (transactions). Setting this property to Transactional tells PhixFlow how you want to manage the data.


  2. Tick Audit Manual Changes

    Expand
    titleWhy?

    This data will be updated manually by individuals. By ticking this box, PhixFlow will add a set of attributes to automatically record audit information about changes.

  3. Click 
    Insert excerpt
    _save
    _save
    nopaneltrue
     and then click on the
    Insert excerpt
    _pin
    _pin
    nopaneltrue
     to keep the stream properties open.  
  4. In the Attributes section, double-click Description and change its Type to Bigstring then click 

    Insert excerpt
    _finish
    _finish
    nopaneltrue

    Expand
    titleWhy?

    When you create a form for the data, PhixFlow recognises that data with the type Bigstring needs the field edit tools.



Expand
titleExplore the possibilities

Look in the Attributes section. When you connect PhixFlow to the Excel spreadsheet, it automatically identifies the properties of the data columns (attributes) such as their type (string, numerical) and length. This also happens when you connect PhixFlow to data stored in databases. 


...