Creating a Time Card form

  • rkelley
    Asked on June 14, 2017 at 3:50 PM

    I am trying to automate our time card that happens for every 2 week period. I have our current excel document pic attached. I also have a few options I was trying to play with for the calculations. I have the week of thru the week of programmed fine. I tried to have dates above but they also are longer...I would like them the same size as the time of in and out. Programming and calculating the hours is another story. I have a table that adds the columns as numbers (I only put calculations in the first two columns for now) but it would be better to have time or military time so there's less chance of mistakes. Also, I played around with the idea of having a time range and it would calculate each range but it would work better going up and down instead of sideways. We need 4 in and out options for the possibilities and then a total for each week and then a grand total for the two weeks. Any suggestions? Are either of these suggestions better.

    Jotform Thread 1173630 Screenshot
  • jonathan
    Replied on June 14, 2017 at 5:40 PM

    In my assessment I think it will be very difficult to convert your current Excel document and make it function similarly using the form. There are just too many differences in functionality between Excel and the form that will be a challenge to convert.

    What I think will work is to make the form simpler. Do not put every bit of details of data into the form itself. What you can do make the form and Excel compliment each other.

    I also suggest converting your Excel sheet to Google spreadsheet, for reason I will explain more below.

    ---

    After creating your form, you can try using the Spreadsheet To Form Widget to populate your form with data from your spreadsheet.

    link: https://widgets.jotform.com/widget/spreadsheet_to_form

     

    Creating a Time Card form Image 1 Screenshot 20

     

    You can use this widget to map your spreadsheet cell value to a field in the form. It will populate the form with data from the spreadsheet to a field in the form when mapped correctly.

    I hope this help. Please let us know how it goes.

     

     

     

  • gouldca
    Replied on June 18, 2017 at 10:13 PM

    In the Spreadsheet to Form Widget, how do you upload a Google Sheets document?  It seems that I can only upload a file located on my hard drive. 

  • Chriistian Jotform Support
    Replied on June 18, 2017 at 10:53 PM

    @gouldca,

    It seems that you have opened a thread with the same question. We will answer your question in this thread shortly: https://www.jotform.com/answers/1176996.

    Regards.