Working with Hidden Fields

Some Infor Lawson fields cannot be accessed through a form transfer or Portal search. When using the Portal, you access these fields by choosing a link from a related form to display another window. You can recognize a window of this type because it has no function code buttons.

If you plan to upload data to this type of field, use the hidden field feature in the Upload Wizard.

Note: The hidden field feature is only intended for expert users who have a thorough understanding of Infor Lawson form fields, buttons, CASE tools, and .scr files. Improper use of this feature could damage your data. Use this feature at your own risk.

If a form contains hidden (splat) fields, they display on the Map Columns tab of the Upload Wizard when you choose the list. Hidden field names begin with an (H). Hidden fields do not display on the form you choose in the Select Infor Lawson Form list; instead, they appear on windows that can be accessed only from the selected form.

To upload data using hidden fields, the upload worksheet must supply valid data values for all key and required fields for both the main form and forms that can be accessed from it. You can create a list of required fields and valid data values by viewing the .scr file for an Infor Lawson form.

  • The $TRANS section of the .scr file contains a list of all fields on a form, the type of data required, and whether the field is required. Codes that indicate whether the field is required include the following:

    SK Screen Key field. Always required for upload
    SR Screen Required field. Always required for upload
    LR Line required field. Always required for upload
    LF Line function code. Always required for upload
    SN May be required for upload
    LN May be required for upload
  • The $EDIT section of the .scr file contains valid values and defaults for each field on the form. You can check the $EDIT section to determine whether any of the fields you plan to upload has edit values that cannot be zero or do not have default values.

For more information on how to read .scr files, see the Doc for Developers: Application Development Workbench Standards.