Help & Support
Contents
Display Legacy Contents

Search:

Home > Impact Suite > Tables and Forms > Define Fields and tables > Add a New Field

Add a New Field

To add a new field into the custom table click on this link.

This Define Fields form comes forward when you are adding or editing field.  

Field Name
The display name used in the interface

Alias

The name in the SQL database ( This can not be changed )

Allow Blank
Allow the user to leave the field empty.

Generate History
Create a history record when this field changes.

Primary Field
Is this a primary field.

Use drop-down list
Is there a drop down list the users can select from when doing data entry.




Default value ( Auto Fill  or Auto Populate )
The default value can be any text string or the default value can be automatically filled/populated from the parent record. Below we are populating the field using the value from the Contact's ID/Status field.

If you want to display the Contacts ID/Status field on the data-entry form without creating a field in the child table please read see 
Add contact field onto the form 


Field Format
The format string used to format the data entry pattern such as phone numbers.

Field Length
The maximum length of characters which can be entered into this field. In the old DOS/DBF days you always tried to make this the smallest number possible. In today's SQL driven data back ends it is not as critical to performance.

 


See also



Properties
Article ID:
add_a_new_field
Views: 269
Created By: jimdurkin
Modified By: [Modified By]
Created Date: 3/24/2014 12:31 PM
Last Modified: 3/24/2014 1:37 PM
Actions
Print This Article
Bookmark
Email This Article
Previous Article
Next Article