Hi Monday geniuses,
My organization is using Monday.com to keep Database of our TV channels, their real time position according to satellite channel list and technical specs for each channel in several columns.
I have the automatic numbering column handy to number each channel according to the order they are presented to the customer but because we have over 1000 channel spaces and perhaps 200 channels occupying these spaces, there are a lot of empty spaces.
These spaces are important to keep. For example, a channel could be assigned to position 28 and then the next channel on the list will be assigned to position 50. The in-between are empty spaces named “Free” which are technically items with no data other than their position in the list.
Sometimes we need to terminate a channel and when that happens I would like to archive the data of that channel and timestamp exactly when the termination happened for historical archiving. However, I can’t just delete the item because by doing that I mess up the positioning of every channel that comes further down the list, due to the automatic numbering column.
I currently name every empty channel “Free”. Then I filter on the default view, all items named “Free” so its easy to view the channel list without the endless scrolling through empty spaces. So by naming a channel “Free” it is filtered out of the public view automatically.
My question to you dear Monday-aficionados:
Is it possible to automate the following:
- Copy item.
- Change copied item name to “Free”.
- Clear all columns of the copied item.
- Archive/Move the original.
- Timestamp the moving/archiving of the original.
If this is possible, it would save us so much effort and lessen any mistakes my colleagues might do that could mess up the entire board.
I look forward to your creative solutions.
Thank you !