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.
Spreadsheet Time Card FormAsked 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.
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.