Calculating a number of days left when a date is plugged in.

  • Profile Image
    Doc13
    Asked on June 18, 2020 at 11:33 AM

    I am creating a form for medical equipment expiration dates. I need to know how many days left when a date is plugged in.  or some kind of notification. is it possible? 

     I have a spreadsheet in excel that I formulated to do that for me as well as turn the cell a color when a certain number of days is reached. I kindly await for reply. 


    thank you, Banks 

  • Profile Image
    Carlos_C
    Answered on June 18, 2020 at 12:52 PM

    Hello,

    Thank you for your message

    I create a demo for you https://form.jotform.com/201695227980058.

    The input table can calculate numbers but not dates, for that reason I create 2 "date picker" field with the Calculation form:

    Feel free to clone it so you can test: How-to-Clone-an-Existing-Form-from-a-URL.

    If you need any further assistance, please let us know. We will be happy to help.

  • Profile Image
    Doc13
    Answered on June 18, 2020 at 01:03 PM

    Thank you,  Im not sure, How would I plug that into my form. I used a template from your template list to create it.  

  • Profile Image
    Carlos_C
    Answered on June 18, 2020 at 01:18 PM

    Hi,

    In the screencast below you will find a few steps in how to implement the date picker and the calculation form:

    1592500471311341114111111841141.gif

    Complete guide: How-to-Perform-Form-Calculation-Using-a-Widget.

    If you need any further assistance, please let us know. We will be happy to help.

  • Profile Image
    Doc13
    Answered on June 18, 2020 at 01:32 PM

    Thank you again, I am new to the jotform world.   I am a fire recruit helping out my department on creating a medical supply expiration tracking system.   


    Actually I do have another question, how do I gather the information compiled from the forms and organize it. 
  • Profile Image
    Kenneth_C
    Answered on June 18, 2020 at 02:29 PM

    Hello there,

    I have moved your other question to this support ticket to avoid confusion: https://www.jotform.com/answers/2397961

    Please refer to the link above and I will be answering it shortly.

    Best.