I have contact information stored in CiviCRM, which underneath the hood is basically Groups with out-of-the-box CiviCRM code added. Have successfully pulled data from various groups to display a list of Board members and their bios, but can't figure out how to structure this data.
What I want, in FileMaker Pro style code:
"<h4>" & [Full Name] & if([Title]≠"",", ") & [Title] & "</h4><br> <br>" & [Bio]"
There's a corollary question in that right now, the Title data is stored in two places: Board members are assigned to a group, but officer titles will be in either a custom field or a tag. Pulling a custom field is easy; I don't know how to display "if the contact is in one of these three groups or tags, display that title." Obviously, could do dual-entry into a custom field, but there lies madness.
Recall from my D7 days that such things are possible, but I'm not sure if this calculation lives in the View or in a custom field in my database. Also not sure how to instruct the View to interpret the HTML instead of displaying it.