What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.

  • Profile Image

    How can i programme a leave application module which can count days left eligible?

    Asked by cgskillaccounts on October 20, 2016 at 01:28 AM

    Is there a way to link staff name entered to match with record of entitlement of days available for leave application?

    It would be great if can somehow link to googlespreadsheet when doing the references and calculation. Or need to use a stock count widget?

  • Profile Image
    JotForm Support

    Answered by candy on October 20, 2016 at 08:37 AM


    I've forwarded your question to our developers. Whenever they are going to answer, we will notify you.

    Besides, you can integrate your Jotform and Google Spreadsheet. Please check the following link: https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet

    Thank you very much for your interest.


  • Profile Image

    Answered by cgskillaccounts on October 20, 2016 at 10:44 AM
    Thanks already done integration. But it is a one way communication from
    form data to sheet.
  • Profile Image
    JotForm Support

    Answered by Kiran on October 20, 2016 at 12:26 PM

    Yes. Unfortunately, with the Google spreadsheet integration we can only pass the form data to the spreadsheet. The submissions cannot be modified with any modifications made to the spreadsheet. Additionally, any changes made to the integrated Google spreadsheet would break the integration and the form data cannot be passed to it.

    Hope this information helps!