TOPIC:

Check if value exists in database 4 weeks 1 day ago #278711

  • Luisserafim's Avatar Topic Author
  • Luisserafim
  • Offline
  • Expert Breezer
  • Expert Breezer
  • Posts: 274
  • Thanks: 1
Hi,

We need to check if a value exists in 9 fields in database but only if a select list as a value selected.

If a select list as value = 1 then it can not accept duplicate values in 9 fields.
If value = 2 then it may accept duplicate values.

Tx in adavance

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

Check if value exists in database 4 weeks 1 day ago #278712

  • Mirec's Avatar
  • Mirec
  • Offline
  • Ultimate Breezer
  • Ultimate Breezer
  • Posts: 3264
  • Karma: 2
  • Thanks: 160
Hi,

I have one question, do you want to search for the values of the elements in the database submitted under 1st application?

it means if users send values of nif number under 1st app, and then again start the app then we check in the database only nif values under 1st app submitted.


Regards,
Mirko

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

Check if value exists in database 4 weeks 1 day ago #278713

  • Luisserafim's Avatar Topic Author
  • Luisserafim
  • Offline
  • Expert Breezer
  • Expert Breezer
  • Posts: 274
  • Thanks: 1
hi,

Yes, that's it.

We have 2 apps

"1st app" can't have duplicate values, cause just one app is allowed, for each NIF.

"substitution app" here it can cause is a substitution to correct some wrong values an so, here it must accept same values for NIF (PT VAT).

Tx in advance

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

Check if value exists in database 4 weeks 1 day ago #278715

  • Mirec's Avatar
  • Mirec
  • Offline
  • Ultimate Breezer
  • Ultimate Breezer
  • Posts: 3264
  • Karma: 2
  • Thanks: 160
Hi,

oke, I create one example as you want

for example

if you are sent under 1st app value '1111011'
and then again start 1st app, and insert it same value then, you will get the message that the value is not empty, which means that it is in the database stored under nif number.

See image below

select 1st app



then insert nif which is in the database



you will be got a message that nif is already in the database.

Now if you select app2




and insert a value that is already in the database you didn't get the message that the nif is in the database, so the user can insert nif




I hope I explained it well, if this solution well for you I can provide it solution so you can embed it into your FORM.


Regards,
Mirko
Attachments:
The following user(s) said Thank You: Luisserafim

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

Check if value exists in database 4 weeks 1 day ago #278716

  • Luisserafim's Avatar Topic Author
  • Luisserafim
  • Offline
  • Expert Breezer
  • Expert Breezer
  • Posts: 274
  • Thanks: 1
Hi Mirko,

That's it :)

Thanx for your help U are the best :)

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

Check if value exists in database 4 weeks 1 day ago #278718

  • Mirec's Avatar
  • Mirec
  • Offline
  • Ultimate Breezer
  • Ultimate Breezer
  • Posts: 3264
  • Karma: 2
  • Thanks: 160
Hi,

I need check some things and then I will provide to you solution


If you have more questions, feel free to ask!


Regards,
Mirko
The following user(s) said Thank You: Luisserafim

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

Time to create page: 0.141 seconds

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

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!