Forms can be used not only for data storage, but as well for entering variables and using them afterwards in scripts.
Using forms for entering data, it is possible to enter several values in a convenient form.
Any form can be used as a form for data entry. For example, let's create a form with three fields and name it as Form1:
The fields are of following types: simple text field, date field, many-to-many relational field. If the database has no other forms, the created form may be indicated as a reference form for the many-to-many relational field.
Now, let's create a toolbar button, by clicking which a data entry form will be shown.
[$var_notes] variable is a recordset, with relational field entries. The [$var_notes_sel] variable is a recordset with entries selected at the moment of clicking the OK button. Recordset variables can be used, for instance, for operations in a recordset. To learn more, see the Usage of RecordSet Variables section.
The variable with the name of the selected prefix ([$var_]) is equal to 1 in case the user has clicked Ok. It is empty if the user has clicked Cancel or just closed the window.
Pre-check of entered data
It is possible to add a pre-check of entered data in the form editor.
The On Confirm verification script is also executed on creating a new record with the help of the popup form.
Copyright (C) 2001-2010 Binary Brilliant Inc. All Rights Reserved.