PostgreSQL PHP Generator online Help

Available editors

Additional options

Editor appearance

Text

Set the Size of the text block. The Max length value is the max number of signs to enter.

Combo box

Enter the list of the allowed values in pairs an_allowed_value=value_to_be_represented separated by a comma (Example: 1=One,2=Two).

Specify the most-frequently used values to be always displayed at the top of the list. To do this, click the ellipsis button next to the Most frequently used values and add values within the corresponding window.

You can also enable a lookup editor based that contains one or more table columns. For this purpose, specify Item caption template.

Radio group

Enter the list of the allowed values in the same way as for Combo box editor.

Autocomplete editor

Use this editor type as lookup editor to work with a quantity of records.

Multi-level autocomplete editor

The control is based on cascading drop-down lists and allows users to select a value from a long list step-by-step. For example, when we select a country in the Country drop-down list, it will populate the City drop-down list according to the country selected, and so on. To find out more instructions use the corresponding topic.

Specify the levels in the dialog opened by the ellipsis button. To set a new level, enter the level caption, parent data source (a table that contains data to be displayed on the next level of the editor), and the name of the column the data to be displayed. Key field of the parent data source and child field to filter must contain the same values.

Check box

The editor is set for boolean columns by default.

Check box group

Enter the list of the allowed values in the same way as for Combo box editor.

DateTime

Check off the Show time box to represent the only date. By default, the format of the column's data is the same as it is set at the Project options. Use the DateTime format field to setup format of the current column.

Time

This editor is used by default for columns that store time-of-day values.

Spin edit

This editor type allows you to set the constraints (Min value, Max value) on the entered data.

Mask edit

Use the edit control to define an edit box that limits the user to a specific format and accepts only valid characters. For example, you can define an edit box for telephone numbers setting 999-999-9999 as the mask of the editor. In this case the created data entry field accepts only numeric input and if a user then tries to enter a letter in this edit box, the application will not accept it.

Text area

Define the size of area visible text part using the Column count and Row count fields.

Html Wysiwyg

Use the editor to provide PHP scripts' users with the ability to directly manipulate the layout of a HTML data stored in the column, without having to type or remember names of layout commands.

Password

Displays the field as a masked textbox.

File upload

If BLOB data will be edited with such editor, you can limit the size of an uploading file with the Use file size limitation option and the Max file size field. To store names, types, and sizes of uploaded files, specify the proper columns as File name field, File type field, and File size field respectively.

Image upload

If BLOB data will be edited as Image uploads, you can limit the size of an uploading file, specify columns to store names, types, and sizes of uploaded files in the same way as for File upload. To limit the size of uploaded images, use the Use image size limitation options, and set the necessary Max width and Max height.

Upload file to folder,

Upload image to folder

To use the column to store paths to uploaded files, setup the Folder to upload and the File name using templates. To use a random number as filename, check the Generate random filename box.

The Generate thumbnail option allows you to save resized copies of uploaded images to a specified catalog. To do it, check the corresponding box, specify the Field name the thumbnail path to be saved to, set the Folder to upload and the name of the created file (It's possible to use templates or random file names) and submit the resize rules.