CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Multiple price sets on event registration page
Pages: [1]

Author Topic: Multiple price sets on event registration page  (Read 1289 times)

Brylie Christopher Oxley

  • I post occasionally
  • **
  • Posts: 52
  • Karma: 1
  • CiviCRM version: 4.x
  • CMS version: Drupal 7.x
  • MySQL version: 5.x
  • PHP version: 5.x
Multiple price sets on event registration page
February 09, 2014, 10:27:45 am
We are creating an event registration for a multiple-day event. We have created price sets for event attendees to select from various accommodations such as private rooms, camping, and dorm room - on a daily or full event basis.

How can we display multiple price sets on a registration form, and allow for auto-calculation of the event registration feel?
Brylie Oxley
http://brylie.gnumedia.org

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: Multiple price sets on event registration page
February 09, 2014, 10:57:21 am
I see you asked the same question in the Webform-CiviCRM forum.
One thing to know is that Civi's price-sets are fundamentally different from webform's price-fields. They both more-or-less do the same thing but with different approaches and I haven't been able to bridge the gap in the integration code. So you can set up your event using one or the other but not both.
Civi's price-sets have the advantage the a single price-set can contain more than one price field. Which is what you want in this case. But what's lacking is a global multiplier that would take each field's value and multiply it by a number of days.
That's something you can do with a webform, and so perhaps that approach would work better for you. Try out the "grid" widget with the event price field and see how it works for you.
Try asking your question on the new CiviCRM help site.

Brylie Christopher Oxley

  • I post occasionally
  • **
  • Posts: 52
  • Karma: 1
  • CiviCRM version: 4.x
  • CMS version: Drupal 7.x
  • MySQL version: 5.x
  • PHP version: 5.x
Re: Multiple price sets on event registration page
February 09, 2014, 12:28:13 pm
A difficulty is that the price set is rather involved. I.e. we have three types of accommodations (Dorm, Semi-private, Camping), two types of registration (daily and weekly), and three classes of individuals (Adult, Young Friend, Teen).

Initially, we set up distinct price sets to accommodate for these scenarios, but it does not seem like we will be able to use these price sets in tandem on a single form.
Brylie Oxley
http://brylie.gnumedia.org

Brylie Christopher Oxley

  • I post occasionally
  • **
  • Posts: 52
  • Karma: 1
  • CiviCRM version: 4.x
  • CMS version: Drupal 7.x
  • MySQL version: 5.x
  • PHP version: 5.x
Re: Multiple price sets on event registration page
February 09, 2014, 12:38:52 pm
See below for an idea of the registration structure. Day rates are multiplied by the number of days attending. Full event rates are set prices.

Adult
  Daily
    Semi-private
    Dorm
    Camping
  Full event
    Semi-private
    Dorm
    Camping

Young Friend
  Daily
    Semi-private
    Dorm
    Camping
  Full event
    Semi-private
    Dorm
    Camping

Youth
  Daily
    Semi-private
    Dorm
    Camping
  Full event
    Semi-private
    Dorm
    Camping
« Last Edit: February 09, 2014, 12:56:58 pm by Brylie Oxley »
Brylie Oxley
http://brylie.gnumedia.org

Brylie Christopher Oxley

  • I post occasionally
  • **
  • Posts: 52
  • Karma: 1
  • CiviCRM version: 4.x
  • CMS version: Drupal 7.x
  • MySQL version: 5.x
  • PHP version: 5.x
Re: Multiple price sets on event registration page
February 09, 2014, 03:33:17 pm
Is it possible to use Webform conditional to conditionally select which event registration to add to the user? I.e. if I were to add three event options and show only one based on webform conditions, can I use just that single event for payment, registration, etc? I am thinking that I might be able to add the same event three times on the form, each with a different price grid based on the age of the registrant, and show only the appropriate price grid as a conditional response.
Brylie Oxley
http://brylie.gnumedia.org

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: Multiple price sets on event registration page
February 09, 2014, 04:19:21 pm
Yes you definitely could do that. In my opinion it would be more work and less maintainable than having 1 event per registrant and a couple lines of custom jQuery code to hide unneeded grid rows. But if you're looking to do this with no code whatsoever, then yes that would work.
Try asking your question on the new CiviCRM help site.

