Yes I realize, very fortunate that this problem can be fixed without compromising performance.
Just for the record: I was triggered by your original post about a formula column that could not have its values modified (which is the way Coda works). After hitting the Switch button, things get messy indeed. For one thing, I donât understand the existence of this button and indeed, if it gets activated by accident or some unknown coda workings (or perhaps there was a bug in an update) you end up with a doc that works completely different - or doesnât work correct or not at all.
I hope someone from Coda can enlighten us.
Coda has made a lot of changes, supposedly to make the power of Coda more accessible for less experienced or tech oriented users, but for me, not all changes are improvements.
2 Likes
Again, Iâm glad itâs at least fixable. 
Because I have workspaces with quite complex architecture and if the problem couldnât be solved as simply as in this case it would be âfunâ.
But definitely developers should pay attention to this bug.
Hi @Tamerlan_Kagarmanov and others - Late to this thread, but thanks so much for reporting this. This error message wasnât intentional, and it was due to a bug that was introduced last week. We found the bug earlier today and we have already made a fix. The should go live tomorrow (March 26th), and we apologize for the inconvenience.
5 Likes
Dear @Eric_Koleda, thank you very much giving feedback on the status of this bug.
@Tamerlan_Kagarmanov , great catch 
1 Like
Thank you for the feedback!
Hello @Eric_Koleda
Can you clarify a little bit? Was the bug that you could reverse the column type (which I canât find anymore)
or if can you indeed fill calculated columns with a value (through a button action)?
I spend quite a bit of time trying to figure out what @Tamerlan_Kagarmanov was showing us to be a bug, going through old and new docs - and I still donât get it. In my experience is is impossible to fill a calculated column with another value.
Thanks in advance,
Greetings, Joost
Thatâs right. It is impossible to fill the calculated column with another value. The essence of the bug is that non-calculated columns suddenly became calculated. Check out this video:
in it I show you exactly how it was in the beginning and how it became afterwards.
Note: The âSwitch relation and linked relationâ setting is only available for calculated columns.
Thank you for showing this.
I am totally lost. And I canât reproduce your issue. But I am also lost on the linked relation, which is a function, but (if switched on) allows for editing with results (and I am seeing it while it happens) that I donât understand.
I hope Eric will shed some light on this.
Greetings, Joost
2 Likes
Iâm not an expert on this system (more of a messenger) but from what I can gather we made a change that treated one-side of the linked relation as an un-editable formula, when it shouldnât have been.
Thank you Eric. I am not really enlightened, but I know your answers are straightforward and honest. Maybe weâll someday see the exact workings of these columns in the documentation.
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.