form validation over multiple fields

I really would appreciate if there is a solution to my idea

Situation: I have a register and profilings edit form with 2 integer fields, that can take values between 0 and 100.

What I want to do:
It should not be possible to register or update:
- it not at least one of those fields have a value higher then 0

Can You please give me a hint, how this can be realised?

I tried an additional field, that sums up the values of the two fields, and is checked to be higher then 0 - but this didn't work before saving the data to the database.

Thank you very much

best regards Thomas

That's actually just now doable. You'll need to update to the latest CB build releases today. Next you'll need CB Code Field latest build also released today. Once done edit your integer fields and under Integrations > CB Code Field enable Code Validation. Now you should be able to add custom PHP based validation to validate your fields, but you'll have to use the new Additional Fields feature so that Field A is sent the value of Field B allowing you to do an either/or check. Example as follows.

Code Validation: Enable
Code (PHP): Ajax Validation: Enable
Additional Fields: cb_field2

The above for example would be added to cb_field1, which would also be sent the value of cb_field2 allowing you to check the value of cb_field2 in addition to cb_field1. Be sure to replace cb_field1 and cb_field2 with the actual names of your fields. When adding this to cb_field2 you just need to change "Additional Fields" to cb_field1.

Thank's. I installed all latest releases (espacially Code Field and Community Builder) and tried as you described, but the result when validating the field behaves somehow strange:

- values 0 return "ok"
- values >0 return false....

I can change between

return ( ( (int) '[cb_field1]' < 0 ) || ( (int) '[cb_field2]' < 0 ) );

and

return ( ( (int) '[cb_field1]' > 0 ) || ( (int) '[cb_field2]' > 0 ) );

without any effect....

do you have an idea what's going wrong?

You should be using the below code.


But again you need to replace cb_field1 and cb_field2 with the actual names of your fields. Do not leave them as cb_field1 and cb_field2 as those fields do not exist in your install. The field should validate if either of the supplied fields values are greater than 0. I suppose you could also do the sum approach again as well with the below.

thank's. That's clear - I did replace the field-names with my custom field-names (i.e. cb_haus2 and cb_garten2); and something is evaluated, but not the right way ;-(

I also try your other code-line, but with the same result.

Could it be, that there is a code-line-mistake in the plugin, where the values are evaluated?

Sorry, for bothering again.

It would be really helpful if we could find the solution

It depends entirely on where this is being added to. If it's being added to cb_field1 then replace [cb_field1] with [value]. If it's added to cb_field2 then replace [cb_field2] with [value]. Try the below for example

cb_field1
cb_field2