Hi Alex, I went through the same thing so i know the frustration, fortunately I have 2 suggestions for you:
-
there are some very user friendly in-Monday apps that can copy item id column to a text column (like column magic or auto-id), but those are paid apps with very limited free tiers.
-
if you still want a workaround you can try what i did for our account:
I. create a ‘transient board’ that creates the data in the first place, have an
item id column in that board.II. make an automation to move the item to a second
board and just cast the item id column to a text or numbers column
(moving an item makes sure it keeps the same internal id).
This workaround works as well for other kinds of ‘limited’ columns.
One thing i would be careful is not triggering the automation by item
creation, because it may lead to data loss (If an item is created then immediately moved, it may not carry all its data). for example try when item created → change status ,and then when status change → move item.
Hope that helps