Length check

Discuss the database features
Post Reply
Sharkey9999
Posts: 1
Joined: Tue Sep 19, 2017 11:27 pm

Length check

Post by Sharkey9999 »

Hi folks,

I'm new to OO base, I need to set up validation for a field to store telephone numbers (telNum)

I want the data input to check that 12 characters are always entered. I know I can set the length property to 12 but that only ensures a user cannot enter more than 12 - it does not stop them from entering 10 or 11 characters. I want to ensure that 12 characters are always entered - no more and no less!

(I can do this in FileMaker Pro by using a calculated field and setting calculation to "Length(telNum) = 12"

Is there a way to something similar in OO Base?

Many thanks in advance for any help

Derek
Open Office 4.1
Windows 7
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Length check

Post by Villeroy »

Database users should use input forms rather than direct table input. The max length of a textual form controls can be limited. Forms provide pattern fields.
viewtopic.php?f=61&t=10132
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply