Page 1 of 1

Rules on the Datafiled panel

Posted: Fri Jul 10, 2009 3:50 pm
by Balazs Hober
Question
What does it mean the Range and the Valid value on the Datafiled panel?

Answer

Range: the set of allowed values, that you can enter in the cell of the field
Example: 1 - 10 (values between 1 to 10), you cannot enter 11, 55 ...etc.

Enter the range of datafiled
Image

What happens if the entered value is unsuitable?
Image

Suitable value for range 1 - 10
Image

Valid value: the set of allowed values, witch already exists in the field and witch you can choose from
Example: 1,2,5 you cannot enter 11, 55, you need to select from the existing three values (1,2, 5)

6 is unsuitable value if the selectable values are 1,2 and 5
Image

Re: Rules on the Datafiled panel

Posted: Fri Jul 17, 2009 2:26 pm
by Balazs Hober
Rules: regulations in order to ensure the quality and reliability of captured data

- None: no rule for the captured value
- Read only: the captured value can be read, nut not written to or modified (dim (grey out) form field)
- Not null: by default the data field cannot hold NULL values (mandatory field!)
- Unique values: by default the data field cannot hold duplicated values
- Range: viewtopic.php?f=10&t=145
- Valid value: viewtopic.php?f=10&t=145