How to create a monthly time sheet

  • nolimitssports
    Asked on October 7, 2019 at 3:29 PM

    Hi , we currently use Jotform to register Sports Coaches that come and work for us and now want to explore another possible application.  Our coaches submit monthly timesheets that show where they worked, number of hours, dates/times etc and hourly pay rate. We currently use a simple excel spreadsheet but some coaches are not very IT literate and have difficulties completing the form each month.  It may be easier all round if we could have a simple jotform that each coach could complete each month. It needs to be as simple as possible but needs to include formulas that can calculate hours worked from start and finish times and total pay from hours worked x hourly rate.  Is it possible to set up a form of this type?  If so please provide some advice.

    Jotform Thread 1991979 Screenshot
  • Ivaylo JotForm Support
    Replied on October 7, 2019 at 5:02 PM

    You can use some of our ready templates. You can customize some of the templates, in order to meet your requirements. You can search for a suitable template here:

    https://www.jotform.com/form-templates

    You can also create a form from scratch. You should use the Form Calculation widget, which will help you to make the calculations in your form. Here is the guide:

    https://eu.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

    I would recommend you to start to build your form in the Form Builder. Then when you have the basic structure, we can help you to fine tune. So, please give it a try and let us know if you need any further assistance.