I found an unsolved problem and would love to hear your solution. I have multiple boards with prime keys and link them together with foreign keys. I can connect boards and generate mirrored columns, until here everything is fine.
However, when I want to create an automation with the value of mirrored columns, no automation can read the mirrored column’s value. I use Python to connect API and read the item value. It turns out those column values are empty.
I looked around in the community here. It seems that the mirrored column only supports “status” type value. However, when I export the board’s data to excel. It shows the complete data on the mirrored columns. If this export function can work, why API cannot read the value of the mirrored column, this completely confuses me.
Is there some way to get the text of the mirrored column but I don’t know? Could you please help me out? Thanks a lot!