Manage data entry forms
Each insertion module is composed of one or more blocks that identify the tables from which the data is extracted. The title shows the table and the alias used in the query.
For each table, by clicking on show attributes, it is possible to modify some display parameters
Choose whether the field should be used in the data entry form
Text (Single line):A single line of text. the "Autocomplete" check activates the suggestions by proposing the other text fields already inserted.
Text (Multiline)textarea. unformatted.
Date Date formatted according to the wordpress configuration.
DateTime Date with time, formatted according to your wordpress configuration.
NumberA single integer (negative or positive). To limit it see javascript functions.
Decimal Number with two numbers after the decimal point.
Multiply Choice - Drop-down list Single response select. The answers are entered in the choices field. One row for each choice. value,label<
Multiply Choice Radio buttons
Checkbox (Single Answer) Attention, remember to enter the value of the checkbox you want to save.
Checkboxes Checkboxes, Multiple Answers. The data is saved in a json.
EMail The field must contain the @ symbol.
Link The field must be a valid link.
Primary value It can only be assigned to fields that have a primary key. By default it is read only, but it can be changed.
ReadOnly The field is read-only and cannot be changed.
Editor Code Activate the code editor.
Classic text editor Activate the classic editor. Check the user setting.
Record Creation Date The creation date of the record is saved. The field is not overwritten during editing.
Last update Date The date the field was last modified is saved.
Author The id of the author of the record is saved. The field is not overwritten during editing. Only one author field can exist in a form. The author field activates the permissions section in the "Settings" tab. Through this option you can select the author role and the editor role. The author role can only see and edit its own records. If you activate the status field in the same form you can also manage the contributor role, i.e. users who can write and see only their records, but cannot publish them.
Modifing user The ID of the author of the last modification is saved.
ORDER The order of the record is saved. After setting a field order, this is pre-populated every time a new field is created with the highest value in the list. If you don't want it to be modified you can enter it as hide. Therefore it is advisable to change the sort order in Setting by setting the query order for the newly created field. Finally, in "List view formatting", check that the sorting column is set to order type. This way you can drag fields and sort them directly from the record list.
Status (Publish, draft ...) The status of the post is saved. Only one author field can exist in a form. You can choose from the following statuses: draft, publish, trash. The status "pending" is activated only if an author field also exists and used only for users with the contributor role. Only publish records are displayed in the frontend. The post status field behaves differently in the browse the list field or if the form menu item is selected.
Lookup field [PRO]
Lookup fields are used to link data with other tables using primary key.
The "WHERE query field" is used to limit the data that will be displayed.
Calculated Field [PRO] The calculated fields are filled in upon saving with the formula you entered into the formula. You can copy a field using the template engine variables [%data.variable_name] or create new fields by requesting data from posts or users eg [^POST.title id = [%data.post_id]. To calculate the number of the newly created row you can use [%row], while if you want to create a new identifier you can use [^COUNTER]
Post A post id is entered. you can filter the types of posts that can be inserted
User A user ID is entered.
Media Gallery The id referring to a file uploaded to the WordPress media gallery is entered.
Insert javascript to customize the insertion experience.
Example: The field is valid only if it is between 0 and 100
field.valid_range(0,100);
Example: I show the field if the value of a hypothetical checkbox is equal to 1
field.toggle(form.get('mycheckboxlabel').val() == 1);
" target="blank" class="js-simple-link">Approfondisci
It is the value that is presented when a new record is inserted. You can insert template engine shortcodes.
Example:
[^user.id] [^NOW] [^request.xxx]
Add one or more css classes to the field.
You can align two fields next to each other by adding the dbp-form-columns-2 class to the two fields.
For checkboxes and radios it is possible to paginate the options in multiple columns by adding one of the following custom css class:
dbp-form-cb-columns-2, dbp-form-cb-columns-3, dbp-form-cb-columns-4
Lookup fields are used to link data with other tables via primary key. it is important that the linked table has a single primary key.
If the table is in DRAFT mode then from the form it is possible to modify its structure.
Delete field removes the field and all data entered in that field
If you don't want to remove the column or can't edit the table you can hide the field from the select show / hide
When you create a table it is put by default in DRAFT state. you can change the states of the tables with the PRO version.
If the table is in DRAFT mode then it is possible to create a new field in the table. If you want to have more control in the creation of fields, you can go to the table structure and modify it.