Log In

Log In

Not registered yet?

Reset password Activation link
Tag "validation"

Form Validation inquiry

Publication date: August 13, 2018

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.

Disabled single line text fields no longer write default data.

Publication date: August 16, 2018

Why is it that a routine I know works is now driving me nuts?

1. Create single line text field with default data.
2. Set the default text for the field.
3. Disable the field so that the default is not shown.
4. Set validation for the field to ensure is not empty on write.

I can see what you have done, you have set single line text fields that are disabled to not write data but continue to allow disabled image fields to write.

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.

Can't be blank validation

Publication date: August 17, 2018

It would be great to make simple tick-box on the Fields page for enabling/disabling ’Can’t be blank validation’.
Instead of opening Edit Field page, choosing ‘Validations’ option in ‘Settings’ dropdown.
Feature will be always visible and available with less amount of clicks.

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).