Versions Compared

Key

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

...

Form: Stream View Attribute Details

FieldDescription
Aggregate Function An aggregate function is only selected when you are creating a Grid view (a table of data) and you have specified one or more attributes with Group By role (see below). If required, select an aggregate function from the drop down list. Attribute Select one of the stream attributes from the stream. Name This only applies Order This is only important when creating a Grid view – the position that the attribute will be shown in the grid.
NameThe name of the selected stream attribute.
TypeThe type of the selected stream attribute. This cannot be edited here. It must be edited in the stream attribute.
AliasThe display name of the selected stream attribute in the view, should you wish it to be different. This is particularly useful if you specify an Aggregate Function. If you want to give the value that is generated by the aggregate function a different name from the original attribute name, specify it here. By default, the aggregated value will be given the same name as the original attribute. For example, if you are going to display the average age of debt, by applying the aggregate function Average on the attribute Debt Age, you may want to call this Avg Debt Age on the chart.
Role Select a role for the attribute:
  • Data Point: plot the data in the attribute. Any number of fields can be selected as data points, other than those used in other roles. For a Grid, all selected attributes must be data points.
  • Horizontal Axis Attribute: use the data in the attribute as the horizontal axis.
  • Horizontal Axis Label: display the values in the attribute along the horizontal axis. This is useful when you need to use one attribute to build the chart (specified as the Horizontal Axis Attribute) but one of the other attributes contains a value which is more meaningful to users when displayed on the horizontal axis.
  • Series: display a line on the chart for every value found. This is commonly used to represent some grouping value of the data. For example, in a chart displaying number of calls against date, if the stream also contains the Service (e.g. PSTN, Mobile, VOIP) then this can be used as a series to show separate lines on the chart for each of the services.
Default Chart Width This is only used when creating a Grid view - set the width of the column for this attribute. PhixFlow will create the grid with default column widths – you only need to specify a value in this field if the width you want is different from this default.
Aggregate FunctionAn Aggregate Function is only selected when you are creating a Grid view (a table of data) and you have specified one or more other attributes in your view, by which the data can be grouped. If required, select an aggregate function from the drop down list.
Decimal PlacesThis checkbox will only appear if the attribute contains Floats: the number of decimal places to display on the view.
Date/Time FormatThis checkbox will only appear if the attribute contains Dates or Datetimes: the format to display the date in on the view. This setting only applies when this attribute is used as the Column Attribute in a Pivot view.
Grid Default Width (pixels)This is only used when creating a Grid view: sets the width of the column for this attribute. PhixFlow will create the grid with default column widths - you only need to specify a value in this field if the width you want is different from this default.
Width On Form (pixels)This only applies on Form views: sets the width of the form field for this attribute. PhixFlow will create the form field with a default width - you only need to specify a value in this field if the width you want is different from this default.
Height On Form (pixels)This only applies on Form views: sets the height of the form field for this attribute. PhixFlow will create the form field with a default height - you only need to specify a value in this field if the height you want is different from this default.
Multiline on FormThis checkbox will only appear when creating a Form view: if checked, it is possible to press the Enter key on this field to create multiple lines.  
Changes Row ColourThis is only used when creating a Grid view: If ticked, then the row colour changes whenever the value in this field changes.
Read OnlyThis is only used when creating a Form view: sets the attribute so that it cannot be edited in the form.
HiddenThis is only used when creating a Form view: sets the attribute so that it cannot be seen on the form.
Selection View Attribute

This is only used when creating a Form view that will be used to obtain data from a user during a stream action.

This sets the dropdown list from which the user can pick a value. Drag the stream view attribute that you want to use for the dropdown list into this field. The Show the dropdown button option must be ticked to display the drop down.

See Configuring Selection View Attributes below for an example of configuring selection view attributes.

If another stream view attribute has a Selection View Attribute set and has Show the dropdown button set to yes, then it is possible to set the current stream view attribute from the same selection view without a further dropdown list. Drag the stream view attribute that you want to use to set this stream view attribute into this field

Drag the attribute out of the field to delete the contents of the Selection View Attribute.

Show the dropdown buttonThis is only used when creating a Form view that will be used to obtain data from a user during a stream action. This causes a dropdown list, from which the user can pick a value, to appear. See Selection View Attribute (above) for further information.
Size On FormThis is only applies to Form views. It shows how big the form field will be on the form. If you change the Width On Form (pixels) and Height On Form (pixels) values, then the size of this field will change.

Anchor
selectionViewAttributes
selectionViewAttributes

Configuring Selection View Attributes - setting up "drop down" lists

Configuring Selection View Attributes is illustrated with an example:

You have a selection of items for sale, as below:

Image Added

You also have a form view that allows you to edit these entries - this pops up when the Edit button is clicked:

Image Added

You need to assign a tax band to each item. You also have a set of tax bands configured:

Image Added

To help with this task, you will set up a selection list to populate the tax band and tax rate values for the sales items, from the list of tax bands. To do this, open the configuration form for the form view 008 Edit Sales Item, then open the configuration form for the view attribute TaxBand:

Image Added

Then open the list of attributes for the view that gives the list of tax bands:

Image Added

From the list of attributes that pop up, drag the attribute BandDescription into the Selection View Attribute field, and tick the Show the dropdown button flag.

Image Added

Populating further attributes from the same selection view

Repeat the same process for the view attribute TaxRate, dragging the attribute BandRate from the view of tax bands into the Selection View Attribute field. This time, do not tick the Show the dropdown button flag.

The form view will now appear as:

Image Added

If you press the button next to the TaxBand field the list of tax bands will appear - you can select a row from this list by double-clicking it. This will populate the TaxBand and TaxRate fields for the sales item with the selected tax band details:

Image Added

Controlling drop-down lists with other form values

You can use values that users have already entered into a form to control the values that appear in a drop down list. This is done by using the internal variable _form. Add a background filter on the view used in the selection view attribute, and include a clause which uses the value _form.formAttributeName to match values in the selection view with the value entered by the user in the attribute formAttributeName.

Model Ref: 008

Form Icons

The form provides the standard form icons.

See Also