Initial value from other table, based on email

i have table Group and Employee, that have entities as shown image below
2X_4_427e25f3cf6a9c248dcf4d3837ff00f436dab17c.png
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 Solved
0 4 442
1 ACCEPTED SOLUTION

Steve
Participant V

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:

View solution in original post

4 REPLIES 4

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โ€ฆ

Steve
Participant V

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

Top Labels in this Space