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

    Spreadsheet Time Card Form

    Asked by Mitchell  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.

    Page URL:
    https://form.jotform.com/60314429379156

    Screenshot
    card JotForm excel table section
  • Profile Image
    JotForm Support

    Answered by Charlie 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.