Log in Register

Login to your account

Username *
Password *
Remember Me

Create an account

Fields marked with an asterisk (*) are required.
Name *
Username *
Password *
Verify password *
Email *
Verify email *
Captcha *

Freefields plugin - Activation

Article Index

Page 2 of 7

Activation

On the Setup ribbon, select Tools → Plugins → Generic plugins → Freefields.

 

Select On to activate the Freefields plugin. You can activate Freefields and maintenance of search screens (Design search fields) and dialog (Design edit fields).

Design edit fields

If you click on the "Design edit fields" button you will see the following screen.

You probably have less free field definitions, but you can add more.



If you double-click on SYSVARS or click on the "Edit fields" button, you may add extra field. For example, if you click on the Contact name field, the options and settings for that field is displayed.

The options is as follows:

  • Cancel: Cancel and go to the list.

  • Save: Saves the layout in the database. If new fields are created, this process can not be undone. Pay close attention to the type and length of the field. These can not be readily modified once the field is created.

  • Add new control: Adds a new control to these field and you can then edit.

  • Delete: Delete active control.

  • Save Input settings below so that you see it. When creating a new field (Colomn origin that does not exist), a field of type in Field type created. This is not just to remove this editor. We refer you to a database management tool like FlameRobin. FlameRobin allows you drop the fields. Alternatively, you may execute this by using SQL by example the command alter table mytable to enter the correct value. drop out mycolumn

  • Type of control: You can choose from different types of controls so that interaction with that space is affected. Types are explained in the appendix at the back of this document. Choose the type of control for the correct data type. For example, A checkbox is a SMALLINT, a numeric value with decimal places a FLOAT, etc.

  • Size: Set the size (width) adjusting this field is great for a text or numeric field (like big) once the field is defined in the database has no effect You will then have to build the large field in the database itself.

  • Translation: Choose an existing translation or add one to the current database and use it.

  • Column origin: Enter your new field name when creating a new control or choose from an existing list columns. For example, if you have a table designed, you can choose from this list the fields you want to edit.

  • Field type: A new field (not existing name in Column origin) is used as this type is created. Depending on the type is then also taken along the Size.

  • Default value: Default value may be a set. (For example, "select current_timestamp from rdb $ database" creates a date field – today as the default value for this field. This is usually combined with the head type a to-many relationship.

  • Left, Width, Top, Height: Controls to set the width increases etc., Some controls do not have all the values. For example, you may set a memo type to enter multiple lines. When doing an edit, the height has no effect.

  • Enabled: Set the field (temporarily). This usually comes at a migration in which old data e x a time are still visible.

  • Sql and extra data: - for some field types, this field is used, for example to build. The sql of a list with This is a dropdown filled with the correct value. For example, dressings can be used to build up a choice list. Think of a list box in a document that knows which debtor has been chosen and therefore can be used to limit. The list of possible choices the free fields of debtor

The input fields for Sysvars is found in Setup → Company info.