I have three tables. Item and Faves, which are both read-only, and Save, which can be edited.
I also have a user setting called Preview Mode, which is of type Yes/No and has an initial value of true.
Item has a virtual column SID with the formula IF(USERSETTINGS("Preview Mode"), "zzz", [ID])
ID is a real column which contains the keys for the table.
SID is a reference to the Save table.
Item also has a virtual column Item Value with the formula [SID].[Value]
Value is a real column in the Save table.
Item Value will never be 0 unless SID is โzzzโ or the value of ID does not exist in the Save table.
Faves has a virtual column Valuef with the formula [Itemf].[Item Value]
Itemf is a virtual column with a reference to the Item table.
Assuming that the item being referenced exists in the Save tableโฆ
No matter the value of Preview Mode, Valuef is always greater than 0, meaning that within the Faves table the value of Preview Mode is always false.
Am I doing something wrong? or is there a problem with references? My only solution at this point is to add multiple Preview Mode checks within other virtual columns, but I was hoping changing SID, which all other calculated values in my app are derived from, would be enough.
LinkedIn
Twitter
