- otagowebAsked on May 29, 2017 at 12:00 AM
Can JotForm handle pricing based around dates?
We develop a lot of conference registration payment forms and pretty much every one has early bird, standard, and late costs for each registration type. This pricing structure can also carry-over into daily registrations where applicants have to pick the days they'll be attending if they're not registering for the full conference.
Currently we build bespoke solutions but we're investigating if there's a solution out there that will remove a lot of the heavy lifting we currently have to do.
- CharlieAnswered on May 29, 2017 at 01:28 AM
This should be possible if you recreate the products you are selling using the default form fields (ex. text boxes, radio buttons, etc...) and do an automated calculation based on the conditions you set. I'm not sure how your pricing scheme works. But here's an idea on how you can proceed.
1. First, I recreate the products using the radio button field (Single Choice).
2. In the properties window of that field, I'll assign value on each option. To learn more about this, you can check this guide: https://www.jotform.com/help/301-How-to-Assign-Calculation-Value
3. I will add a date field in my form, because we want to change the total value based on the date value.
4. In the date field, you can also set the default value.
5. Now we will add a Form Calculation widget, this is where the total pricing will be inserted. Note that we will not directly add the formula in the widget setting, we will do the calculation using Conditional logic.
6. Now, here's how you can access the Conditional Logic feature, in my case, I'll select "Update/Calculate Field".
7. Here's how my condition works.
If the date field value is BEFORE 12/30/2017, then apply the formula "production option selected value - (product option selected value * 0.20).
The formula means I will deduct 20% on the selected product.
8. Now we can pass the total calculated price to our payment integration, you can do that by following this guide: https://www.jotform.com/help/275-How-to-Pass-a-Calculation-to-a-Payment-Field
I hope gives you an idea on how to proceed.
- otagowebAnswered on May 29, 2017 at 02:35 AM
Thanks for that.
Shame to do anything like this requires a date field to be added to the form.
Would've been nice to have automatic date based "coupons" with no code.
- JotForm SupportcandyAnswered on May 29, 2017 at 03:20 AM
Actually, we have coupon options in the payment gateway and you are able to set a coupon limit by expiration date as you can see the screenshot below:
For further detailed information regarding "Coupons" please check the following guide: https://www.jotform.com/help/233-How-To-Add-Coupon-Code-in-the-Payment-Form
I hope this helps.
If you need further clarification, let us know.
- otagowebAnswered on May 29, 2017 at 03:41 AM
But from that it still requires a code.
What I'd like is to not need a code and automatically apply the coupon between 2 dates.
From what research I've done, it looks like to get what I want I'd have use a full eCommerce system. I know Magento could do it but I don't want something that complex and was hoping for something simpler.
- JotForm SupportRoseAnswered on May 29, 2017 at 04:12 AM
Thank you for sharing your additional comments.
However, The workaround suggested by my colleague Charlie is the only way to meet your requirement for now. I will open a feature request for your request, but we unfortunately cannot give you any estimates regarding when or if this might get implemented, but as soon as such a feature becomes available, we will make sure to let you know through this support thread.
If you have more questions, please feel free to contact us. We would be pleased to assist you for any issue you may have.
- JotForm SupportcandyAnswered on May 29, 2017 at 04:23 AM
If you have answered this thread, we couldn't receive.
Could you please send again?
- otagowebAnswered on May 29, 2017 at 04:24 AM
Thanks everyone for providing possible workarounds but unfortunately at this time it seems trying to build our forms in JotForm would take just as long as our current system.