JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
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?
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.
Thanks already done integration. But it is a one way communication from
form data to sheet.
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!