Home » Categories » Solutions by Business Process » System Features |
Default Text as Data Items |
Article Number: 314 | Rating: Unrated | Last Updated: Tue, Jun 20, 2023 at 6:08 PM
|
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. InstallationThe 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.) |
Attachments
![]() There are no attachments for this article.
|
Landing Pages - Expand and Collapse All Groups
Viewed 169 times since Thu, Oct 17, 2024
Company Specific Menus
Viewed 2007 times since Wed, Jun 13, 2012
Menu Design – Revert to Original Company
Viewed 38 times since Tue, Oct 15, 2024
General System Options - My Reports
Viewed 162 times since Thu, Oct 17, 2024
Log User-Id / Date / Time Database Record Updated
Viewed 3401 times since Fri, Oct 26, 2012
Print Database Structure
Viewed 2152 times since Mon, Jun 11, 2012
Password Security
Viewed 992 times since Thu, Jun 18, 2020
Sub-Items Break on Character
Viewed 1962 times since Wed, Jun 13, 2012
Landing Pages - Ledger Enquiry and Landing Page Date Formats
Viewed 176 times since Wed, Oct 23, 2024
Automatically Display Linked Files - Allow Items from Lookup Database in History/Details List - Link to BOM Detail Pick List
Viewed 1986 times since Fri, Jul 21, 2017
|