Production flow control scanning QR codes

Hello there, I’m pretty excited to start my first Appsheet project. My idea is to create an app that helps us control the production flow in a small factory.

Each product has a tag with a QR code.

The production process has several stages:

  1. Cutting
  2. Sewing
  3. Quality Control

I would like to give the operators in the different stages a user name in the new app that will allow them to scan the QR when they start working on an item and then scan once they’re finished.

I think the way to go is to have a google sheet where every row is one item and we have 3 columns for each stage: Operator, Start Time, Finish Time

The problem is that I have no idea how to populate this table, would appreciate any kind of guidance. I’m not looking for a long detailed explanation on how to do this, just some general lines or ideas on how to make this happen, I’d like this to be a practice app where I get better using Appsheet.

Any help is welcomed, thanks in advance.

Any ideas on how to create this chain of actions? Or the different tables needed?


What have you tried?