Fields And Buttons
With a click on the menu item Fields button, a new window opens that makes it possible to set up the tabs and fields for an Anveo Page Element.
Anveo Page Elements of type card have tabs. Tabs in the Anveo Web Portal look like tabs as you are used to in Microsoft Windows programs.
Fields on a Anveo Page define placeholders which can be filled with data from Microsoft Dynamics NAV 2009R2. A field can be also used as a button and can execute an action by clicking it. If you want to show data that is not saved in tables of Microsoft Dynamics NAV 2009R2 (e.g. variables or results of C/AL functions), you can use virtual tables and virtual fields here.
Fields have the following attributes and possible settings:
A field on a Anveo Page defines placeholders which can have different types. In the field Type you can set the type of the field, which can have the following values:
Depicts the data of a field from Microsoft Dynamics NAV 2009R2.
Defines the field as a button, that can execute an action.
Depicts a field of a virtual table, you have previously defined in the Anveo Web Portal.
The Field No. corresponds to the field number in the Microsoft Dynamics NAV 2009R2 table and can be selected from the existing fields via a lookup. FlowFields are available here too and are computed automatically.
The field Virtual Web Table Code equals the field Table No. of an , but only by analogy to virtual tables you have defined in the Anveo Web Portal.
The field Virtual Web Field Code equals the field Virtual Web Field Code, but only by analogy to virtual tables you have defined in the Anveo Web Portal.
The Description is adopted into Microsoft Dynamics NAV 2009R2, including the translations from the table captions. This way it is not mandatory to perform the extra work of entering all the descriptions with their accompanying translations again for the . If desired, you can adapt the field descriptions and translations manually at any time via the Assist Edit button […].
In the field Link with Previous Field you can define whether the current field is supposed to be linked with the previous field or not. For example, you can link a City field with the previous Post Code field since they have a direct correlation to each other. In addition, you can link the buttons with fields so that buttons appear in the field.
The Link with Previous Field flag can also be used in lists. If the linked field is shown in the Edit View you can define f.e. drop downs from there.
Setting a check mark in the field Sorting allowed means that the user of a client can sort records based on that field in the user interface.
Setting a check mark in the field Filter allowed means that the user of a client can set a filter on that field in the user interface.
To be able to sort or filter data efficiently on a field, the table in Microsoft Dynamics NAV 2009R2 or the SQL database requires a key or an index on that field. As a result, sorting is possible only on the kinds of columns that fulfill these prerequisites.
In the field Readonly you can specify whether the data in the field can be overwritten in the client or not.
Visibility indicates whether the field is supposed to be visible on the Anveo Page in the client.
In Anveo Page Elements of the list type you can use visibility to define whether the field ought to be hidden in the beginning. The user can decide to unhide the field afterwards. The setting done by the user during a session will not be saved for performance reasons. That means when opening the Anveo Page next time the field is hidden again.
In the field Font Size % you can set the font size in percent. An empty value is equal to 100 %.
A check mark in the field Bold ensures that the font is displayed in bold.
On lists you can define in the field Table Alignment if the content of the field should be aligned with the right or the left border.
A check mark in the field Add Caption ensures that the caption of the is displayed.
The field Width sets the width of a field. On lists the width corresponds to an absolute value.
Editable List Support
Defines if the field can be selected to be shown in the Edit View. The Edit View is a bar in iOS and Android that is shown above the keyboard. In Windows the Edit View is on the right side of the Page.
A field can be selected to be shown in Edit View independent of being editable or not.
Defines if the field content is selected for fast editing when the field gets focus.
Defines what field will select focus after pressing enter. This setup will be disregarded if a Script on enter is set.
Defines a script that will be performed, when pressing enter in the field. Several attributes can be set in this script such as Enabled and EditViewVisible.
If the Script on enter is filled the value set in Next fieldname on enter will be disregarded. If the focus should be set to a different field upon pressing enter this field needs to be defined within the script.
Modifications of the record and changes of the record in the Script on enter will be performed as two seperate transactions. All changes done to the record in the Script on enter will be performed after the MODIFY.
Further properties are placed in different tabs.
The tab General contains the following fields:
You can indicate a Default Value for each field. This value is set when creating a new record within the field.
Fixed restrictions in reading the records from the table can be set using the Filter Value. These constraints are permanently connected to the Anveo Page Element and are not dynamic. An application example here is filtering the table Sales Header in terms of certain kinds of documents such as quotes. The parameter values are set as the function SETFILTER in Microsoft Dynamics NAV 2009R2; in the case of option fields, the numerical value of the option value therefore has to be supplied. Dynamic filtering in Anveo Web Portal, for example reducing all data for a customer or a sales person, is resolved by the functions of the codeunit ACF Events. Within the Anveo Web Portal, synchronization packages are used for that kind of filtering (see section Synchronization Packages).
Using the field Decimal Precision View you can define within the client the number of digits following the decimal point. For example, the setting Decimal Precision View = 2 and Decimal Precision View = 5 means that the number 0.12345 is depicted in view mode as 0.12 and in edit mode complete as 0.12345. Rounding off is performed automatically so that the maximum precision is complied with.
Decimal Precision Edit
Using the field Decimal Precision Edit you can define the number of digits following the decimal point when the decimal value is being edited. The setup is analogous to the setup of the field .
Setting a check mark in the field Thousands Separator sets a separator in the thousands of a decimal number.
The tab Advanced contains the following fields:
The Field Layout specifies how the field is supposed to be depicted in the client. The depiction depends on the field’s data type and allows additional comfortable typing aids such as a calendar in a date field. In code fields with relations, the type Linked DropDown is indicated instead of Text Field. The existence of the relation is automatically detected when choosing the field. However, the data type can be changed here to Text Field when no drop-down is supposed to be offered.
In the Anveo Web Portal are additional field layouts you can choose from, such as Picture (shows a picture), Phone (field depicts a phone number), Barcode (allows scanning) and URL. Each of the selected layout shows automatically a button with a link next to it, without having to define a button with action code separately.
In the field Lock/Reload Behavior you can set locking and the scope of reloading fields in the user interface. The setting
Lock + Reload All Elements is set by default and means that while validating a new field value in Microsoft Dynamics NAV 2009R2, the current Anveo Page is locked and all fields are reloaded with data from Microsoft Dynamics NAV 2009R2 afterwards. In the setting Lock + Reload Current Element all fields of the current Anveo Page Element are reloaded only. The setting No Lock + Reload Current Element leaves the Anveo Page unlocked, so new data can already be typed in while the current Anveo Page Element is reloaded.
Make sure that a field with setting No Lock + Reload Current Element does not run a validate trigger that could lead to a change of values of other fields shown on the current Anveo Page because in the user interface would display data that does not match to those in the database (e.g. when entering a customer number in the field Sell-to Customer No. in a sales order).
The Field Name is the internal, unique identifier of the field on a Anveo Page that is automatically determined by the Anveo Client Suite. This value can be used for programming can or changing the user interface dynamically.
The tab DropDown List contains all fields for the optimal representation of a dropdown in the Anveo Web Portal:
Normally the relationship between the current Anveo Page and the one to be opened is created automatically via the global setup in the Anveo Page Table-Field Relation of the Anveo Client Suite. If a deviating relationship exists between the two or a relationship that cannot be depicted via simple field relations, a code can be indicated in the DropDown Custom Table Relation field that specifies this relation defined in C/AL code or via Anveo Script (see section Flexible Relations Between Anveo Pages).
You can use the field DropDown Search in Field to influence the results displayed in a dropdown list, when you type in a value in a field. DropDown Search in Field sets the order of the search results. For example, suppose you have in
Currency Code the field Code on the left side and Description on the right side and you type in “EUR” into the Currency Code, you have the opportunity to choose if you want to search for “EUR” in both fields, only in Code or only in Description. Furthermore, you can choose in which of the two fields the search should begin first. By choosing the option both (left first) the search begins in the left field (in our example the field Code) and continues until the list of search results is empty. If the list is empty, the search continues in the right field (in our example the field Description). The search operates with option both (right first) analogous to the option both (left first).
In the field DropDown Wildcard Search you can define the filter which will be used to filter results in a dropdown.
In a dropdown there are two fields. In DropDown Field 1 you define the first field of the dropdown. If different captions than that in the globally defined constants text DROPDOWNDEFAULTCAPTION1/2 are used, define your own language dependent captions by using the Assist-Edit button […].
Analogous to DropDown Field 1, only according to the second field of a dropdown.
In the tab Button are all fields for the definition of a button:
In the field Button Icon you can define the icon of the button.
If you want to open an Anveo Page by clicking the button, type in the code of that Anveo Page into the field Button Linked Anveo Page.
Normally the relationship between the current Anveo Page and the one to be opened is created automatically via the global setup in the Anveo Page Table-Field Relation of the Anveo Client Suite. If a deviating relationship exists between the two or a relationship that cannot be depicted via simple field relations, a code can be indicated in the Button Custom Table Relation field that specifies this relation defined in C/AL code or via Anveo Script (see ).
If you want to execute some other desired action by clicking the button, enter the code for the action that you have programmed via C/AL code or Anveo Script into the field Button Action Code.
By setting a check mark into the field Button Border a border will be drawn around the button.
In the tab Colors you can overwrite the default colors of the client and set own colors for the description, background and font. All colors have to be specified as a six-digit hexadecimal number (e.g. #FF0000 for red).
In the field Label Color you can define the color of the description.
In the field Field Font Color you can define the color of the font in the field.
In the field Field Background Color you can define the color of the field background.