• 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: Conditional Unique field

Conditional Unique field 3 years 3 months ago #41803

Hi,
I would like to have a check in the database if there is a field called "bednumber" is already in use. However, if I would use unique field as a validation rule I will get an error of course because bed numbers have been used in the past. What I would like to have is a check if ExitDate field completed in the submissionslist.

For example:
Client B comes and gets bed number 2
The validation rule says it's already in use. Because some one is on that bed at the moment.
Then I change Client A. Client gets an exit date.
Client B can have is bednumber 2 because the bed number is available again.

Would be great if this can be "live" and not on pressing the submit button. But it's already a nice to have if this would work.

Regards, Art
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!