Hi,
I want to create a starting view which will show the planning of the connected user.
The filtered view works when I use an action Button, but not when I put the same code in the starting view in UX / Options.
LINKTOFILTEREDVIEW(โPlanningโ, [collaborateur] = LOOKUP(useremail(), users, โemailโ, โuserโ))
thanks for help
LINKTOFILTEREDVIEW() can be used with a navigation action or a column type app.
You mentioned you invoke the action through a button and it works. So actions execute when invoked exclusively by the user or through workflow when certain data change condition occurs or on certain events such as form save. Please refer " When Does an Action Run?" in the article below.
In the case of starting view possibly, none of the above triggers is available to invoke the action.
Instead, you may wish to try the below.
Create a slice called say โMy Planningโ on the โPlanningโ table with a filter expression something like below
[collaborateur] = LOOKUP(useremail(), users, โemailโ, โuserโ)
Then create a ref summary view as you desire on that slice called say โMy Planningโ. Please set this reference view as the starting view in UX โ Options
it works , thanks a lot!
maybe adding an error/warning message when trying to use filterview as the starting page would be cool
To add another workaround to @Suvrutt_Gurjar 's answer, Iโd suggest to create a security filter on the table Planning. This would work out of the box.
yep itโs a possibility but my customer would be on the premium plan not the proโฆ so no security mechanism availableโฆ
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |