i have table Group and Employee, that have entities as shown image below
i set email value both in Group and Employee table with [email]=USEREMAIL(),
and the Group[manager name] column type is Ref, from Employee[manager name] table, as dropdown
what if everytime we input new Group data, Group[manager name] have Employee[manager name] as initial value based on email, can someone give me a clue pleaseeโฆ
Solved! Go to Solution.
Set the Initial value property of the manager name column of the Group table to this expression:
LOOKUP(
USEREMAIL(),
"Employee",
"email",
"manager name"
)
Read more:
Hi @mirw_ika! Welcome to the forum!
I may not know enough to answer your question but perhaps I can help you clarify it.
First of all, Iโm a little confused but the table you have put in your post as an image. Categories like โmanagerโ, โemailโ, and โproject nameโ would normally be at the top of your โGROUPโ sheet. The same can be said about your โEMPLOYEEโ sheet. Perhaps it would be good to start by clarifying the structure of the two sheets (tables).
thanks for the adviceโฆ
Set the Initial value property of the manager name column of the Group table to this expression:
LOOKUP(
USEREMAIL(),
"Employee",
"email",
"manager name"
)
Read more:
it work!! thanks @Steve
User | Count |
---|---|
60 | |
25 | |
13 | |
12 | |
6 |