Log In

Log In

Not registered yet?

Reset password Activation link


Form Validation inquiry

Publication date: April 30, 2019

Hi Igor,

I have a form with Name (no duplicated entry configured) and Image Upload 1, Image Upload 2 ..etc.

When a user enters a duplicate name, and the form gives instructions to change it, the user changes the name but upon submission the form gives an error saying “Image 1 can’t be blank. Image 2 can’t be blank” although pictures are already uploaded. Once we re-upload the pictures there is no problem.

I tried both “validate only on submit” and without (while checking “can’t be blank”) but still if a user enters a duplicate name, the images won’t be submitted unless we re-upload them.

This gives confusion to my users. Please advise, thank you.

Number field - validation

Publication date: August 14, 2018


is there a possibility to add a more strict validation to a number field?
at this moment : can’t be blank is available.

could there be : minimum, maximum ?



How to use Regular Expressions in QuintaDB

Publication date: December 11, 2018

In QuintaDB you can use Regular Expressions as an advanced validation option for text fields.

Go to the Fields menu. Open text field for editing. Find the link Additional options under the Validation section and click on it.
Insert Regular Expression in the field Format.

Regular Expressions

You can use this validation for mobile number checking.

/^[ 1 ]\d{6,15}$/ – USA phone number format. Starts with the 1 then from 6 to 15 digit.

/^([ 2 ][ 1 ][ 2 ]|[ 3 ][ 1 ][ 5 ]|[ 3 ][ 4 ][ 7 ]|[ 5 ][ 1 ][ 6 ]|[ 5 ][ 8 ][ 5 ]|[ 6 ][ 0 ][ 7 ]|[ 6 ][ 3 ][ 1 ]|[ 6 ][ 4 ][ 6 ]|[ 7 ][ 1 ][ 6 ]|[ 7 ][ 1 ][ 8 ]|[ 8 ][ 4 ][ 5 ]|[ 9 ][ 1 ][ 4 ]|[ 9 ][ 1 ][ 7 ])\d{7}$/ – NY phone codes.

/^([ 0 ][ 8 ][ 0 ][ 0 ]|[ 8 ][ 0 ][ 0 ])\d{7}$/ – For free 800 or 0800 numbers.

/^([+][ 3 ][ 3 ]|[ 3 ][ 3 ])\d{8,9}$/ – For France numbers, format +33 or 33 and from 8 to 9 digits

Cant Find Information On Format (regular expression)

Publication date: August 16, 2018

Not even sure it will do what I want anyway.

What I am wanting to do is input numbers like:


And have them format consistently as:


I thought the field format tools would do this, but don’t see how.

Hmmm - Required Entry

Publication date: August 16, 2018

I have on my form a relationship many and belongs to. It is a required entry as if not completed my companion software I further process the data with doesn’t function correctly.

However the blokes filling the form out may skip it as I cannot see how to make it a required form to validate on submission.

Is there a way?

Import Function - Mal Function

Publication date: August 16, 2018

When we import a file to to create new rewords is Mal Functions:

Firstly – after importation – it shows all records have been imported, but when we go back to the records and update the view, the view does not show the records that we have updated.

Obviously we tried a few times.

Secondly – We tried to see if the records might be created – so we did a duplicate search, And there were 3 duplicates of each record.

1. Why does the records that were imported not display in the view after importation?

2. Why does create new allow duplicates to be created – does it not check the validation limitations on the system?

Please fix this problem

Bug in disabled dropdown field

Publication date: August 16, 2018

It appears that is a Drop Down field is disabled, even though a default is set and validation is mandatory that the entire contents of the drop down selection list is written to the database record field. Works fine if field is not disabled.

Javascript not working on my form

Publication date: August 16, 2018

In my form link test the javascript field rules and auto validation is not working.

check for email when "Allow End User Edits" enabled

Publication date: August 20, 2018

Please, add check that form has email field when user tries to turn on feature “Allow End User Edits” and leaving in setting “Select email field” only list of fields with email validation to choose.

Newsletter Email

Publication date: August 20, 2018

Presently only fields with email validation will workwith Newsletter Email. I use the email address as the unique identifier field to relate to Forms. In the second form it comes up as a “Select person” field which cannot be validated as email address even though it is an email address.

Can the Newsletter Email allow any field with emails to work with newsletter.


Publication date: August 20, 2018

Either have a Field Type for Zip Codes, or, a validation (like URL and Email).

Phone No. Validation

Publication date: August 20, 2018

Please add a “phone no.” validation (format = 999-999-9999).

Blank records

Publication date: February 19, 2019


Thank you of the QuintaDB account enabling to make a new database. I have started with a simple three forms that have relationship links.

I am entering data into the ‘apartment’ form. Each record is a brief description of the apartment in terms of size, bedroom number, aspect, bathrooms etc. What I am finding is as I enter them, there are blank records also created. I have tried ‘editing’ the blank records (ie adding in apartment data) but there are so many of them!

I assume this is some setting that I need to alter, so please advise how I can prevent new blank records.

Thank you.

Stephen Mackisack