Automated Timesheets

Andrew Skaggs

Hello,

I'm not sure if this is the correct section to ask this, so if not then I apologize. I'm looking into the possibility of creating an automated timesheet system using a scannable barcode (or QR code), so that once scanned, there is an automatic "clock in" or "clock out".

In testing I was able to scan barcodes/QR codes without issues, however after scanning a manual adjustment of time needs to be made.

My question is if I'm overreaching functionality or is this idea possible? Am I able to point a Time formula to a cell or column in order to record the time of a scan? I'm just not sure what to do so any help would be appreciated.

Thanks

Andrée Starå

Hi @Andrew Skaggs

I hope you're well and safe!

It's possible, but it's pretty advanced. I developed something like this for a client to track how material flows through a factory. (how long time on each station)

I used QR codes in combination with the URL-query feature.

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrew Skaggs

@Andrée Starå Thank you for your insights on this idea. It seems like this was a project that was easier said than done lol. Anyway I do appreciate the insights and direction on the subject so thank you.