This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Are User Settings ignored in references?

Posted on 10-27-2021 02:06 PM
roquestral
New Member
Reply posted on --/--/---- --:-- AM

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.

0 3 140
Topic Labels
0 Likes
3 REPLIES 3

Posted on --/--/---- --:-- AM
Marc_Dillon
Platinum 1
Platinum 1
Reply posted on --/--/---- --:-- AM

Are you columns that you referred to Real or Virtual? Are you aware of the difference between when expression in Real columns evaluate (only when the record is edited), vs in expressions in Virtual columns (on every sync)?

Posted on --/--/---- --:-- AM
roquestral
New Member
In response to Marc_Dillon
Reply posted on --/--/---- --:-- AM

I apologize for not clarifying that all the columns are virtual with the exception of the ID column in the Item table, and the Value column in the Save table. I was also not aware of when real columns were evaluated, but none of the real columns in my problem use expressions.

0 Likes

Posted on --/--/---- --:-- AM
Marc_Dillon
Platinum 1
Platinum 1
In response to roquestral
Reply posted on --/--/---- --:-- AM

Iโ€™m sorry I donโ€™t see anything wrong. That could be because your description of your setup is incredibly hard to follow, screenshots always help. Surely there is an easier way for you to setup your required functionality. What are you even trying to do?