TOPIC:

Database 2 fields validation 2 weeks 1 day ago #263278

  • Mirec's Avatar
  • Mirec
  • Offline
  • Ultimate Breezer
  • Ultimate Breezer
  • Posts: 957
  • Karma: 2
  • Thanks: 50
Hi,

1.
Compare "oldemail with email"

If 'oldemail ' different of email show error, otherwise send FORM.

could you please navigate in your form on element 'email' and in properties of field scroll down to the validation section and select type 'custom' and insert this code in the box below:
function ff_Elementname_validation(element, message)
{

var oldEmail=ff_getElementByName('oldemail ').value;
    if (element.value != oldEmail) {
        if (message=='') message = element.name+" faild in my test.\n"
        ff_validationFocus(element.name);
        return message;
    } // if
    return '';
} // ff_bfQuickMode3998212_validation

-function ff_Elementname_validation(element, message) -> Instead 'Elementname' insert name of your element 'email' (not title).

-var oldEmail=ff_getElementByName('oldemail ').value; -> Instead 'oldemail' insert name of element 'oldemail' (not title).


2.
Compare "oldvat with nif01"

If 'oldvat ' different of 'nif01' show error, otherwise send FORM.


could you please navigate in your form on element 'nif01' and in properties of field scroll down to the validation section and select type 'custom' and insert this code in the box below:
function ff_Elementname_validation(element, message)
{
var oldVat=ff_getElementByName('oldvat ').value;

    if (element.value != oldVat) {
        if (message=='') message = element.name+" faild in my test.\n"
        ff_validationFocus(element.name);
        return message;
    } // if
    return '';
} // ff_bfQuickMode3998212_validation

-function ff_Elementname_validation(element, message) -> Instead 'Elementname' insert name of your element 'email' (not title).

-var oldEmail=ff_getElementByName('oldvat').value; -> Instead 'oldemail' insert name of element 'oldemail' (not title).

If you get stuck, let me know and I will help you!
Regards,
Mirko
The following user(s) said Thank You: Luisserafim

Please Log in or Create an account to join the conversation.

Database 2 fields validation 2 weeks 1 day ago #263301

  • Mirec's Avatar
  • Mirec
  • Offline
  • Ultimate Breezer
  • Ultimate Breezer
  • Posts: 957
  • Karma: 2
  • Thanks: 50
Hi,

based on our conversation in email, I sent you another solution for check database, I created an example for you, Please download->unzip->and install it (BF->Configuration->Package Installer->select this xml file->Install Package).

File Attachment:

File Name: mypck_00160.zip
File Size:7 KB


you can test it, and if it is ok for you, I can implement it on your Form.

In example, when you insert a value in an element VAT, the app will check does it exists in the database, if exist an error will be displayed, otherwise, the form will be sent.

Let me know! :)
Regards,
Mirko
Attachments:

Please Log in or Create an account to join the conversation.

Database 2 fields validation 2 weeks 8 hours ago #263356

  • Mirec's Avatar
  • Mirec
  • Offline
  • Ultimate Breezer
  • Ultimate Breezer
  • Posts: 957
  • Karma: 2
  • Thanks: 50
Hi,

solved over email, the topic is closed.

Regards,
Mirko

Please Log in or Create an account to join the conversation.

Time to create page: 0.047 seconds

BreezingForms Pro 1.4.7 for WordPress Released!

Available in the membership section.

September Discount!

Massive discounts on all subscriptions!

Get Your Subscription Here

Quick Links

Downloads

BreezingForms

ContentBuilder

BreezingCommerce

Templates

Documentation

BreezingForms

ContentBuilder

BreezingCommerce

Apprendre BreezingForms (French Community)

Apprendre et maîtriser BreezingForms par des tutoriels et exemples, le tout en français

breezingforms.eddy-vh.com

Questions et réponses sur les forums de l'AFUJ

AFUJ

Special Offer

Summer Sale! All subscriptions at a special price!

Includes prio support, all of our current and future Joomla!® extensions and Joomla!® templates for the duration of your membership.

Get it from here

3rd Party Discount - 25% Off

We help you to keep your costs under control. If you are a new member and purchased a form building tool from a different form vendor, then you'll get a 25% discount on our subscription plans.

How to receive the discount:

Send us a quick email to sales@crosstec.org with a proof of purchase (for example a paypal receipt), await payment instructions and enjoy your membership!