Define form fields

To define (add, update, or delete) a form template's fields:

  1. Go to the Form Fields Definition screen. 
  2. To:
    1. add (define) a new field, position the cursor where you want to insert the new field and then click New.  Go to step 3.
    2. update an existing field's definition, select the row containing the field, and then click Open.  Go to step 3.
    3. delete an existing field, select the row containing the field, and then click Delete.  At the Form Fields Definition - Delete screen, click Save.  EmpowerHR deletes the field and adjusts any pre-existing fields' sequence numbers.  No further action is required.
  3. At the Form Fields Definition details screen, complete or update the field definitions using the following tables as a guide.
At this field...
Do this...
Form CodeNothing.  EmpowerHR displays the form code.
Field
Nothing,  EmpowerHR displays the sequence number for the form field.
Field Title
Enter a title for the field (up to 30 characters).
Field Info
Enter information you want to display on the form to assist the user (up to 500 characters).
Data Type
Click Window, find and double-click the code to add it to the Data Type field.

Display Format

If you selected f (Floating Point Number) as the Data Type, then enter a valid display format, fx.y,  For example f6.2, f10.7  

Otherwise, leave this field blank.

Length

Depending on the Data Type you selected, enter the length of the field (number of characters).

Validation

Depending on the Data Type and Length you set, do one of the following:

  • Click Window, find and double-click the code to add it to the Validation field, or
  • Leave this field blank.

See the following table, field validation explained, for more information. 

Same Line as Previous Fld (y/n)

If you want to display two fields on the same line, enter y.

Otherwise, enter n.

Required Selection (y/n)

If you selected s (Selector List) as the Data Type, you can enter y here to require the user to select a value in the field

Otherwise, EmpowerHR displays the default, n.

SQL

Information Only use this field if you selected h (Database SQL hook) or e (Table) as the Data Type.

Enter the SQL commands EmpowerHR executes to populate the field or table. 

See SQL for self service forms in the EHR Technical User Guide  for examples of SQL statements and tags.

If you don't have access to the EHR Technical User Guide, you can log an iHelp request and we will provide login credentials to you.

  1. Click Save.  Where you add or delete a field, EmpowerHR adjusts any pre-existing fields' sequence numbers.  

Field validation explained

Here's how field validation behaves according to:

  • Data Type
  • Display Format
  • Length
Data Type
Display FormatLengthValidation
b (Checkbox)Not enterableNot enterableNot enterable

c (Character)

Not enterable

10

1 - 500

If Length is 10, enter empl (Must Be a Valid Employee)

If Length is between 1 and 500:

Click Window, select blank (Must Be Blank), nblnk (Must Not Be Blank), or yes/no (Must Be (y)es or (n)o)

or

Leave this field blank

d (Date)

Not enterable

Not enterable

Click Window, select blank (Must Be Blank), or nblnk (Must Not Be Blank)

or

Leave this field blank

e (Table)

See define table field for more information

Not enterable

Not enterable

f  (Floating Point Number)

Enterable

4 or 8

Click Window, select nzero (Must Be Zero), or zeros (Must Not Be Zero)

or

Leave this field blank

h (Database SQL hook)

See define database SQL hook for more information

Not enterable

Not enterable

i  (Integer)

Not enterable

1, 2 or 4

Click Window, select nzero (Must Be Zero), or zeros (Must Not Be Zero)

or

Leave this field blank

l  (Form Section Label)

Not enterable

Not enterable

Not enterable

m (Money)

Not enterable

Not enterable

Click Window, select nzero (Must Be Zero), or zeros (Must Not Be Zero)

or

Leave this field blank

s (Selector List)

Not enterable

1, 4 or 8

Click Window, find and select a valid code.  The lookup window displays the available codes based on the Length (that is, Code Type 1, 4, or 8).

You cannot leave this field blank. 

 



Next topic

Define database SQL hook



© 2023 Fusion5. All rights reserved.