Input Mask in Navision

Flashtn

Hi all,

How can I create an input mask in Navision ? Can I use Format propriety for a field in a form ?

Thanks in advance.

csimoneaux

Would you provide a little more detail? Is this a new field you created, an existing field? What do you wish to use masking for?

Draqos

Youd could use something like this:
Record.FILTERGROUP(1);
Record.SETFILTER(fieldToBeMasked, filterMask);
Record.FILTERGROUP(0);

It is quite restrictive, though... Depends on what you're trying to mask.

Flashtn

I would musk the serial number of items. Because of item variety in our inventoru, there is many formats for serial numbers. So, I would oblige each user to enter the right serial numbers.

Draqos

1. Declare Tmp -> Local TEMPORARY Record variable. same type as Rec
2. Add this code to the following table triggers:
On Insert & On Modify

Tmp := Rec;
Tmp.FILTERGROUP(1);
Tmp.SETFILTER(Code, '??'); //allows only 2 chars in "Code" field
Tmp.FILTERGROUP(0);
Tmp.INSERT;
IF Tmp.COUNT = 0 THEN ERROR ('insert correct format');

Draqos

IF the field is not within the primary key, add that code to the OnValidate FIELD OR OnModify TABLE.
For primary key field: OnInsert & OnRename