Create a course registration

  • Profile Image
    zoomadmin
    Asked on December 22, 2020 at 03:38 AM

    I have done a-lot of work on this form - but with my lack of experience especially in payment order forms - i think i might have taken the form in the wrong direction! Can I have professional comment and hopefully - re-direction as to how i should have structured it. I will Define the challenge: (i'm ok with linking the stripe gateway plugin)

    1)We have 28 different courses on offer for Spring 2021.
    (One is free the rest are varying amounts) €.

    2) There are 17 Different Tutors delivering these 28 Courses:

    3) Here is a break down of the Courses
    21 of the 28 courses are - 'On-Site' 'In-Person' Courses
    7 of the 28 courses are - 'ONLINE-VIRTUAL' Courses
    6 of the On-Site Courses are on Tuesdays
    6 of the On-Site Courses are on Wednesdays
    4 of the On-Site Courses are on Thursdays
    5 of the On-Site Courses are on Fridays

    4) Users need to be able to review each course details and tick one or more courses that they wish to book in that one session/order. If they book more than one they get 10% discount off all courses booked.

    5) Ideally we had hoped that that users could review the offering in a variety of ways!
    a) That they could see a list of all courses 1-28 and tick which ones they wished to book.
    b) That they review all ON-SITE Courses and tick which ones they wished to book.
    c) That they review all ONLINE Courses and tick which ones they wished to book.
    d) That they review all TUESDAY Courses and tick which ones they wished to book.
    e) That they review all WEDNESDAY Courses and tick which ones they wished to book.
    f) That they review all THURSDAY Courses and tick which ones they wished to book.
    g) That they review all FRIDAY Courses and tick which ones they wished to book.

    Above is the minimum we need the registration form to provide for please:
    But the vision was if possible for users to also be able to browse a mini bio for each of the 17 Different tutors - and maybe even a head and shoulders pic.

    I sense I have constructed this the wrong way - can some one direct me in the route I should have taken. I give full and total permission to any of your team to engage directly with this form.

  • Profile Image
    Richie_P
    Answered on December 22, 2020 at 04:32 AM

    I have checked your form and it seems you have used calculation values to get the total of products.

    The only way to show images is by using the image field .

    If you want your form users to review the products they have selected, you may add the review before submit widget.

    1608628392_5fe1b8a89cfff_3.png

    https://www.jotform.com/widgets/review-before-submit

    You may also use conditions to hide/show fields based on the selected answer.

    https://www.jotform.com/help/57-smart-forms-conditional-logic-for-online-forms

    However, it seems you have grouped each courses to a single multiple choice field.

    Please note that it is not possible to use conditions for the options in the multiple choice field.

    I would suggest separating different dates on different multiple choice fields so that you can hide/show the group and using condition.

    Sample screenshot:

    1608629357_5fe1bc6dac7ce_3.png

    Please check it out and let us know if this fits your requirements.

  • Profile Image
    zoomadmin
    Answered on December 22, 2020 at 04:43 AM

    Hi Ritchie,

    Thank you:

    Can I ask you two things please:
    If you were staring from scratch and knowing the OPTIONS and CHOICES I outlined would you build this form using calculation values to get total of products? Is that the very best way to do this form?
    Does using 'calculation values to get total of products route' offer any distinct benefits that will make what we need POSSIBLE? - that could not be achieved if for example we went the route of separate products under separate categories in the Stripe Payment Product Widget?

    I'm not experienced enough which of these options will serve my declared needs best?

    If i have started the wrong way - or a way that will not serve me best - I'm prepare to start again and build the correct way.

    Given the parameters that I outlined which method or approach would you have used please?

    Products within Stripe Widget?

    or

    Calculation values to get total of products?

    Please


  • Profile Image
    zoomadmin
    Answered on December 22, 2020 at 05:08 AM

    OR should I be using the STRIPE PAYMENT PRODUCT option?
    or maybe it will not achieve all that I have defined?

    Ian



    1608631661_5fe1c56ddde1d_Screenshot 2020

  • Profile Image
    Sam_G
    Answered on December 22, 2020 at 05:25 AM

    Hi Zoomadmin,

    If you were starting from scratch and knowing the OPTIONS and CHOICES I outlined would you build this form using calculation values to get the total of products? Is that the very best way to do this form?

    Yes, this would be the best way. Related guide: https://www.jotform.com/help/259-how-to-perform-form-calculation-using-a-widget

    Does using 'calculation values to get the total of products route' offer any distinct benefits that will make what we need POSSIBLE? - that could not be achieved if, for example, we went the route of separate products under separate categories in the Stripe Payment Product Widget?

    I'm sorry, Unfortunately, it is not possible to separate pages for the products of different categories. Please note that all products which you add to your payment tool will be displayed together. 

    I would suggest you please use regular form fields like single choice / multiple-choice questions to display your desired products. You can then add the "Form Calculation" widget to calculate the product amount and then pass the calculated amount to your form's payment tool to process the payment. 

    You may like to take a look at the following guide on how to pass a calculation to your payment tool:  https://www.jotform.com/help/275-How-to-Pass-a-Calculation-to-a-Payment-Field 

    There is no need for you to use the products list since it would have the same function. You can add images and coupons and that is the advantage of the product list.

    I hope this helps.

    Let us know if you need further assistance.

  • Profile Image
    zoomadmin
    Answered on December 22, 2020 at 06:47 AM

    PROBLEM

    If we create SINGLE entry for all 28 courses and some one selects a course and then changes there mind they cannot deselect? What is the work around where a user can change mind after selecting a SINGLE option?

    Please1608637624_5fe1dcb8c6449_Screenshot 2020

  • Profile Image
    Rehan_F
    Answered on December 22, 2020 at 06:57 AM

    Greetings,

    Single Choice Field can not be deselected. This is how it is built. In this case, I would suggest you use the Multiple Choice field. It will allow users to check and uncheck in case if they change their mind.

    I see that you are already using some multiple choice fields in your form.

    Should you need further assistance, please let us know.

    Thanks

  • Profile Image
    zoomadmin
    Answered on December 22, 2020 at 09:26 AM

    Hi

    Given that I need to use conditional logic to show or hide certain courses (28 Courses in total)

    I have used separate radials. - I think this is what an earlier advice was??

    Can I still pass all calculations of selected courses to a Subtotal - which in turn will pass to a Toal button which will reflect 10% discount BUT HOW do we achieve to give 10% on 2 or more courses ordered? - Not 10% if they just book ONE course?

    hopefully this is1608647190_5fe2021631f7f_Screenshot 2020

    possible?


    Ian

  • Profile Image
    zoomadmin
    Answered on December 22, 2020 at 10:08 AM

    I have managed to pass the value of each course through - but my final hurdle is to be able to give a 10% discount when two or more courses are booked in one order? How might I achieve that please?

    The courses vary from €25 to €35 to €40 to €45, - €55 - €60 to €65 to €75 to €135


  • Profile Image
    Richie_P
    Answered on December 22, 2020 at 10:20 AM

    You can still assign values to your selections.

    Guide:https://www.jotform.com/help/301-how-to-assign-calculation-value

    You may still also use condition to get the 10% value discount when 2 or more courses are selected.

    I have checked your form and it seems you're already using conditions to add the discount percentage.

    You can use the form calculation widget to get the value of your courses.

    Example: if user fills the discount online course, you can set that if the value is greater than 35 then you calculate the discount.

    1608650310_5fe20e46bfe74_3.png

    Please give it a try and let us know how it goes.

  • Profile Image
    zoomadmin
    Answered on December 22, 2020 at 10:24 AM

    Yes but the discount i have started to set up has not been configured to work on CONDITION of two orders - I can take 10% off the total OK - but how do I ONLY give 10% if 2 or more courses are ordered. One of our courses is €130 and we only want discount applied if TWO courses are ordered?



  • Profile Image
    Zahra_S
    Answered on December 22, 2020 at 10:42 AM

    Hi there!

    Please allow us some time to test a workaround for you.

    We will get back to you soon.

    Thanks.


  • Profile Image
    zoomadmin
    Answered on December 22, 2020 at 10:43 AM

    I really hope we can find a solution please! as I have all the other details checked out and will work as expected from testing - EXCEPT the discount of 10% for two or more courses booked! one of the courses is €130 so the example of greater than €35 will not work - hopefully there is a work around?

  • Profile Image
    Zahra_S
    Answered on December 22, 2020 at 11:20 AM

    Hi there!

    I have an idea to implement this.

    We will do this in three steps.

    Step 1: As all of the courses are option fields, we can apply a calculation value of '1' to all of the courses.

    Step 2: Add Calculation Widget and add the field which has a list of courses. If a user selects 2 courses, we will get the value equals to 2 and if he selects more than 2 courses, we will get the equivalent number because we have set value 1 for each option. Keep the field hidden.

    Step 3: Now, you can add the condition to calculate a 10% discount off the total price if the calculation field has a value equal to 2 or greater than two.

    Related Guides:

    https://www.jotform.com/help/301-how-to-assign-calculation-value

    https://www.jotform.com/help/259-how-to-perform-form-calculation-using-a-widget

    https://www.jotform.com/help/57-smart-forms-conditional-logic-for-online-forms

    I hope this helps.

    Let us know if you need further assistance.




  • Profile Image
    zoomadmin
    Answered on December 22, 2020 at 01:51 PM

    I need further help with step 2 please?


  • Profile Image
    zoomadmin
    Answered on December 22, 2020 at 02:05 PM

    If we replace the money in the calculation value with 1 - where does the cost of the course go ?

  • Profile Image
    zoomadmin
    Answered on December 22, 2020 at 02:11 PM

    "A field with list of courses" help me to understand what you mean?

    What sort of field?

    How doe this field relate to what we are trying to achieve please?

  • Profile Image
    zoomadmin
    Answered on December 22, 2020 at 02:18 PM

    The cost of each course is NOT the same? - might that be what you were thinking here?

    Some courses cost = €25

    Some courses cost = €35

    Some courses cost = €40

    Some courses cost = €45

    Some courses cost = €50

    Some courses cost = €55

    Some courses cost = €60

    Some courses cost = €65

    Some courses cost = €70

    Some courses cost = €75

    Some courses cost = €85

    Some courses cost = €130

  • Profile Image
    zoomadmin
    Answered on December 22, 2020 at 02:20 PM

    can you create an example of what you are suggesting ?
    assuming you cannot edit my form - but you have full permission to change my form


  • Profile Image
    Kevin_G
    Answered on December 22, 2020 at 03:45 PM

    You can use either a checkbox or radio button to list your courses, this will depend on what you want to allow the user to select, if you want to allow them to select multiple options or only one.

    If your courses have different prices, then you can set the calculation value as the price, this guide will help you to do so: https://www.jotform.com/help/301-how-to-assign-calculation-value

    This way you can simply sum up the checkbox field using the Form Calculation widget and get your total.

    Now, this will change the way how you have set up the discount; however, this is still doable following this workaround:

    1. Add a form Calculation widget where you will include the checkbox field within the count() function, example:

    1608669860_5fe25aa4190ce_

    This guide will help you with the math functions on the calculation widget.

    Then you can set up the conditions as explained before to calculate the discount.

    Kindly give it a try and let us know if you have any questions.

    Thanks.

  • Profile Image
    zoomadmin
    Answered on December 22, 2020 at 04:23 PM

    Thank you Kevin_G i'm a novice -what GUIDE? one screen grab? sorry I'm really really struggling - IF YOU CANNOT ENGAGE DIRECTLY IN MY FORM - can you set up a real example so I can follow A-z what you mean - i see one screen grab not a guide sorry - I would be lost without you guys for sure ! but have not a clue as to how your one screen is going to help me sorry? Maybe some one else can flesh out what you are meaning please?


  • Profile Image
    zoomadmin
    Answered on December 22, 2020 at 04:53 PM

    I now can calculate the No of courses selected -

    BUT HOW do i come up with a value of those combined courses? (based on the reality that each course has a different cost value)???

  • Profile Image
    zoomadmin
    Answered on December 22, 2020 at 04:55 PM

    Meaning how can we BOTH:

    a) manage the number of courses selected?
    AND

    b) Accumulate the total cost of the particular user selection of courses?


    Please?

  • Profile Image
    zoomadmin
    Answered on December 22, 2020 at 04:56 PM

    I can achieve ONE or THE OTHER

    But as yet i cannot achieve BOTH and we need BOTH please?


  • Profile Image
    Kenneth_C
    Answered on December 22, 2020 at 07:08 PM

    Hi there,

    On your single choice properties, you may Assign Calculation Values that will serve as the Price for each product:

    1608681977_5fe289f9ed690_t1.png

    The values selected on these choices will now be passed to your Form Calculations below.

    Here is the related guide: https://www.jotform.com/help/301-how-to-assign-calculation-value

    I hope that helps.

    Best.

  • Profile Image
    zoomadmin
    Answered on December 22, 2020 at 07:27 PM

    Yea Kenneth, that is what is has earlier today - but then another advisor suggested I replace it with the numeral 1.
    (to discover how many courses were booked-but then I lost the ability to calculate the accumulative cost)

    Which brings me around in a circle to the original problem if I do as you say and put back in the prices in the calculation values - have you a work around for me to discover if they have ordered MORE than one course. Please

    As registrants who book more than one course - get a 10% discount at check out.


    Any ideas on that one Please?


  • Profile Image
    Zahra_S
    Answered on December 22, 2020 at 10:48 PM

    I apologize for not properly understanding the issue before.

    I cloned your form and did multiple tests to implement your requirements.

    Please note that it is not possible to automatically detect the number of courses selected by the user and then apply a discount because we are already using calculated values for the price of the courses. We can do one thing only.

    However, I have created a workaround for you that takes the total number of selected courses from the user and then applies the discount if the number is 2 or greater than 2. We will use 'CALCULATE FIELD CONDITION' for this purpose. To make sure that the user enters the number of courses, we will make that field required and restrict the user from making payment until he has entered the number of courses.

    I noticed that you have already applied a 10% discount on the total price. We will have to delete those fields because we want to calculate fields based on the conditions.

    Check my cloned version: https://form.jotform.com/203568419788977

    Please test the form and let me know if it works for you. I will then guide you step-by-step on how to do it.

    If not, we will try to create another workaround.

    Feel free to clone the form to see the conditions.

    We will be waiting for your response.

  • Profile Image
    Zahra_S
    Answered on December 22, 2020 at 10:55 PM

    You must have noticed that the total price isn't showing in the Stripe Payment field, and that's because I don't have Stripe connected. It will work when Stripe is connected.

  • Profile Image
    zoomadmin
    Answered on December 23, 2020 at 06:03 AM

    I have a DIFFERENT PROBLEM that i want to describe - to see if I can get a solution.

    IF a user enters 2 in (Number of courses selected)

    and then subsequently DESELECTS one of those courses - using the DESELECT option

    The entry in Number of courses becomes INVALID and passes on a discount that should NOT be passed on.
    Can we create a conditional logic so that if any of the deselect Radials are hit AFTER the user has entered a value in 'Number of courses selected ' that the existing value in 'Number of courses selected ' gets wiped or deleted - therefore prompting the user to enter the new correct number?

    1608721013_5fe32275648fe_Screenshot 2020

  • Profile Image
    Lorenz_A
    Answered on December 23, 2020 at 06:40 AM

    Hi there,

    You can use the Update/Calculate Field condition in order to achieve that. You currently have 12 items that have the DESELECT option. You can set up the condition to clear the Number of courses selected field if any of the items are equal to DESELECT.

    Please see the image below.

    1608723498_5fe32c2aadb81_test - 2020-12-

    As you can see in the image above, I've set the Number of Courses Selected to be empty if any of the items are deselected.

    Here's a cloned version of your form where the condition is applied: https://form.jotform.com/203572321211945

    Kindly check the form to see if the condition does meet your requirement.

  • Profile Image
    zoomadmin
    Answered on December 23, 2020 at 10:58 AM

    Thank you - looks like that worked thanks to all!