Spreadsheet Time Card Form

  • Profile Image
    Asked on February 01, 2016 at 11:49 AM

    I have tried multiple things over the past few weeks, and Jotform has gotten me the closest to getting what I want.  I have made excel documents.  Turned the excel documents into pdf's and made a form that way.  There just wasn't a way to make a table that I could edit and submit at the same time.  Okay, for the date section, I would like the rest of the dates to auto-populate after filling in the first one.  So if I were to type in 1/22/16, it would populate the rest as 1/23/16, 1/24/16, etc.  Also, for the total hours section, I need it to automatically do the math.  So if Start time is 08:00, and end time is 16:00, the total hours would say 8.  I would like it to look as close as possible to our current time cards, which I have attached an image of.

  • Profile Image
    Answered on February 01, 2016 at 02:16 PM

    I see you are on a guest account, I strongly suggest that you register an account to us so that you can easily edit your form when needed.

    Regarding the time card form you want, perhaps using the Matrix field would work? Here's a guide about it: http://www.jotform.com/help/343-How-to-perform-form-calculation-in-the-Matrix-field 

    If you would like your users to edit and resubmit the form, that should be possible by providing the edit link. Here's a guide about it: http://www.jotform.com/help/40-How-to-Let-Users-Update-Their-Form-Submissions-at-a-Later-Date 

    Or you can recreate the table using simple text boxes, then use the form calculation widget or conditions to prepopulate fields or do calculations.

    Here's a guide on how to do calculation on your forms: http://www.jotform.com/help/259-How-to-perform-calculation-in-the-form 

    Here's a guide on how to take advantage of the conditions feature of our form builder: http://www.jotform.com/help/57-Smart-Forms-Using-Conditional-Logic 

    I hope that helps.