I am trying to either edit an existing record, or create a new record with the below expression. The create new works great, but the edit existing does not populate. Any idea why? Do I need to use a slice?
IF(COUNT(SELECT(Employee override master table[Employee ID], [Employee ID] = [_THISROW].[Employee ID])) > 0,
LINKTOFILTEREDVIEW("Employee Override view", [Employee ID] = [_THISROW].[Employee ID]),
LINKTOFORM("Employee Override view",
"Employee ID", [_THISROW].[Employee ID],
"Preferred Name", [_THISROW].[Preferred Name],
"Job Profile", [_THISROW].[Job Profile],
"Job Family", [_THISROW].[Job Family Group],
"Job Category", [_THISROW].[Job Category],
"Work Location Profile", [_THISROW].[Work Location Profile],
"File Source", CONCATENATE("RTO App: ", USEREMAIL())
)
)
Solved! Go to Solution.
You wouldn't use LINKTOFILTEREDVIEW() in this case. The expression you want is:
LINKTOROW([Employee ID],"Employee Override view")
You wouldn't use LINKTOFILTEREDVIEW() in this case. The expression you want is:
LINKTOROW([Employee ID],"Employee Override view")
Of course! My brain must have been tired at the end of the day, thanks for the reminder.
User | Count |
---|---|
39 | |
32 | |
30 | |
16 | |
14 |