Hello there ! Recently, I tried to implement a somewhat complex behaviour with Grist.
I wanted to filter the dropdown of a column of type “reference” depending on the user.
For example, a boss should be able to select only its employees. To implement this behaviour, I added a user attribute “key” referenced by the email of the current user, and I tried to use this key in the “dropdown filter” formula.
But I encountered a seemingly undocumented problem: I cannot use references (like choice.Boss.Name) in this formula. No error, but the dropdown is empty.
I was able to reproduce the issue: Bug selection demo - Grist
I also noticed that this kind of limitation is present in the user access rules. You cannot use a chain of references. I have some use-cases where it is very hard to bypass this limitation.
Do you know if it is intended ? Should I open an issue to the repository ?
Thank’s !