Brylie Christopher Oxley

  • I post occasionally
  • **
  • Posts: 52
  • Karma: 1
  • CiviCRM version: 4.x
  • CMS version: Drupal 7.x
  • MySQL version: 5.x
  • PHP version: 5.x
Re: Multiple price sets on event registration page
February 09, 2014, 04:26:02 pm
OK, so I would create one master table with all the values, and use jQuery to hide table rows based on the age of the registrant. The only class on grid rows seems related to striping (odd/even),  so I would have to remove the rows and re-stripe the remaining ones.

Is this basically what you were describing?
Brylie Oxley
http://brylie.gnumedia.org

Brylie Christopher Oxley

  • I post occasionally
  • **
  • Posts: 52
  • Karma: 1
  • CiviCRM version: 4.x
  • CMS version: Drupal 7.x
  • MySQL version: 5.x
  • PHP version: 5.x
Re: Multiple price sets on event registration page
February 09, 2014, 04:56:29 pm
The webform gives the following error when I try to set up day rates for the various participant levels (screenshot attached):


Code: [Select]
The following keys have been used multiple times. Each key must be unique to display properly.
Additionally, the full event registration (basically 5 days) is discounted from the daily rate (if multiplied by five days). A coefficient of 4.7 might work, but is not technically correct according to the price schedule.
Brylie Oxley
http://brylie.gnumedia.org

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: Multiple price sets on event registration page
February 09, 2014, 06:25:33 pm
Quote
so I would have to remove the rows and re-stripe the remaining ones.
I wouldn't bother messing with the striping, I think that's making things more complicated than they need to be.

Quote
The webform gives the following error when I try to set up day rates for the various participant levels
I already answered that here: https://drupal.org/comment/8465371#comment-8465371

Quote
A coefficient of 4.7 might work, but is not technically correct according to the price schedule.
That sounds iike the correct solution to me what's incorrect about it?
Try asking your question on the new CiviCRM help site.

Brylie Christopher Oxley

  • I post occasionally
  • **
  • Posts: 52
  • Karma: 1
  • CiviCRM version: 4.x
  • CMS version: Drupal 7.x
  • MySQL version: 5.x
  • PHP version: 5.x
Re: Multiple price sets on event registration page
February 09, 2014, 07:55:48 pm
Some of the full week options are 4.7 times the day fee, while others are closer to 4,8.

The unique key trick seems interesting, and the fee structure may be adjustable. However, I still think that supporting rich fee structures and form logic through the UI could be useful for many organizations, and might be part of a cross-cutting forms module (i.e. CiviForms).
Brylie Oxley
http://brylie.gnumedia.org

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: Multiple price sets on event registration page
February 09, 2014, 08:04:55 pm
Quote
Some of the full week options are 4.7 times the day fee, while others are closer to 4,8.
Despite their testimonies, Quakers have a bad habit of making things way too complicated.

Quote
supporting rich fee structures and form logic through the UI could be useful for many organizations, and might be part of a cross-cutting forms module (i.e. CiviForms).
No argument from me that CiviCRM forms could be better. The question is who's going to do the work of improving them. At a rough guess I'd say we get about 100 times more feature requests than pull requests. Gotta improve that ratio if we want more features to move forward.
Try asking your question on the new CiviCRM help site.

Brylie Christopher Oxley

  • I post occasionally
  • **
  • Posts: 52
  • Karma: 1
  • CiviCRM version: 4.x
  • CMS version: Drupal 7.x
  • MySQL version: 5.x
  • PHP version: 5.x
Re: Multiple price sets on event registration page
February 09, 2014, 08:12:52 pm
Quote from: Coleman Watts on February 09, 2014, 08:04:55 pm
Despite their testimonies, Quakers have a bad habit of making things way too complicated.
I know, right?? I think we may be aiming for equality on this registration process.

While, being primarily users, we do not have the expertise to develop this form extension, we do have some funding available for a make-it-happen campaign.
Brylie Oxley
http://brylie.gnumedia.org

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Multiple price sets on event registration page

This forum was archived on 2017-11-26.