Home » Categories » Solutions by Business Process » System Features

Default Text as Data Items

Datafile Software

Default Text as Data Items

Occasionally there is a requirement for a text data item to default to a particular character or phrase when adding records but allow occasional overtype. Usually this is achieved by defining a lookup to another database and copying this value in – for example if default text required on a Sales Order Header input then the value could be copied from the Sales Ledger Accounts file. This does mean that this input needs to a) be on every record in the lookup file and b) any new records in the lookup file need this value set also.

This new feature allows for the setting of the default text in the lookup database so that the value is updated for every existing and new record automatically and thus available to copy to the ‘main’ database.

Installation

The default text is achieved by a special naming convention of the data item name.

Data item must be a text (X) type field and the data item name must begin with the characters ‘!=’ followed by the actual default text. Item size should be set equal to this default text. The maximum size of the default text is 11 characters.

Notes

This option is intended for use in copy items and database extracts. It cannot be used to set default text on the ‘main’ database itself as whilst any default value can be overtyped on save of the record it would revert back to the default text (it also cannot be used in group items etc.)

Custom Fields
  • Release ID: 5.8
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Output to Excel Pivot Table
Viewed 24228 times since Tue, Jun 12, 2012
General System Options - Increased No of Saved Selection Criteria
Viewed 195 times since Thu, Oct 17, 2024
Landing Pages - Ledger Enquiry and Landing Page Date Formats
Viewed 193 times since Wed, Oct 23, 2024
Application Memos – Warning or Note
Viewed 1139 times since Wed, Jun 13, 2012
Ledger Enquiries – Application Web Links
Viewed 690 times since Wed, Jun 17, 2020
Landing Pages - Company / Key-Item Selection
Viewed 158 times since Tue, Oct 15, 2024
Order Enquiry - Allow Label Print from Order Details
Viewed 1985 times since Mon, Jun 11, 2012
Warehouse Tablet - Goods Received Image Capture
Viewed 178 times since Wed, Oct 23, 2024
Documents to Email - Merge PDF Attachments
Viewed 2318 times since Mon, Jun 11, 2012
Ledger Enquiry / Display Notes by Department
Viewed 2185 times since Mon, Jun 11, 2012