How to add a date range in form and calculate amount?

  • Profile Image
    lgbs
    Asked on September 04, 2017 at 12:59 AM

    Hi

    I can't seem to get a date range option.  Can I set up where someone puts a from and to date and then adds a dollar amount?  Similar to:

    From _______________       To  _____________________    Amount $ ____________________

     

    Thanks

  • Profile Image
    ashwin_d
    Answered on September 04, 2017 at 05:21 AM

    Please note that you can add date range option by adding "Dates Difference" widget in form. This widget will display two date field in form and it can be used to get the difference between two dates.

    You can then add "Form Calculation" widget in form to calculate the amount based on the number of days. 

    I would suggest you to please explain your requirement a bit more in detail on what you want to achieve and we will try to help you.

  • Profile Image
    lgbs
    Answered on September 04, 2017 at 05:43 AM
    Hello

    I provided an example of what I was trying to achieve, I am not sure how much more descriptive I can be.

    I am in need of a suggestion with regards to payment. I use Pin Payments, which is not an option on the payments list. Could you suggest how I can work around this so payment can be processed?

    Thank you
    Lisa

    ...
  • Profile Image
    ashwin_d
    Answered on September 04, 2017 at 07:41 AM

    That is what I was trying to understand on how to calculate the amount for payment. Adding a date difference widget or adding two dates field will solve your problem but how do you want the amount to be calculated. Is it a custom amount user will input?

    Please take a look at the following demo form I created for you where I have added two date fields for "From & TO" date. I have also added calculation field to calculate the number of days between from & to date and multiply it by 10 to calculate the amount:  https://form.jotformpro.com/72462659068971

    Feel free to clone this form for a closer look. The following guide should help you in form cloning:  https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    Unfortunately we do not have any integration with "Pin Payments" yet. Please use one of our integrated payment tools. Please note that you can pass the calculated amount to your payment tool. The following guide should help you:  https://www.jotform.com/help/275-How-to-Pass-a-Calculation-to-a-Payment-Field