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.