Add the possibility to select AND or OR at “Where” conditions

All Topics → → Add the possibility to select AND or OR at “Where” conditions

Hi,

It would be great to be able to choose whether you want all the conditions to be true, or only one of them, when filtering the display of a form.

For example, I have a form with some data from my pupils. There’s a field for father’s ID, and another for mother’s ID, which match father or mother wordpress user ID, and I want each user to be able to see only his or her son’s info, so I added two conditions:

fatherID=[user_id]

motherID=[user_id]

BUT Formidable works with AND, so no info is ever showed, as user_id can’t be the same por each parent. With the possibility of selecting OR, both of them would see their son’s data displayed.

Thanks and regards

Juanfran

This is a duplicate suggestion. Please vote here:
http://formidablepro.com/help-desk/or-condition-in-advanced-search-form/

Thanks!

Oops, sorry.
I just voted, thanks.
In the meanwhile, or if it doesn't become a real functionality, is there any other way to do it?

For example, I'm trying this:

[if father_id equals=user_id]Display data[/if father_id]

or this:

[if father_id equals=[user_id]]Display data[/if father_id]

But both don't work. I asume there's no way to use the value of [user_id] inside a contitional?

Regards

I respond to my own message, because I've found something that did the trick for me, and would like to share it, I think it could be useful for other users:

The WordPress plugin User meta shortcodes adds a shortcode to show user info and "if" conditions, to test against a value (that can be a Formidable key).

After that I modified the shortcode code to add another "or" condition. So now I have Formidable "Where" filter for "and" conditions, and the shortcode for "or" conditions.
Regards

Thank you! I didn't realize you were talking about the inline logic/shortcodes. I've pointed others to custom shortcodes, but that's even better that you found an easier way.

Topic closed.