|
|
|
|
|
Apply Text Formula to a Field
(Field, TextFormula)
|
Used to modify the Field value according to TextFormula.
For example, you can set the Title field to Dear Mr [Second Name].
|
|
|
Apply Formula to a Field
(Field, Formula)
|
Used to set the Field value of the current database software record according to the specified Formula.
For
example, if the Quantity field is set as the Field parameter, and
[Quantity]+1 set as the Formula parameter, the value of the Quantity field will be incremented by 1 (Quantity=[Quantity]+1) when the action is executed. To learn more, see the Formula Editor section.
|
|
|
Change Image Field
(Field, PathToImage)
|
Used to set a picture for the field specified in the Field parameter from a file specified in the PathToImage parameter. PathToImage is a
text formula
parameter, so it can contain variables, field values, etc.
|
|
|
Spell-Check Field
(Field)
|
Used to spell-check words in the specified Field. The spell-check uses English dictionary. To add additional words to the dictionary (e.g., to add a new language), copy them to the file tahspelldic.txt stored in the data folder of the program. Only one word must be placed in each line.
|
|
|
Execute Onchange Action
(Field)
|
Used to manually execute onchange actions for the specified Field. For example, you have the C field which is based on the A and B fields. You can set up an onchange action only for the A field, and use Execute onchange action (Field A) for the B field to update the C field when the A field or the B field has been changed.
|
|
|
Open Input Dialog for Field
(Field)
|
Used to move the input focus to the specified Field and open an input dialog if necessary.
For example, the calendar will be opened for the date field and the Open file dialog will be opened for the image field.
|
|
|
Clear Field
(Field)
|
Used to clear the specified Field.
|
|
|
Change Relational Field
(Field, Recordset, Operation)
|
Used to add/delete database software records in the many-to-many relational field
or simple relational field. You should specify a necessary field in the Field parameter. The database software recordset to be added or deleted is specified as a variable of the RecordSet type in the Recordset
parameter. The Operation parameter specifies whether database software records should be deleted from the field or added to it. Before you use this action, you should create a variable containing the database software recordset you want to add or delete from the field. To create the variable, you should use a script (to learn more, see the Variables section).
RETURN VALUE: Returns 1 if the field was changed; otherwise 0 is returned.
|
|
|
Run script for database software recordset
(Recordset, UserFunction)
|
Used to apply the selected UserFunction custom function to the database software recordset specified in the Recordset variable. To learn more, see the User Functions - Changing Several Records section.
RETURN VALUE: Returns 1 if database software records were changed, otherwise 0 is returned.
|
|
