Hello again 
I’m having a cross-synced table. In the target doc, I’ve added several new columns to this table (that are not synced but part of the sync table).
If I add a “value for new rows” without formula (so just a value) this works as expected. But if I add a formula based value for new rows, i.e. a lookup via dot (.) operator or a condition, nothing is happening. The same formulas are working as expected on non-synced tables.
So it clearly looks like a bug to me.
Can you reproduce this as well? Is there a way to fix this?
Thanks a lot,
Jann
Literally any formula? Like even Sum(2,2)
Thanks for your answer!
Hmmm no, this works actually. But as soon as it should work with a lookup to another column, it’s not working anymore. If I add the same formula not as a “value for new rows” but as a “fill value” it works. Can you reproduce this?
I have a hypothesis - but can you send screenshot of your setup?
Sure! Heres a screenshot from the formula i’d use (and that works locally if it’s not a sync table):
So the “Calendar Event” is the reference to the current row that is open in detail view and filled out automatically if you create a new ToDo, and the Organ should be referenced as lookup from this event.
