Some Centre's have an interest in designing the Printout template data fields to display as a collection of check boxes that only one of them is ticked depending on what is actually selected in a CLASS record see an example of that below:
Just note the design itself is quite time consuming to produce so use it sparingly.
This is possible please review the training Video below:
To Create a Calculated Field:
From the Fields List Menu on the right hand side:
- Left Click on the Field List Menu
- Left Click on the SQL data source OR Expand it and left click on the Table you wish the Calculated field to be created in or be a "Member of"
- Press the New Calculated Field Button
- Fill out the Calculated Field's properties
- Create a name with no spaces and a consistent naming convention i.e. if you will create several fields that are related to one standard field or custom field in CLASS name each field along those line i.e. "ATSI_Yes" , "ATSI_No", "ATSI_Both"
- Display name is the more human readable name and can contain spaces
- Field Type - is the kind of data you want the Calculated field to process as well as display
- Boolean's work well with Check Boxes
- Labels can accept strings
- Use Date Time to calculate or represent date fields
- Int32, int64 are whole numbers
- Float is floating point numbers i.e. 1000.45 , Decimal is similar
- The others would be used quite sparingly if not at all
- Data Source - Just make sure it points to "SqlDataSource1" its the "Where Am I getting Data from sort of field"
- Data Member - The Table the field will sit under i.e. Service, Service Action, Client Information and also this will govern what fields that can be used in the Expressions section or editor.
- Expression Editor uses some programming to produce calculated fields or fields with Smarts behind them. Press the Ellipses to begin editing.
Working Example & Calculated Field Expressions of the above ATSI Status Diagram:
Remember in plain English the expressions in this case are just saying if my field "Aboriginal and Torres Straight Islander Status" is equal to a particular value i.e. Yes, Aboriginal I should be ticked (represented by the 1) and if it is not that value I should NOT be ticked (represented by the 0).
Field | Expression |
---|---|
ATSI Yes Aboriginal | Iif( [AboriginalAndTorresStraitIslanderStatus] == 'Yes, Aboriginal',1 , 0) |
ATSI Yes TSI | Iif( [AboriginalAndTorresStraitIslanderStatus] == 'Yes, Torres Strait Islander',1 , 0) |
ATSI Both | Iif( [AboriginalAndTorresStraitIslanderStatus] == 'Both Aboriginal and Torres Strait Islander',1 , 0) |
ATSI Unknown | Iif( [AboriginalAndTorresStraitIslanderStatus] == 'Not stated / inadequately described',1 , 0) |
ATSI No | Iif( [AboriginalAndTorresStraitIslanderStatus] == 'No',1 ,0) |
A screen grab of what these fields looked like in the Field List:
The potential finished field on the Print Screen:
Advanced or "Other" Type of fields video soon:
tba