- maineventsecurityAsked on October 07, 2015 at 06:06 PM
Hi Guys. I think this is a bit of a long shot, but there might be a solution from thinking out of the box which jotform can assist with, here goes...
I currently use excel to collate various timesheets (rows consist of: date, staff name, start, finish, total hours, £ph, etc) I then use a filter and group all the rows that are for 1 staff name, copy and paste that group into an email and send out to the staff member. They can then check to make sure they are happy with the timesheet and I then run payroll based on the timesheet. As you can prob imagine this can take a while when there is over 100 staff.
Is there anyway of uploading all the data from the timesheets into something which then automatically filters it and sends the specific timesheet information all out to the individual staff members. They can then check and submit a form if they have any queries about their own timesheet.
Any suggestions would be gratefully appreciated. I am open to all ideas about this. Thanks :)
- JotForm SupportChriistianAnswered on October 08, 2015 at 02:22 AM
Do you mean you want your staff to receive the submissions based on the user's input? It can happen if you setup different email notifier. There is an article regarding sending email based on user's selection here: How to send to a specific email address based on a selection. In this approach the staff can receive the submission details via email depending on the conditions you set to your form.
Do let us know if you need further assistance.