if / then field?

Hi there

I am trying to create on if/then kind of field to show on profiles, the value of which depends on values in two other fields, something like this:

- -If value of field1 is non-blank, then show value of field1; otherwise, show value of field2.

I suspect I need to use CB Query field, but I do not know enough MySQL to figure this out! To complicate matters, field1 and field2 are in different tables (_comprofiler vs _users).

Any help would be greatly appreciated!

Thanks so much.

You can condition fields to show/hide using CB Conditionals. A field can condition it self, but I don't recommend it. See the below videos regarding CB Conditional usage.

www.youtube.com/playlist?list=PLp0puRITgC7PxD6MvmDwNNIi2HNcYxs7u

At this time I strictly recommend using Conditional Self instead of Conditional Others as self conditions are more reliable (other conditions likely to be removed at some point).