Hello all!
here my needs:
the user fill some data creating a report. This report has a state "toBeFinalized".
Once the state is equal "toBeFinalized" , the supervisor of the user that created that report need to receive an email. The supervisor must be able to see and modify all rows created by all users assigned to him.
How can I structure something similar?
I was thinking to:
what do you think? (ps how? )
Then, the supervisor should receive an email with the report to be checked, but step by step 🙂
Thank you very much!
Solved! Go to Solution.
So some quick notes on this
OR(
ISBLANK([State]),
ANY(Select(User[Type],[Login Email]=UserEmail()))="Supervisor"
)
Simon@1minManager.com
So some quick notes on this
OR(
ISBLANK([State]),
ANY(Select(User[Type],[Login Email]=UserEmail()))="Supervisor"
)
Simon@1minManager.com
@1minManager hello!
Thank you for your answer!
For the moment, I've solved point 1 using 2 different tables: one as users and 1 for the supervisor.
In this way, I can easily linked the users to their supervisor and implement a kind of logic like "who should check what and who".
But, I think that your solution it is better in term of DB structure.. I will try to implement it a little bit later (for the moment I'm working on a Proof of Concept)
User | Count |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |