Each field in SamplingXL has various settings:
Field Setting |
Description |
Name |
Specifies the field name. This should be short and yet descriptive. It will be used when capturing to identify what is being captured |
Type |
This is the field type as described in the previous topic. |
Units |
Units the field is captured in. This is a free format field used for display. |
Description |
Field description, used as help text for the sampler during capture |
Annotation position |
The position in the section view display of the fields value (Top/left/Bottom/Right) |
Assayed |
Is this field populated from the lab after assay |
Required |
Must this field be entered by the user. (cannot be blank) |
Format |
Format for the field if it is a Date or Numeric field eg: 0.00, or yyyy/MM/dd. Uses .NET format strings |
Lookup Source |
Which of the defined metadata tables is used for the lookup values |
Read Only |
Can user enter values into this field |
Associated Field |
In the case of Sum and other aggregate type fields, this is the name of the field being summed in the subordinate data (Samples, or Sections). In the case of an Expression type field this is the expression to calculate the field. To test this expression use the context menu on the current row. Expressions use C# syntax and can refer to any other fields. You can use any of the Math, or DateTime functions in expressions, together with any of their methods or properties. For example Math.Sin(dip) * Math.Abs(dir). You could also use DateTime.Now.Adddays(1) for example. Also you can use C# conditional expressions like Width > 0 ? Width : DefWidth. |
Minimum |
Minimum value allowed if this field is of numeric type |
Maximum |
Maximum value allowed if this field is of numeric type |
Visible |
Is this field visible during capture |
Is this field printed in report grids |
|
Filter position |
The filter to use for Sum and other aggregate field types. This can be used to calculate sum over Reef only, hanging wall only et cetera |
Calculation Order |
Order in which this field is calculated in case of the field being an Expression field. The order is ascending. For example 1, 2, 3 |
Default value |
Default value for the field. Some fields like CreatedBy have automatic system default values anyway |