This page (revision-10) was last changed on 02-May-2023 09:37 by Kevin Higgs

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
10 02-May-2023 09:37 3 KB Kevin Higgs to previous
9 26-Nov-2021 10:22 2 KB Kevin Higgs to previous | to last
8 26-Nov-2021 10:22 2 KB JMyers to previous | to last
7 26-Nov-2021 10:22 2 KB JEscott to previous | to last
6 26-Nov-2021 10:22 2 KB JEscott to previous | to last
5 26-Nov-2021 10:22 2 KB JMyers to previous | to last
4 26-Nov-2021 10:22 2 KB JMyers to previous | to last
3 26-Nov-2021 10:22 2 KB JMyers to previous | to last
2 26-Nov-2021 10:22 2 KB JMyers to previous | to last
1 26-Nov-2021 10:22 2 KB JMyers to last

Page References

Incoming links Outgoing links
IMUF
IMUF

Version management

Difference between version and

At line 1 added one line
[{TableOfContents }]
At line 9 added 19 lines
The definition data for the Define User Fields screen is stored in the [P2K_AM_TABLE_DETAILS] and [P2K_AM_USER_FIELDS] tables.
;[Table|TABLE_NAME]:The table that will contain the user defined field. This table must be permitted to have user defined fields.
!!User Field Info
;[Seq #|FIELD_SEQUENCE]:This specifies the order that fields are to be displayed on the user fields form.
;[User Field|USER_FIELD_NAME]:This field identifies the name of the user field. Field names may be alphanumeric, or contain the dollar ( $ ), pound sign ( # ) or underscore ( _ ) and must start with a letter.
;[Prompt |FIELD_PROMPT]:this field displays how the user field will be identified on the column.
;[Prompt (FRE)|FIELD_PROMPT_TRANSLATE]:If the form is to be displayed in a second language, this field allows you to provide an alternate language name for the user field. (On the example screen, the second language is identified as French, ‘Prompt (FRE)’.)
;[Field Type|FIELD_TYPE]:This field defines the type of data is to be contained within the user field. The types of fields supported are Date, Number, and Char (alphanumeric)
;[Required|REQUIRED]: If this toggle is turned on, this field becomes a required entry. That is, a blank entry is invalid.
;[Format Mask|FORMAT_MASK]:If there is some special formatting required for the field, the edit mask is defined in this field. This is typically used for date fields, to specify the format the date is to be shown in (DD-Mon-YYYY)
;[Lexicon Name|LEXICON_NAME]:If the field is to have limited values to choose from, you may wish to define a lexicon to contain those values. The name of the lexicon would be entered here, or may be chosen from a list. The lexicon must exist prior to selecting the name.\\
%%info If a lexicon code ([IMLN]) is associated with a User Defined Field, and the user defined field is added to a form, the value of the lexicon will be displayed on the form, however the User Defined Field will be stored on the [P2K_AM_USER_FIELD_VALUES] table as __Saved Value-Displayed Value__.
\\
\\
%%info Example if user updates the UDF on a form by selecting a value from the associated lexicon [X_YES_NO]. "Yes" will display on the form and "Y-Yes" will be saved on the P2K_AM_USER_FIELD_VALUES table (This will be visable using the UDF lookup or will be the value returned if using the [P2K_SMGLX] function).%%
\\
\\
;[User Field Usage|USER_FIELD_USAGE]:This field indicates if the user field is user defined or pre-loaded with the software.
At line 9 changed 14 lines
Table
The table that will contain the user defined field. This table must be permitted to have user defined fields.
User Field Info
Seq #
This specifies the order that fields are to be displayed on the user fields form.
User Field This field identifies the name of the user field. Field names may be alphanumeric, or contain the dollar ( $ ), pound sign ( # ) or underscore ( _ ) and must start with a letter.
Prompt
This field displays how the user field will be identified on the column.
Prompt (FRE) If the form is to be displayed in a second language, this field allows you to provide an alternate language name for the user field. (On the example screen, the second language is identified as French, ‘Prompt (FRE)’.)
Field Type This field defines the type of data is to be contained within the user field. The types of fields supported are Date, Number, and Char (alphanumeric)
Required If this toggle is turned on, this field becomes a required entry. That is, a blank entry is invalid.
Format Mask If there is some special formatting required for the field, the edit mask is defined in this field. This is typically used for date fields, to specify the format the date is to be shown in (DD-Mon-YYYY)
Lexicon Name If the field is to have limited values to choose from, you may wish to define a lexicon to contain those values. The name of the lexicon would be entered here, or may be chosen from a list. The lexicon must exist prior to selecting the name.
User Field Usage
----
![Notes|Edit:Internal.IMUF]
[{InsertPage page='Internal.IMUF' default='Click to create a new notes page'}]
This page (revision-10) was last changed on 02-May-2023 09:37 by Kevin HiggsTop