- ap10Asked on September 14, 2014 at 12:21 AM
I want to embed this form into my website for my employees to fill out. This form will correspond to completing a task, so ideally what I'd like is for the task's title to be a hyperlink to this form, so when clicked, the data corresponding to this task (date, time, id#) to be assigned to this specific form. The employees have to login before reaching the form, so ideally the employee's ID number would also be assigned to the form.
It could be thought of as having the task ID#, date, time, employee ID# all invisible fields on the form, but would show up when submitted and downloaded to Google sheets.
Is this possible?
- BenAnswered on September 14, 2014 at 11:00 AM
I will need to check with you first what exactly you are looking to achieve in order to be able to assist you better, so please bare with me.
If I understood you correctly, you would like to have one form, lets call it Main form.
Main form would have fields with task IDs, each linking to a different form.
Now all of these new forms would have the fields for date, time and ID number.
If that is what you are looking for, I would like to ask you if you might prefer the next option instead:
- 1 form where your employees can enter their name, last name, employee ID, task ID and task title and a button to confirm that the task is finalized?
The form would look something like this form:
On it, as you can see are all mentioned fields and the fields for time and date are hidden from view and set to show you the time they have opened the form.
This would be submitted to your spreadsheet and you could always see if the employee ID and the Full name match your internal database, as well as if they were assigned to a specific task
If this is not what you were after, do let us know.
- ap10Answered on September 14, 2014 at 12:31 PMHi Ben,
Not quite what I was looking for. A task can be imagined as an employee's
work shift. After he/she has completed his/her shift, we'd like to collect
some information on that shift. So within our database, each shift is
identified by the employee who worked it, the date of the shift, and its
hours (8-12, 4-8, etc. ).
Ideally when an employee goes to complete the form for a specific shift,
the link they click on autofills their employee ID (since they are logged
in), the date of the shift, and the hours of the shift. This way we don't
have to worry about ensuring they didn't enter the wrong information.
So main form would have a list of the shifts that an employee worked,
labeled by time and place. Then each individual label would link to the
form to be completed.
- JotForm SupportjonathanAnswered on September 14, 2014 at 06:34 PM
You can try using Webhook integration to capture initial information from form respondent.
Check this user guide http://www.jotform.com/help/245-How-to-Setup-Webhook-with-JotForm
You can find sample here http://www.jotform.com/help/248-Webhook-Samples
We will be able to provide you with better solution suggestion also if you can at least create an initial draft of the form you have in mind, and then we can enhance the form according to your specific requirement.
You can also check in the JotForm Template gallery for the specific concept of your form.
How about his template form http://www.jotform.com/form-templates/employee-end-of-day-report
Hope this help. Inform us you need more assistance.