CiviCRM Community Forums (archive)

My partner and I organize a small non-profit (no paid staff) out of our home in our "spare" time.  I have created the Drupal (7) site and all content over the past year or so, then added Civi (4.2) and installed it myself.  I have just begun using it really and have found it a very fun learning experience.

For my first big project to get members of my community putting themselves in our civi, and because of a need in our org, I am setting up a musician registry form and parallel form for venues who want to host live music during the upcoming ArtsFest in our community.

The musician registry:  laluchaspace.com/?q=musician-registry

The venue page for booking: laluchaspace.com/?q=BookArtsFest

The venue page uses Views to show a grid of fields that meet the following filter criteria:

Filter criteria
CiviCRM Contacts: Contact Sub Type (= - Band)
AND
CiviCRM Custom: Music @ Conway ArtsFest: Interested in playing at ArtsFest? (True)
AND
CiviCRM Website: Website Type (in Website or Blog, ...)
AND
CiviCRM Contacts: Is Deleted (False)

I am having two problems.  1.) sometimes bands don't appear in the View after they add themselves - I think it is because of the Website filter, but I need that to prevent artists who have given us multiple websites from showing up multiple times... (or at least that was my solution to that problem). Is there another way to prevent a band from appearing multiple times w/ multiple value fields? Is there a way to only have one website type but still allow bands with no website to be seen?

Second,  on the form used by venues the drop down box that says "Select Band" is supposed to allow them to select from a Smart Group I created on essentially the same criteria as above (Band that is interested in artsfest).  I go look at the Smart Group and there are bands there that do not show up on my form. How or when do these update? When it wasn't working I added a band manually to the smart group and they appeared immediately in the drop down.  Is there a step I am missing RE my smart group?

Thank you all for the fabulous work that you do which allows very small orgs like ours to use awesome software without any budget for it. Also for all the learning resources that have made me able to learn everything up to this point without even talking to anyone else who has used CiviCRM before (until this post).

Best,
Shawn

Hi Shaun

> Is there a way to only have one website type but still allow bands with no website to be seen?

I am guessing there is a gap in the Views handlers and therefore you aren't getting the option to specify the 'type' of website that you want when putting in the field

You could try setting the Query Settings to Distinct (under OTHER) in the View.

RE the Form - you don't mention if this is a webform-civicrm form or not - if so which version?

It means someone needs to write a Handler for this field - would be great if you have the ability to take a look at what is required. We have been doing a few of these so welcome to ping us if you see us on IRC in case we can provide any pointers (petednz, eileen or torrance123).

May be better to ask the webform question on the issues queue for webform_civicrm module ;-)