Question

Forms / Workflow

Workflow

Updated July 18

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

Replies

replied on July 17

Hi Blake -
Thank you! I had set it up that way previously but the test would state 0 rows so I was probably overthinking what I was doing!

1 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

replied on July 17

So I have gotten further on my process. However I am trying to do a custom query in workflow back to the table so I can insert the clock out time in the HuntEnd column. However running into some errors. I can easily just write the clock out time in as needed not issues but I want to try to group it together.

When I run a test on the custom query that I have setup I get the query error listed below. Curious what I have setup wrong. If I change the paramenter names to ? then I get 0 results.

The database type is Sql (ODBC)....

custom query.jpg (70.68 KB)

| Download

database table.jpg (35.37 KB)

| Download

table.jpg (35.11 KB)

| Download

workflow .jpg (10.5 KB)

| Download

query error.jpg (23.51 KB)

| Download

0 0

replied on July 17

Replace each of your Parameter Names with a ? in the Query Editor and replace them in the query itself.

0 0

replied on July 18 • Show version history

So I have gotten this process really close to complete. However, in my lookups now for clocking out I am hitting a snag if the hunter has more than 1 hunt in a day. I tried to use _(DB.NULL) for clock out but then I don't get any results.

I want to allow the hunter to clock out if there is a start time.

Has anyone done this before...

I appreciate all the help !

0 0

You are not allowed to follow up in this post.

Question

Question

Forms / Workflow

Replies

Sign in to reply to this post.