I use the trick of user tables a lot:
Each of my docs has a users table (urUsers, in the below examples), with a bunch of columns representing user specific settings.
In that table’s page, I have a named formula:
I then reference CurrentUser formula everywhere in my doc for user specific filters, restrictions etc. This worked like a charm , until today.
Today, when I open any of these docs, the value of CurrentUser is a blank, thus breaking all my dependent formulas.
The only way to get it to calculate is to navigate to the page where it and the UrUsers table live, at which point it immediately calculates. For the most of my users, this is a hidden page, and so this trick is not a valid solution.
Hi @Nad , thanks for reaching out and sorry to hear you’re running into this issue. In order for us to test this, we will need access to your doc. You should be able to share by going to the Share in the top right-hand corner, clicking the button in the top right (to the left of the “X”), and toggling on Share with Coda Support(the gif below shows how to do this).
Afterward, please send us a link to that doc in your response so one of our Customer Champions can take a look for you!
Thank you for reporting the issue. We’re looking into the issue.
For the context, we were experimenting with performance improvement to reduce unnecessary calculations. It should still trigger calculations on a hidden formulas if it is used in the current page, but there is likely a bug in the logic that lead to this affecting your docs.
The experiment has been disabled until we figure out the root cause.