i have a custom lookup field - field1 which looks up to User object. and another text field - field2 which contains the username. i want to fetch the id of the username from field2 and pass it to field1 . so that lookup field also will contain the same username. field2 is being populated by informatica. i have written this trigger but somehow does not seem to work.
trigger updateEmployeeId on Peoplesoft_User_View__c (after insert, after update) { if (Trigger.isBefore) { if (Trigger.isInsert) { for(Peoplesoft_user_view__c p : trigger.New){ // ppl = [ select employee_name__c from Peoplesoft_User_View__c]; User u = new User(); u = [select ID from user where Username =:p.employee_name_text__c]; p.Employee_Name__c = u.ID; } } } }
i am writing a formula field on User object which access CreatedBy ID field. but does not seem that i can access that field. it does not appear when i click on Insert Field button. does any one know how to access that field or any other work around?
i need some guidance on how to perform this task. i have a custom field - user license in a custom object. this field should populate the value from standard license i.e from profile . how can i do this?
i am writing a formula field on User object which access CreatedBy ID field. but does not seem that i can access that field. it does not appear when i click on Insert Field button. does any one know how to access that field or any other work around?
i need some guidance on how to perform this task. i have a custom field - user license in a custom object. this field should populate the value from standard license i.e from profile . how can i do this?
