+ Start a Discussion
Mark Neill 13Mark Neill 13 

Need to Update User Look from text box in custom object

I receive a feed of employees I load into a custom object. It has the employee number from another system.

I need to be able to update another  LOOKUP field  (relationsjhip is the User table) based on the employee number the user enters.

The employee number is a field in the USER table  ..so I need to match on it and return the userID to the empty lookup field

Can this be done with a workflow or process builder.  

Example:

Text fied value  Employee Number = 50410 
Need to relate that value to the user.employeeID
and  return the user.ID to a seperate lookup field  
 
harsha__charsha__c
Hi Mark, 

I beleive you can acheive this by using visual Flow and a process builder. 

I wish salesforce delivers this idea in near future, which makes your job very easy.. : https://success.salesforce.com/ideaView?id=08730000000BqPsAAK  (https://success.salesforce.com/ideaView?id=08730000000BqPsAAK " target="_blank)

- Harsha