Location feature idea - feedback wanted

[samturner3]

Location feature idea

Can I get any comments on if people will find the following useful, and opinions on how it should work (before I spend more time on it - started a PR for first steps of DB migration / model updates to add a 'location' table):

It would be great to have 'location' as a separate database table, rather than string on a spool.
This will allow us to print labels for locations, then scan a QR code label for a location and see what spools are in said location.

Feedback would be appreciated with and concerns / requests. @Donkie ?

Feature ideas:

• Add UI screens for location model - including update spool location UI
• Add a locations page - include view to see list of all spools in a location
• Re-arrange spools between locations UI (drag and drop?) (stretch goal)
• Add ability to print labels with QR codes for locations - upon scan show view to see list of all spools in a location

Background:

Just wanted to introduce myself 👋 I'm Sam. I have already contributed and hope to contribute to this great project further.

This is the google sheets based project I have been using to track my spools;
https://www.printables.com/model/498719-filament-tracking-with-google-sheets-qr-codes

I found myself diving into appsScript to add features, but stopped myself as this project (Spoolman) I feel is the more 'correct' way (database based vs sheet based) for doing more advanced things.

A few things it has over this project include;

• spool URL based QR codes (now implemented in Spoolman)
• location based URL QR codes - I actually implemented this on the sheets project myself - not public.