Solved: Initial value from other table, based on email - Page 2

mirw_ika · 12-29-2019 05:30 PM

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…

Steve

Set the Initial value property of the manager name column of the Group table to this expression:

LOOKUP(
  USEREMAIL(),
  "Employee",
  "email",
  "manager name"
)