...
Form: Stream View Attribute Details
| Field | Description |
|---|
| Name | The name of the selected stream attribute. |
| Type | The type of the selected stream attribute. This cannot be edited here. It must be edited in the stream attribute. |
| Alias | The 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. |
- 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.
| 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 other attributes in your view, by which the data can be grouped. If required, select an aggregate function from the drop down list. |
| Decimal Places | This checkbox will only appear if the attribute contains Floats: the number of decimal places to display on the view. |
| Date/Time Format | This 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 Form | This 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 Colour | This is only used when creating a Grid view: If ticked, then the row colour changes whenever the value in this field changes. |
| Read Only | This is only used when creating a Form view: sets the attribute so that it cannot be edited in the form. |
| Hidden | This 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 button | This 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 Form | This 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 | ||||
|---|---|---|---|---|
|
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:
You also have a form view that allows you to edit these entries - this pops up when the Edit button is clicked:
You need to assign a tax band to each item. You also have a set of tax bands configured:
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:
Then open the list of attributes for the view that gives the list of tax bands:
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.
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:
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:
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.