/

 

The manual

Self-training

Experimentation

Contact

 

Language

Handling of a file by program (continuation and end)

Define the values \u200b\u200bof a multiple choice field

There are three ways to define the possible values \u200b\u200bof a multiple choice field:

By providing the table of possible values \u200b\u200bdirectly at the level of the definition of the field ('Properties' 'Possible choices' at the level of the contextual menu of the control).

By taking the values \u200b\u200bin a report, possibly filtered by using other fields of the same form (always in the properties accessible via the contextual menu of the control).

Programmatically, using the 'option' instruction below.

Suppose 'f' is a multiple choice field on the form. So :

option f "" ""
option f "Vers le haut" "h"
option f "Vers le bas" "b"

allows you to specify that the drop-down menu will display three propositions which are '', 'Up' and 'Down'.

Multiple choice with two-step entry

In the case of a multiple choice field whose list of options is taken from a report, if we do not fill in the 'Label field' line, this has two implications:
On the one hand, the labels are identical to the values.
On the other hand, when entering, the list of possible values \u200b\u200bis not directly displayed. Instead, there is a free entry field. When this is filled in, if the value entered does not correspond exactly to one of the possible entries in the report, then a multiple choice is displayed just after, which proposes to choose among the 12 closest values \u200b\u200bsorted by order inverse of relevance.

Intercept the change in the value of a field

old_value

new_value

Rights management

allow_read

allow_write

require_read

require_write

Archive

Define the generic fields of the form

The program of a form can modify the following pseudo variables:

form_title

Define the title of the file.
The title is displayed in the upper part of the form,
can provide the page title when the form is the first block,
can provide the subject when the card is the first block of a sheet in a stack.

form_from

The 'from' field of the form is displayed when the form is the first block of a sheet of a stack displayed in list mode.

form_date

The 'date' field of the record is displayed when the record is the first block of a sheet in a stack in sheet list mode.
The value supplied can either be DateTime or simply Date.

form_resume