• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Validate field against a field in the database

Validate field against a field in the database 10 years 7 months ago #28945

Is it possible to validate the accuracy of a field based on data in my database? For example, I want users to fill out an activation form where they will provide an activation code that was given to them on the product they purchased.

The database has four fields:
1) product ID (also printed on the product)
2) unique activation code (also included in the product packaging)
3) active (yes or no)
4) table ID (unique)

I want users to enter the product ID in one field and then enter the activation code in another. Before submitting the form, the RSForm should look up to see if the correct activation code was entered before going any further. If not, it should show an error.

Is this possible?
The administrator has disabled public write access.

Validate field against a field in the database 10 years 7 months ago #28955

  • cosmin.cristea
  • cosmin.cristea's Avatar
  • OFFLINE
  • Platinum Boarder
  • Posts: 756
  • Thank you received: 144
You can use the example provided here and build on it:

http://www.rsjoomla.com/forum/37-rsform-pro/24538-custom-validation-rules.html

Basically, it's almost the same thing some tweekings have to be made so you crosscheck the product with the database values
My help is not official customer support. To receive your support, submit a ticket by clicking here
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!