If I were doing this, I think I’d use inventory tracking to keep track of the paid/unpaid hours/money state.
In the simplest case there would be two logs to complete the cycle then - one that credits the hours against a balance, and a second that “settles” the balance when the hours have been paid.
The nice thing about this is that it captures the potential many-to-one relationship between work events and payment events, but provides a convenient place to upload the receipt/invoice photo on the payment log.
I just needed a simple way to track workers hours for starters. I might go further on this.
Would be a nice to semi-automatic track my own hours too. Clock in/out with a hard button by the barn door or something.
I should dig in and try to make a quickform for this. But for my workers to use it, I would need to give them full access to my data. I don’t like that.
Node-Red is great that way.
Tempted to learn about the inventory features, I came up with a dashboard for tracking diesel usage.
A button to fill up the diesel storage. And a form to fill up a tractor with the given quantity.
The storage is decremented, and the tractor is incremented.
That gives a way to track diesel usage pr tractor too.