How can I change the price based on the number of employee and location?

  • Profile Image
    bmonkee
    Asked on February 22, 2016 at 05:32 AM
    Hi there, 

    I have a membership form with several different subscription levels.

    The subscription cost varies depending on the number of employees and the location of the business.

    Businesses outside of Belfast would pay more based on the table below. We currently have this setup on a different site but want to replicate it using Jotform.

     

    Here is the current version:

    http://www.belfastchamber.com/pages/16/become-a-member

     

    I would be very grateful if someone can assist, the postcode side of things is really stumping me. Belfast city centre is classed as BT1 and BT2 only. All other postcodes should be charged the higher rate automatically. The difficulty is we also have postcode such as BT13 1AA or BT19 6NG or BT20 6GT. All three of these are miles from Belfast and should be charged the higher rate but they are showing up as Belfast city Centre because they contain the all important bt1 or BT2

     

    Please advise, many thanks

     

    Paul

     

    Page URL:
    https://form.jotformeu.com/60334185022344 

  • Profile Image
    Welvin
    Answered on February 22, 2016 at 07:01 AM

    I have already answered this two weeks ago. Please check the following thread and let me know if the given workaround won't work for you.

    http://www.jotform.com/answers/764021 

  • Profile Image
    bmonkee
    Answered on February 22, 2016 at 09:28 AM

    hi thanks but i cant view this link? so thats why i reposted

     

     

  • Profile Image
    Welvin
    Answered on February 22, 2016 at 09:35 AM

    Ah yes! I'm sorry for that. I thought you will be able to view it since you've posted it using your current email address. Anyways, please find the reply below:

     

    The annual membership is currently setup to include the number of employees so I presume that is all set. 

    In our current subscription type payment, you can select a Price Source which will be a calculation field or widget. You can take advantage of this feature to change the subscription price based on the postcode and the number of employees selected.

    Here's our guide on how to calculate a field: http://www.jotform.com/help/259-How-to-perform-calculation-in-the-form

    Here's our guide on how to conditionally do the calculation: http://www.jotform.com/help/268-How-to-Insert-Text-or-Mathematical-Caculation-into-a-field-using-a-Condition.

    To illustrate how this will work in the form, I have created this form for you: https://form.jotform.com/60326061886962.

    Let us know if you need more help with this method.