I cannot refer column from user setting

[syedfaheemuddin]

I have a column Current quotation in user setting table.

This is ref to a table and the value is the maxrow to get current quotation

I used current quotation from user setting in format rule so that it highlights the current quotation. But the row with current quotation is not highlighting.

 

I am using current quotation at many other places as well but it's not working altogether

Please help me with this. Thanks.

[MultiTech · Accepted solution]

This specific use of user settings is what I call a seesaw bug.

You should avoid doing things like this

There is an inherent problem with grabbing a value from user settings and using it elsewhere; it will work most of the time, then app sheet will release a new update and it will break, then they'll fix it, then they'll break it, then they'll fix it, then they'll break it.

I can't build mission critical software with stuff like that going on, you know what I mean?

Instead I make use of the current user system, and utilize that in some way to bring forth the behavior I'm looking for. Whether it's an enhanced dashboard, or a way for the user to specify what they're working on at the beginning of their workflow, with the current user system in place there's a way to do it.

[syedfaheemuddin]

Annnd what is current user system? @MultiTech 

[syedfaheemuddin]

If it is this, then it's awesome.

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Current-User-Slice-How-to-conform-your-app-aroun...