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.
Tick Audit Manual Changes
Expand
title
Why?
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.
Click
Insert excerpt
_save
_save
nopanel
true
and then click on the
Insert excerpt
_pin
_pin
nopanel
true
to keep the stream properties open.then click
Insert excerpt
_finish
_finish
nopanel
true
.
In the Attributes section, double-click Description and change its Type to Bigstring then click
Insert excerpt
_finish
_finish
nopanel
true
.
Expand
title
Why?
When you create a form for the data, PhixFlow recognises that data with the type Bigstring needs field edit tools.
Expand
title
Explore 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.
