Event lunch is $35 early bird, $40 after August 15.
Field for adding a vendor table: 1 table $175; 2 tables $350.
Each table includes one lunch, so if it's individual registration with one table, the price is $175 (deducting the lunch fee); if two tables, the total is $350.
If it's a group registration and there are two in the group, and they get one table, the total is $210 (deducting the lunch fee for one member); if two tables, the total is $350 (deducting the lunch fee for two members).
If it's a group registration with more than two people, then it's the # of tables + the lunch fee for the third and subsequent registrants... unless the registrant wants to add lunches for the additional people.
How do I make all these conditions work?
I had a custom field with a drop-down: 1 table $140; 2 tables $315 (subtracting out the early-bird lunch fee for each option). But that breaks down if they get two tables - it would have to be $105 & $280, respectively. But after August 15, this would be incorrect.
I then tried to create a conditional field that would trigger only if the drop-down for tables is = 2, and there are exactly two members of a group registration. If the condition is met, it deducts the second $35. For some reason, I can't see that field in the event field list for the event to include it, and it doesn't work when I test it.
What would be the approach to make all this work? It's very common among my customers to have all these options, and they usually just set up two events: one for attendees only and a separate event for vendors. But even that sometimes runs into limitations (in addition to confusing some site visitors).
Note: I only unpublished the two fields in the attachments while I'm working on this. They were both published while I was working on this... Okay, I give up. The attachments showing the setup of the two custom fields won't work. I hope you can answer without the screenshots.
Hey Ernie! There is almost always more than one way to configure DT Register to accomplish anything... as it's customizable from about every angle... so it comes down to what works best for you. Here's my suggestion...
Your vendor table selection field will be required and include a default option of NO vendor tables. You'll need this for other conditions. Then put the price for the "One Table" option as $175 (lunch included) then "Two Tables" priced WITHOUT a lunch.
You'll have three different lunch selection fields, one for individual and two for groups.
For individual registrations, create a selection field like "Add a lunch? Yes / No" (No_Table_Lunch) that adds the lunch fee for "Yes". Make this field conditional on the vendor table field so it shows ONLY if the user selects NO vendor tables. So result is if a table is selected, no lunch will be needed. If no table, they'll be given the option to add a lunch still.
To address the August 15 fee change, your only solution will be to manually update the fee within the field after the appropriate time. Save the field. Re-save the event.
Now, for group registrations...
Create the second separate lunch selection field (One_Table_Lunch) for "How many lunches do you need?" with a dropdown of options from 1 - 15 (or whatever seems appropriate). This will be conditional on the table field to show when "One Table" is selected. Assign fees to the field values with 0 for 1 lunch (as it's included in the table price), then 35 for 2 lunches, 70 for 3 lunches, etc.
Then create the third lunch field (Two_Table_Lunch) that looks the same as the previous field. It will be conditional on the table field value "Two Tables". The fees will be different because the option of 1 or 2 lunches will both be $0 added... but 3 lunches would be $35, 4 lunches $70, etc.
These other lunch fields will also need a manually adjustment to fee values after the early bird time is over.
Hopefully this makes sense, as it will definitely accomplish what you have described.
Nathan is no longer affiliated with DTH since the recent acquisition. You can connect with him and get any type of Joomla website help at
www.JoomlaEmployee.com
.
Conditional Field to Adjust Fee
9 years 5 months ago #24647
I tried to work through it, but maybe I didn't explain it right. Attendance is $35 and is part of the event registration fee. Exhibitors don't pay this, unless they're getting one table and two lunches - then they'd pay for one lunch, etc.
I can have an additional lunches drop-down for exhibitors because often a vendor brings a bunch of people and wants to be able to get lunches for them.
But for the basic registrant, it's simply $35 each, so in a group registration, each person in the group is charged $35.
For now, I think I'll just have two events - one for guests and one for exhibitors.