net.twisterrob.inventory icon indicating copy to clipboard operation
net.twisterrob.inventory copied to clipboard

Allow "specialized" fields / attributes / parameters / properties / key-value pairs

Open jlsjonas opened this issue 9 years ago • 36 comments

Related to #45, allow certain extra fields. by default or in settings (allowing adding/removing field-names, with select types (text, date, price and optionally field would be a great start) that would be available for every item, and would preferably have an optional default value.

long-term allow filtering fields to categories and adding extra types such as image/video

default items I'd add:

  • Purchase date : date (alternatively: valued)
  • warranty period : "month" selector (x months), with default value in settings (for warnings long-term)
  • Cost (while you're at it) : price
  • Barcode/QR field : text (see also #43)
  • Receipt : image (see also #45)
  • Temp. location: Storage (see also #47)
  • Quantities (see also #38)
  • Brand
  • Color

jlsjonas avatar Sep 11 '16 05:09 jlsjonas

I was thinking about this too, and some people requested custom key-value pairs. I though about implementing it with "field groups" and you can associate those field groups to categories. Maybe field groups can inherit from each other to prevent duplication.

Question is how would this affect import/export and sharing inventory backups between users. What if another user has a different set of key-value pairs? Would you create field groups to support items in the backup upon import? Share the field group settings in a separate file?

TWiStErRob avatar Sep 11 '16 08:09 TWiStErRob

I would include field groups in the backup, using a UUID as key for the item values, and importing said groups (preserving UUID) first.

Additionally you could add name+type matching in the future, to avoid duplicates when importing into existing dataset, but would add more complexity (and shouldn't be prioritized until everything else supports it)

jlsjonas avatar Sep 11 '16 17:09 jlsjonas

There's duplicate checking currently at import, if an item already exists in a parent it's not imported at all, because the DB schema forbids <parent, name> duplicates. UUID is probably something I should've already done for items...

TWiStErRob avatar Sep 11 '16 17:09 TWiStErRob

that made me think of a new idea... related to #33 it seems...

UUID is probably something I should've already done for items...

yes and no... if the same item was already added manually before an import, one would have the same item twice. if such conflicts rise, I think the best course of action would be to let the user decide (show them the conflict, give them option to pick one, or saving both (by making a subtle name change)

jlsjonas avatar Sep 11 '16 17:09 jlsjonas

The conflict resolution is in #25. #33 is about sharing the list as in sending it as text.

TWiStErRob avatar Sep 11 '16 17:09 TWiStErRob

the "new idea" was #53 , but moved that into a different issue ;)

jlsjonas avatar Sep 11 '16 17:09 jlsjonas

from https://mail.google.com/mail/u/0/#inbox/1575cbb296f9fd48

It would be extremely valuable if I could assign a dollar value to each inventory item and then be able to report on the asset values in total, by property, or by room, etc. I'd also like to be able to select individual items from each room and report on the combined value of all selected items.

TWiStErRob avatar Sep 24 '16 15:09 TWiStErRob

https://mail.google.com/mail/u/0/#inbox/158bfd41d044b7ed also asked for this

TWiStErRob avatar Dec 02 '16 15:12 TWiStErRob

https://play.google.com/apps/publish/?account=7995455198986011414#ReviewDetailsPlace:p=net.twisterrob.inventory&reviewid=gp:AOqpTOFU8xQtN5BgtwI0nUeeuC0_FlVbm8ldfb4CVAtevjEvnrtygGA-9cu0taS5KSM207-vqAbPV_l52BON

TWiStErRob avatar Jan 15 '17 23:01 TWiStErRob

https://mail.google.com/mail/u/0/#inbox/159cd81305a2b8c3

TWiStErRob avatar Jan 23 '17 23:01 TWiStErRob

https://mail.google.com/mail/u/0/#inbox/159db2f298935969

TWiStErRob avatar Jan 26 '17 16:01 TWiStErRob

https://play.google.com/apps/publish/?account=7995455198986011414#ReviewDetailsPlace:p=net.twisterrob.inventory&reviewid=gp:AOqpTOE2Rp8O8Hv3OTeiwNRF3RcvBoUXgBv4_fNyIMRbul8ZD1ujuoiJtLM4sXSCknzpXG1d860ZzzRc0hZE

TWiStErRob avatar Feb 22 '17 23:02 TWiStErRob

https://play.google.com/apps/publish/?account=7995455198986011414#ReviewDetailsPlace:p=net.twisterrob.inventory&reviewid=gp:AOqpTOFU8xQtN5BgtwI0nUeeuC0_FlVbm8ldfb4CVAtevjEvnrtygGA-9cu0taS5KSM207-vqAbPV_l52BON

TWiStErRob avatar Mar 04 '17 18:03 TWiStErRob

https://mail.google.com/mail/u/0/?zx=hpc9wquw0915#inbox/15ab63e1bb62c59a

TWiStErRob avatar Mar 10 '17 13:03 TWiStErRob

https://mail.google.com/mail/u/0/#inbox/15afbc2d01e497d2

TWiStErRob avatar Mar 23 '17 15:03 TWiStErRob

https://mail.google.com/mail/u/0/?zx=z1pbsdx306za#inbox/15b37c5dd9eac200

TWiStErRob avatar Apr 04 '17 09:04 TWiStErRob

https://mail.google.com/mail/u/0/?zx=56cnoe7afuos#inbox/15caaa2b43f516cb

TWiStErRob avatar Jun 15 '17 08:06 TWiStErRob

https://play.google.com/apps/publish/?account=7995455198986011414#ReviewDetailsPlace:p=net.twisterrob.inventory&reviewid=gp:AOqpTOGafuXdAcepD_2PIi6tH1k5M-GFEPZkKxjTseAKKPaZtEkF3Jrdrfe91Q1hLngnEbRgJUC4p40cJirF

TWiStErRob avatar Sep 07 '17 23:09 TWiStErRob

Price: https://play.google.com/apps/publish/?account=7995455198986011414#ReviewDetailsPlace:p=net.twisterrob.inventory&reviewid=gp:AOqpTOHadMt59kCK98ZJz5TfJnrVe1UIJZhCI6pUhA-huWnSkVudSG8ZI_ddcjlyp9rzHZsRDKdF9fJWaaXb

TWiStErRob avatar Sep 12 '17 22:09 TWiStErRob

Price: https://mail.google.com/mail/u/0/#inbox/15ef9183d3298d32

TWiStErRob avatar Oct 08 '17 06:10 TWiStErRob

Price: https://mail.google.com/mail/u/0/?zx=ujar6imj23ho#inbox/15f44d2afc2ea1ee

TWiStErRob avatar Oct 22 '17 16:10 TWiStErRob

date of purchase, cost, estimated value: https://mail.google.com/mail/u/0/#inbox/15f756c1a1bd3293

TWiStErRob avatar Nov 01 '17 09:11 TWiStErRob

Value (price) https://mail.google.com/mail/u/0/#inbox/160a3cebcbae727c

TWiStErRob avatar Dec 29 '17 20:12 TWiStErRob

https://mail.google.com/mail/u/0/#inbox/160b39598672cbfc

TWiStErRob avatar Jan 01 '18 21:01 TWiStErRob

Value: https://play.google.com/apps/publish?account=7995455198986011414#ReviewDetailsPlace:p=net.twisterrob.inventory&reviewid=gp:AOqpTOHRcZk5iDNGmnIhEYs2C-_flRtM7bOo-An2dPsUm01AmSStl-HOquRuKWCZfWkO1YGpzv91-nE8qxCx

TWiStErRob avatar May 13 '18 14:05 TWiStErRob

original price (some second hand) Rooms have totals for Original Price & Today's Value and then a total for that Room https://mail.google.com/mail/u/0/#inbox/FMfcgxvzKbRHTqJnHbMGWQRZnLWmxqKg

TWiStErRob avatar Sep 22 '18 13:09 TWiStErRob

number of items date of purchase, price,... https://mail.google.com/mail/u/0/#inbox/FMfcgxvzLDtFlmzhgbbnQFNqfHjDvwZB

TWiStErRob avatar Oct 20 '18 15:10 TWiStErRob

Family/Private https://github.com/TWiStErRob/net.twisterrob.inventory/issues/46

TWiStErRob avatar Oct 20 '18 16:10 TWiStErRob

monetary value https://mail.google.com/mail/u/0/#inbox/FMfcgxwBTjxhjnDFNqHKKgNsNHczqBbZ

TWiStErRob avatar Dec 21 '18 14:12 TWiStErRob

expiry date: https://mail.google.com/mail/u/0/?zx=bld3kygu3hnb#inbox/FMfcgxwBVztVVQbWGmHrscprWpDZmlrQ

TWiStErRob avatar Mar 08 '19 18:03 TWiStErRob