Elastic Fields Customization
To the right of the Elastic Window Preview is the settings of both the Control being edited and the global settings, In this article we will go over all of the settings available for Controls and what they affect.
- DataType: defines how the data is stored in the database, there are different options depending on what field is being edited:
- Bit: a simple 1 or a 0, used by the CheckBox to see if its active or not.
- Varchar: Character Variable, this is a flexible text storage in the sense that it allows user to pass the character soft limit set by the designer.
- Char: similar to Varchar but instead of a soft limit, there is a hard limit on how many characters are being stored, if the designer sets X characters the user cannot pass it.
- nVarchar/nChar: works identically to their non n versions except that the data is stored using Unicode, allowing for a much wider amounts of characters at the expense of larger file sizes. Especially useful if the data being stored is not in the English language, such as many Asian languages that have an alphabet not normally supported by Dynamics GP.
- Text: Also stores a string of text but unlike Varchar/Char Text has no limit to what it can store.
- Decimal (18.5): Allows numeric entries to have a decimal point with up to 18 digits on the left side and 5 digits on the right.
- Integer: Has a slightly smaller footprint in the database than decimal but does not allow the storage of decimal numbers.
- DateTime: storage of dates, only used by the Date field
- Image: the storage of full image files, only used in the Picture field.
- FieldName: What the field displays in the Elastic Window as well as the name of the table in the database
- DefaultValue: What the field has pre-populated when a new entry is created
- MaxLength: used in Varchar/Char values, its the maximum length that the value will be when stored in the database
- MiddlePoint: In case the FieldName is too long or for organizational purposes the MiddlePoint is used to ‘indent’ the text box, the number put here corresponds with extra space that will be given to the FieldName portion of the field. The MiddlePoint also accepts negative values.
- SQLScript: Similar to the DefaultValue but the Designer uses a SQL Script to grab a value from the database to pre-populate the field.
- ComboValues: Used in the ComboField, this is where the drop down list of possible entries will be placed, these possible entries follow the rules for the DataType selected
- Extend: Allows the users to put in their own possible entries through an external window they open, Useful for adaptability but can potentially allow for erroneous entries