How to obtain the name of a superior department
In YIDA, you can configure formula DEPTNAME (members) in a single line of text to obtain the department where the specified person is located, so how to obtain the superior department of the current login person, we need to judge in two cases.
- 1. The current login belongs to a single department and has a supervisor.
- 2. The Current landing person belongs to multiple departments or has no supervisor.
1. The current login belongs to a single department and has a supervisor.
Idea: use the user(2) formula to obtain the supervisor of the superior department, and then use DEPTNAME (member) to replace the member with the obtained supervisor.
Obtain the Department of the current login person (1)
2. The Current landing person belongs to multiple departments or has no supervisor.
2.1 Use the intermediate table to obtain the name of the superior department
If there are multiple departments or no supervisor, then it is not applicable to the first solution. Therefore, the members and departments should be entered in sequence by using the intermediate table, and finally 「Data LinkageIn this way, member components are linked out of the department as conditions.
Obtain the Department of the current login person (2)
2.2 Effect demonstration
Note: The member component is replaced with a single line of text because the non-logon component cannot be enabled.
Click the form to add the name and department name:Click View
Click the form to view the effect of obtaining the name of the superior department:Click View
3. Try it online
https://www.aliwork.com/bench/coe? tplUuid=TPL_STI8U7058ZZ1HWBYLW3B
YIDA in order to better optimize the content and quality of YIDA user manual, it takes you 3-5 minutes to fill in the document feedback questionnaire. The document feedback questionnaire is submitted anonymously, and the questionnaire information is only used for YIDA document experience feedback collection. Thank you for your support for YIDA!
-------------------- Get the latest information YIDA, welcome to follow US--------------------
