I have a field, item ID, set to auto enter a serial number and validation set to not empty and unique. If the serial number entered is not unique I do not get an error message when exiting the item ID field. If I turn off auto enter serial number and manually enter a non unique item ID, I do get an error message when I exit the field.
With auto enter a serial number turned on I only get the non unique error message when I commit the record. I would like to get the error message when exiting the field when auto enter a serial number is turned on
I have a field which validation is set to Always, Allow user to override during data entry unchecked, unique value, custom message checked.
When validation fails the message box offers two options: revert record and OK.
Is there a way to trigger particular script if I choose OK?
or is there a way to get the message with only one option (revert record) to choose?
I am trying to put a conditional formatting validation which turns Red when the value is entered wrong. Basically all my tries have failed so I would like your help here.
The criteria of entering a value is
1. Length of value is = 19 OR this should be a 16 digit number, in groups of 4 separated with dashes
2. Non-Digits characters are not valid.
Please could you help me with this and I will really appreciate.
I have a database which I want to deploy using FMS16 webdirect. It has several value lists which form dropdown lists. One of these has a lot of text in the value list items and in the webd view these extend beyond the edges of the screen. Is there any way of formatting the dropdown list so that the value list items wrap into a specified size text box?
Many thanks for any input.