The last couple questions I had here were answered perfectly (and actually gave me enough insight to refine more questions and find some answers myself), so Iโm hoping the same can happen again.
I have a table filled with products, tracked by UPC. As anyone who has inventory knows, over time we can miss scanning something, or things can go wrong, so Iโd like to create a daily cycle count to help keep up on my counts.
To begin, Iโve added a column to the table called โLast Editedโ, and populated it with Jan 1, 2021 (as a working โoldโ date)
Ideally, each new day that I launch the app, Iโd like it to populate a slice with a random assortment of the 20 oldest records as indicated by โLast Editedโ, and then change that same column to the current date.
Theoretically, this should result in a rolling list of items, so that by the time Iโve cycle counted everything, the oldest things changed will roll back onto the list.
I can provide more info if needed, or if anyone knows of a similar question thats been answered previously that I could read through that would be appreciated, my google-fu has failed to find anything with the keywords Iโve used.
LinkedIn
Twitter
