Forms / Workflow

asked on July 8

Hello -

I have 2 forms setup for our Deer Hunt that we have in our City. 1 form to clock in and then a 2nd to clock out. We have to be able to track if someone is possibly still in the stand, so we use reporting for this. I would like to enhance this as at the end of the year we need to report hours / numbers back to the state however currently it is a mess.

I setup a workflow and my thought is to setup a table that has hunters information already entered so that when they clock in we just write the time back and then when they clock out it pulls the data into the 2nd form to clock out and then we write that back to the table so we have both times.

however I am stuck as a hunter can go out multiple times in a day, so trying to figure out a way to track correctly. Any idea's would be great. Maybe I need to do a check on the clock in to confirm they aren't already clocked in?

0 0

replied on July 9

Hi Suzanne,

I think it would be better to do the clock in check to make sure that each clock in has a clock out match.

For example, if a hunter clocks in and the system finds the hunter has already clocked in, we can have different ways to handle this case. If the submission time are very close (like 1 minutes), maybe the latest clock in is submitted by mistake, we can ignore (remove) one of them. If the submission time are not close, it means the hunter did not clock out properly last time, we can let the hunter resubmit the clock out and then continue the clock in.

If above suggestion is not enough, please provide more information such as the screenshots of workflow definition and forms if could.

Thanks!

0 0

replied on July 10

This is exactly what I would like to do.

Where I get confused is how to do the "checks" part. I know I will use sql to write data to a table on clock in. However, I am probably over thinking it when do the check on the form side.

0 0

Question

Question

Replies

Sign in to reply to this post.